| 01_01-Welcome.mp4 | 6.6 MB | ||
| 01_02-Preparing for MTA Exam 98364.mp4 | 5.8 MB | ||
| 01_03-Using the exercise files.mp4 | 985 KB | ||
| 01_04-Challenges explained.mp4 | 851.2 KB | ||
| 01_05-What you should know.mp4 | 2.3 MB | ||
| 02_01-Reducing redundancy with normalization.mp4 | 8.7 MB | ||
| 02_02-Understanding the first normal form 1NF.mp4 | 13.5 MB | ||
| 02_03-Understanding the second normal form 2NF.mp4 | 13.6 MB | ||
| 02_04-Fixing partial dependencies.mp4 | 6.8 MB | ||
| 02_05-Understanding the third normal form 3NF.mp4 | 13 MB | ||
| 02_06-Exploring the fourth and fifth normal form 4NF 5NF.mp4 | 4.6 MB | ||
| 02_07-Challenge Normalizing a dataset.mp4 | 1.6 MB | ||
| 02_08-Solution Normalizing a dataset.mp4 | 35.4 MB | ||
| 03_01-Understanding the role of key fields.mp4 | 6.6 MB | ||
| 03_02-Creating a tables primary key in SQL Server Management Studio.mp4 | 15.7 MB | ||
| 03_03-Understanding composite primary keys.mp4 | 4.2 MB | ||
| 03_04-Creating composite primary keys.mp4 | 10 MB | ||
| 03_05-Linking tables with foreign keys.mp4 | 13.9 MB | ||
| 03_06-Creating a foreign key relationship in SSMS.mp4 | 8 MB | ||
| 04_01-Understanding clustered indexes.mp4 | 4.3 MB | ||
| 04_02-Adding a clustered index.mp4 | 9.3 MB | ||
| 04_03-Understanding nonclustered indexes.mp4 | 3.1 MB | ||
| 04_04-Creating a nonclustered index in SSMS.mp4 | 8.6 MB | ||
| 04_05-Creating a nonclustered index using DDL.mp4 | 8.1 MB | ||
| 04_06-Challenge Creating table indexes.mp4 | 1.1 MB | ||
| 04_07-Solution Creating table indexes.mp4 | 4.1 MB | ||
| 05_01-Next steps.mp4 | 2.2 MB | ||
| ▲ 27 total files | |||
Storage is a database's full-time job. Yet many IT
professionals never really learn how it's done. This course
is designed to change that, providing a baseline
understanding of databases and their mechanics. Adam
Wilbert covers normalization, a table structuring technique
that reduces data redundancy; primary, foreign, and
composite keys-features supporting the table relationships
that underlie relational databases; and indexing, which
helps speed up data retrieval. Along the way, Adam will
provide tips for working with SQL Server Management Studio
and some challenges to help you practice what you've
learned
Note: This course will also prepare certification
candidates for the "Understanding data storage" domain of
the Microsoft Technology Associate (MTA) Exam 98-364
Database Administration Fundamentals. Find out more at
https://www.microsoft.com/learning/en-us/exam-98-364.aspx
Topics include:
* Reducing redundancy with normalization
* Fixing partial dependencies
* Creating primary keys
* Linking tables with foreign keys
* Creating clustered and nonclustered indexes
All Comments