Lessons: 14Length: 1.1 hours
There are several things you need to know to create a properly-organized relational database. In this course, you'll not only learn best practices in relational database design, you'll also see how to use simple tools to design a database based on your own example application. If you're new to SQL, then this course will help you kickstart your new database design.
1.Introduction
1.1Introduction00:24
1.1
Introduction
00:24
2.Database Design
2.1Installation05:48
2.1
Installation
05:48
2.2Granularity08:35
2.2
Granularity
08:35
2.3Naming Conventions04:23
2.3
Naming Conventions
04:23
2.4First Normal Form05:54
2.4
First Normal Form
05:54
2.5First Normal Form Problems01:50
2.5
First Normal Form Problems
01:50
2.6Second Normal Form04:49
2.6
Second Normal Form
04:49
2.7Second Normal Form Problems04:02
2.7
Second Normal Form Problems
04:02
2.8Third Normal Form06:30
2.8
Third Normal Form
06:30
2.9Foreign Keys04:06
2.9
Foreign Keys
04:06
2.10One to Many Relationships05:08
2.10
One to Many Relationships
05:08
2.11Many to Many Relationships06:19
2.11
Many to Many Relationships
06:19
2.12From Idea to Database10:30
2.12
From Idea to Database
10:30
3.Conclusion
3.1Conclusion00:24
3.1
Conclusion
00:24
