Database Design for Relational Databases using SQL Server
4.2 (55 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.
230 students enrolled

Database Design for Relational Databases using SQL Server

Learn Database Design Fundamentals and sharpen your SQL in under 5 hours. SQL Database Design explained for Beginners
4.2 (55 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.
230 students enrolled
Created by Daniel Tait
Last updated 5/2020
English
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 16 downloadable resources
  • 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
  • Learn Best Practices for Relational Database Design
  • Understand Relational Theory
  • Learn the data normalization process
  • Understand the First, Second, Third and Fourth Normal Forms
  • Understand Boyce-Codd normal form
  • Identify relationship types between entities
  • How to enforce database relationships including one-to-one, one-to-many, and many-to-many
  • Learn functional dependencies
  • Learn multivalued dependencies
  • Learn what Update, Insert and Delete anomalies are
  • Surrogate keys vs Natural keys
  • Learn the difference Candidate keys and Super Keys
  • Learn how to implement physical design using SQL Server
  • Create database tables and alter existing tables
  • Create SQL Queries and Views
Course content
Expand all 67 lectures 04:42:25
+ Database Basics
8 lectures 09:51
Types of Databases
00:23
Flat Files
00:45
NoSQL Databases
00:33
Data Warehouses
00:31
Relational Databases
02:22
Logical and Physical Design
01:57
Common Table Terminology
02:47
+ Getting Started with SQL Server
3 lectures 24:32
How to install SQL Server and SSMS
03:27
Create and Query a Table (demo)
20:11
+ Data Integrity Constraints
14 lectures 50:45
Data Integrity
00:48
Null Values
01:10
Handling Nulls
01:38
Handling Nulls (demo)
14:46
Primary Key Constraint
00:46
Composite Primary Key
00:58
Natural Keys
01:58
Surrogate Keys
00:58
Primary Key Recommendations
01:08
Primary Key vs Unique Constraint
01:25
Indexes
01:34
Unique Indexes
01:57
Primary Key and Unique Constraints (demo)
20:01
+ Types of Relationships
12 lectures 46:54
Types of Relationships between Entities
02:24
Identifying Relationships between Entities
03:49
One-to-Many Relationships Part 2
03:20
One-to-Many Relationships Part 3
02:00
Foreign Key Constraint Summary
01:05
One-to-Many Relationships (demo)
11:29
One-to-One Relationships
03:37
One-to-One Relationships (demo)
07:37
Self-Referencing Relationships
01:28
Self-Referencing Relationships (demo)
04:13
Table Relationships
4 questions
+ Data Normalization
22 lectures 01:49:25
Introduction to Data Normalization
01:29
Update, Insert and Delete Anomalies
05:55
Introduction to the Normal Forms
00:56
Functional Dependencies
02:51
Trivial Functional Dependencies
01:57
Candidate Keys
04:36
Candidate keys vs Super Keys
01:50
Key and Non-key Attributes
01:01
First Normal Form
04:53
First Normal Form (demo)
13:04
Second Normal Form
08:29
Second Normal Form (demo)
09:07
Transitive Dependencies
01:19
Third Normal Form
10:00
Third Normal Form (demo)
05:41
Boyce-Codd Normal Form
04:46
3NF vs BCNF
01:28
Remembering the Normal Forms
01:50
Fourth Normal Form and Multivalued Dependencies
05:44
Fourth Normal Form (demo)
05:04
+ Helpful Practice Activities
4 lectures 22:47
Library Database Exercise
02:01
Library Database Exercise Solution
11:29
Decomposition Exercise
02:44
Decomposition Exercise Solution
06:33
+ Other Considerations
3 lectures 14:44
Data Types
01:19
Naming Conventions
01:23
Naming Conventions (demo)
12:02
Requirements
  • A basic knowledge of computers
Description

Start learning Database Design from Scratch!

A lot of IT professionals have a good working knowledge of SQL yet lack the foundational knowledge of relational database design. Learning database design and the relational model will put you ahead of the game. This course covers all the essential aspects of relational database design with practical demos given in SQL Server. You will learn how to spot un-normalized data structures and how to correct them. You will learn all about the process of data normalization and why it is important. This includes the various normal forms such as Boyce-Codd normal form and fourth normal form. This course also covers tips on how to identify relationships between entities and how to correctly model them in a relational database.

You will be able to understand advanced database design concepts with the aid of intuitive diagrams and practical examples.


Note that you will need a Windows or Linux computer to install SQL Server.


Who this course is for:
  • Anyone who wants to learn Database Design
  • Students studying Relational Theory
  • Database Professionals
  • Anyone looking to get into a database role
  • Anyone looking to enhance their Data Science or Data Analytics career
  • Software Developers and Web Developers looking to enhance their careers