Join Simon Allardice for an in-depth discussion in this video Understanding normalization, part of Programming Foundations: Databases.
- Once we've started to plan out our tables,…our columns, and relationships,…we do something called Database Normalization.…This is a process where you take your database design,…and you apply a set of formal criteria,…of rules, called normal forms.…These were developed about 40 years ago,…mainly by Edgar Codd, the father of relational databases.…And we step through them, one, two, three.…First Normal Form, Second Normal Form,…and Third Normal Form.…There are others, but these are the important ones.…
Normalization should be carried out…for every database you design.…And it's really not that hard, even though, yes,…when you first start reading about database normalization,…you'll run into phrases like,…your database will comply with third normal form…when every non-prime attribute of R…is non-transitively dependent (i.e. directly dependent)…on every candidate key of R.…But you don't have to get into all this language…unless you are mathematically inclined.…The entire point of normalization is…to make your database easier,…
Author
Simon Allardice
Released
9/30/2015- What is a database?
- Why do you need a database?
- Choosing primary keys
- Identifying columns and selecting data types
- Defining relationships: one-to-one, one-to-many, and many-to-many
- Understanding normalization
- Creating queries to create, insert, update, and delete data
- Understanding indexing and stored procedures
- Exploring your database options
Skill Level Appropriate for all
Duration
Views
-
Introduction
-
Welcome1m 6s
-
What you need to know1m 14s
-
-
1. Understanding Databases
-
What are databases?7m 41s
-
-
2. Database Fundamentals
-
Defining table relationships5m 33s
-
3. Database Modeling: Tables
-
Planning your database5m 45s
-
Choosing primary keys1m 45s
-
Using composite keys2m 4s
-
4. Database Modeling: Relationships
-
Creating relationships2m 38s
-
-
5. Database Modeling: Optimization
-
First normal form4m 5s
-
Second normal form4m 29s
-
Third normal form4m 34s
-
6. Database Modeling: Querying
-
Creating SQL queries5m 34s
-
Structuring the WHERE clause6m 24s
-
Sorting query results2m 37s
-
Using aggregate functions4m 49s
-
Joining tables6m 54s
-
The data definition language4m 50s
-
-
7. Database Modeling: Indexing and Optimization
-
Understanding indexes9m 24s
-
-
8. Database Options
-
Desktop databases5m 13s
-
NoSQL databases8m 59s
-
-
Conclusion
-
Final thoughts50s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Understanding normalization