Basics of Database Design & Development
4.3 (100 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,145 students enrolled

Basics of Database Design & Development

Understand basics of database design & development through step by step procedure
4.3 (104 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24,145 students enrolled
Last updated 3/2018
English
Current price: $90.99 Original price: $129.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Can make better database using standard principles
  • Prepare better database from scratch
  • Feel comfortable to write database design in resume
Course content
Expand all 27 lectures 02:27:39
+ Mastering Database Design
9 lectures 01:01:16
Tables, Views and Stored Procedures
06:44
Database Constraints
12:00
Database Normalization
11:49
ER Diagram
04:13
Relational Database Management System
03:22
NoSQL
04:22
RDBMS vs. NoSQL
04:04
+ Learning MySQL Development
18 lectures 01:26:23
Introduction to MySQL
04:19
Data types in MySQL Part - 1
04:04
Data types in MySQL Part - 2
02:57
XAMPP Installation
03:58
MySQL Workbench Installation
04:53
Creating with PHPMyAdmin
06:19
Creating Database & Table through MySQL Workbench
05:07
Design and Accounts
05:35
Import and Export
03:58
Introduction to MySQL Queries and SELECT Clause
08:02
Inserts Updates and Deletes
05:06
Storage Engines
04:53
Mastering Table Joining: Part 1
04:41
Mastering Table Joining: Part 2
05:32
Working with Math and Strings: Part 1
05:38
Working with Math and Strings: Part 2
04:09
Group By: Part 1
03:36
Group By: Part 2
03:36
Requirements
  • No prior knowledge on Database required.
Description

Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design. Through this tutorial we will try to teach the basis components of database design and explains how to make a good database design.

Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know what these rules are, but more importantly is to know why these rules exist, otherwise you will tend to make mistakes!

Contents of this course 

  • Introduction and Database Overview 
  • Understanding SQL Types of commands 
  • Tables, Views and Stored Procedures 
  • Database constraints 
  • Database Normalization 
  • ER Diagram 
  • Relational Database Management System 
  • NoSQL 
  • RDBMS vs. NoSQL 


Who this course is for:
  • Who wanna learn basic concepts of Database Design
  • Who wanna learn advanced concepts of Database Design