Free Udemy Courses
Trending

Basics of Database Design & Development

PUBLISHER:- Creative Online School

LANGUAGE:- English

PRIZE:- 112.80$ 0$

Basics of Database Design & Development

WHO CAN ACCESS THIS COURSE :-

  • Who wanna learn basic concepts of Database Design
  • Who wanna learn advanced concepts of Database Design

WHAT ARE YOUR REQUIREMENTS FOR THIS COURSE ?

  • No prior knowledge on Database required.

WHAT YOU ARE GOING TO LEARN FROM THIS COURSE ?

  • Can make a better database using standard principles
  • Prepare a better database from scratch
  • Feel comfortable to write database design in resume

DESCRIPTION

Information base plan is the way toward creating a definite information model of a data set. This information model contains all the required intelligent and actual plan decisions and actual stockpiling boundaries expected to create a plan. Through this instructional exercise we will attempt to show the premise segments of information base plan and discloses how to make a decent data set plan.

Planning an information base is indeed genuinely simple, yet there are a couple of rules to adhere to. It is critical to understand what these principles are, however more significantly is to know why these standards exist, else you will in general commit errors!

Substance of this course

Presentation and Database Overview

Understanding SQL Types of orders

Tables, Views and Stored Procedures

Information base limitations

Information base Normalization

Emergency room Diagram

Social Database Management System

NoSQL

RDBMS versus NoSQL

COURSE CONTENT

  • 3 sections • 32 lectures • 2h 44m total length

Mastering Database Design9 lectures • 1hr 1min

  • Introduction and Database OverviewPreview03:40
  • Understanding SQL Types of CommandsPreview11:02
  • Tables, Views and Stored Procedures06:44
  • Database Constraints12:00
  • Database Normalization11:49
  • ER Diagram04:13
  • Relational Database Management System03:22
  • NoSQL04:22
  • RDBMS vs. NoSQL04:04

Bonus Section: Learning MySQL Development18 lectures • 1hr 26min

  • Introduction to MySQL04:19
  • Data types in MySQL Part – 104:04
  • Data types in MySQL Part – 202:57
  • XAMPP Installation03:58
  • MySQL Workbench Installation04:53
  • Creating with PHPMyAdmin06:19
  • Creating Database & Table through MySQL Workbench05:07
  • Design and Accounts05:35
  • Import and Export03:58
  • Introduction to MySQL Queries and SELECT Clause08:02
  • Inserts Updates and Deletes05:06
  • Storage Engines04:53
  • Mastering Table Joining: Part 104:41
  • Mastering Table Joining: Part 205:32
  • Working with Math and Strings: Part 105:38
  • Working with Math and Strings: Part 204:09
  • Group By: Part 103:36
  • Group By: Part 203:36

Bonus Section: Working with MongoDB (NoSQL Database)5 lectures • 17min

  • MongoDB Installation01:38
  • Basic Queries: Part 103:38
  • Basic Queries: Part 203:06
  • Advanced Queries: Part 104:42
  • Advanced Queries: Part 204:02

HOW TO MAKE MONEY ONLINE & TIPS AND TRICKS

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker