Database Design for Relational Databases using SQL Server (Udemy.com)
Learn Database Design Fundamentals and sharpen your SQL in under 5 hours. SQL Database Design explained for Beginners
Created by: Daniel Tait
Last updated September 2021
What you will 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
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.5 out of 5higher than 48% of them
- Reviews213#290 of 389 by number of reviews
- Length5.7 hoursshorter than 54% of them
- Last updatedSeptember 2021earlier than 61% of them
Course Description
Start learning Database Design Today!
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. You will learn how to identify functional dependencies and transitive dependencies in your data. You will learn the different types of keys and when to use them. In addition, you will learn the different types of relationships such as one-to-one, one-to-many, many-to-many, and self-referencing relationships. More importantly, the end of the course you will know how to enforce these relationships by using integrity constraints.
Note that you will need either a Windows or Linux computer to install SQL Server.
Instructor Details
- 4.5 Rating
213 Reviews
Daniel Tait
Hi, my name is Daniel. I currently live in New Zealand and I work as a Spatial Analyst in the local government sector. I have a passion for data and over the years have become an expert in SQL and relational databases. I enjoy teaching others and I hope you enjoy my courses.
More courses by Daniel Tait
The Complete SQL Course - Learn by Doing - SQL Server (2026)
4.7 (3,241 Reviews)
Provider: Udemy
Time: 13.4h
$99.99
All Levels SQL Bootcamp - Learn MySQL - MySQL Database (2023)
4.5 (225 Reviews)
Provider: Udemy
Time: 10.3h
$64.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Shokat Aziz on 5/28/2024
Lots of information but found it is far too advanced for a beginner, perhaps it was me, I could have done with some real life examples and how to understand designing the database at a more simplified level building up to the more complex concepts. Like I said perhaps it was me.
By Smitha Abraham on 8/20/2021
The content of this course has been well drafted and delivered by the instructor. It would also be nice if we were introduced to data modelling concepts and demos as well.
By Bright Amusu on 7/18/2021
Great knowledge about the concept and have enjoyed one of your other videos you made SQL server. I will recommend this and any other videos to other who wants to learn and become experts in this field.
By Konstantinos Ziovas on 3/31/2021
Great course for this topic exactly what I was looking for. Maybe if another section was added to explain most common schema types it would have been excellent. Oh also most videos are wayyy too short better keep them together ina 4-5min videos. An the instructor is speaking really sowly I followed everything at 1.25 speed :-). Apart from these 2-3 points great course!
By Clive Gray on 3/7/2021
A comprehensive course. It's a dry - but important - subject so was always going to be difficult for the tutor to "bring it alive". And it was (difficult). But, I now know a lot more than I did before so, no complaints here.
By Goni Schindler on 12/23/2020
Your explanations are clear and great. Toke me from 0 to hero in terms of understanding this concept. Much appreciated. Also loved that no time is wasted on writing the code during the videos which sounds obvious but many other Udmy courses actually do.
By Sylvia MacGregor on 4/25/2020
This course is very well organized and detail oriented. It includes all the code needed to create tables and insert data to follow along with the demos, including many notes, all downloadable so you can easily follow along. I was really happy with the answers to the questions I submitted - replies came directly from the instructor, and he took care to explain things in detail in a way I could easily understand - I was really appreciative of this. The information is presented with concepts being defined first, followed by a demo. While concepts are presented clearly with examples, the structure of the course doesn't vary and the instructor remains in teacher mode the whole time. For me personally this style can make it difficult to stay engaged at times. My main suggestion would be the addition of challenges (even if just mini quizzes) throughout the course so students can make sure they're on track and engaged. Currently, there are a couple of good challenges at the end of the course.
By Syberen van Munster on 3/30/2020
This course taught me exactly what I needed. Was thinking of taking a uni course on relational databases, but this appears to have the same information in a clearly explained format. I personally liked the pacing: the teacher talks slowly but the information is very concise so it is easy to absorb. I do have a few suggestions for improvement: It should be clear from the course description that SQL server only runs on windows or linux, but not on mac. Fortunately I had some experience with Docker so it was easy to set it up on my mac, but if you don't that might be a problem. It would also be nice to have either some assignments or tests at various points, to consolidate the learning.
By Zvi Eshel on 3/27/2020
To the point, well organized and clear introduction to relational database design. The SQL code samples work. On the last lecture the (naming conventions demo) would be good to add the .sql file. Thanks. Recommended.
By Manawa H on 2/29/2020
I got a lot out of this course, it was well-structured and easy to follow. Daniel's explanation of 3NF and how it’s different to BCNF was clearly explained. It made sense to me and it was good to see formal definitions of the normal forms and how these relate to the more informal definitions like “3NF is where a table has no transitive dependencies".
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100








