Relational Database Design for SQL Databases Video Course

Calling all aspiring database professionals:

Do you know SQL but you want to differentiate yourself from the rest?

Then you need to learn Database Design.

Don't get me wrong.. Knowing SQL is important.

But learning database design will give you an important edge in the job market.

Why?

Because there are many, many people who know SQL pretty well and an even larger number of people who claim to know SQL. However, few of these people know database design or how to properly structure data in a relational database.

Database design concepts are useful for anyone who works with data or manages data in a SQL database. Not only that, but it is common to get asked questions on database design concepts in database job interviews.

Why I made this course:

I made this course because most database design books are confusing to understand and it's easy for students to think that the topic is too hard for them.

This doesn't have to be the case.

In this course I use realistic examples and step-by-step videos to show you exactly how to do database design and what the concepts mean.

Feel confident in adding database design as a skill on your resume and enroll today!

Here is everything you will learn in this course:

• Why we normalize data structures.

• The three types of anomalies that can occur if we don't normalize data.

• What functional dependencies are and why they are important.

• How to model different types of relationships between entities using Primary Key and Foreign Key constraints.

• How to correctly restructure multi-valued and multi-type fields.

• Surrogate Keys vs Natural Keys.

• Candidate Keys and Super Keys.

• The normal forms up to Boyce-Codd Normal form i.e. 1NF, 2NF, 3NF, BCNF.

  
  

Requirements:

No prior knowledge of Databases or SQL is needed for this course. Although it will be useful if you have some knowledge in these areas.