From the course: Data Engineering: dbt for SQL
Join today to access over 23,100 courses taught by industry experts.
Schema design
From the course: Data Engineering: dbt for SQL
Schema design
- [Instructor] To enhance your SQL skills, it is crucial to grasp the fundamental principles of relational database design. In this video, we'll cover two essential concepts, normal forms and functional dependencies. Let's say you have some example data to illustrate these concepts. Imagine you have two tables, employee with details like names, ID numbers, and departments, and department with information about different departments and their managers. Normal forms are a set of rules that organize data in a database to prevent issues like data redundancy or inconsistencies. There are different levels of normal forms with the first normal form, or 1NF, being the most basic. In the first normal form, each row in a table must be unique and each column should only contain one piece of data, no repeating data. For example, in our employee table, we can't have two rows with the same ID number, and the name column can't combine…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.