Daniel Tait
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.
Instructor Details
Courses : 2
Specification: Database Design for Relational Databases using SQL Server
|
9 reviews for Database Design for Relational Databases using SQL Server
Add a review
| Price | $9.99 |
|---|---|
| Provider | |
| Duration | 5.5 hours |
| Year | 2021 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$9.99
Geoff T –
Content was structured and presented well. Easy to understand with good explanations and examples. Covers more material than similar database design courses so well worth it.
Manawa Huirama –
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.
Lien Pham –
Starts from the basics and then builds on that to give in depth explanations. I bought a book on SQL databases but found I got much more from this course. Thanks so much!
Kimnguyen –
Good course. Very detailed but that is what I wanted.
Anthony Muhl –
Very good information.
Zvi Eshel –
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.
Syberen van Munster –
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.
Natalie McKenzie –
good
Clive Gray –
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.