LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL
File List
| File | Size |
|---|---|
| 01. Introduction/01_01-Welcome.mp4 | 6.64 MB |
| 01. Introduction/01_02-Preparing for MTA Exam 98364.mp4 | 5.76 MB |
| 01. Introduction/01_05-What you should know.mp4 | 2.29 MB |
| 01. Introduction/01_03-Using the exercise files.mp4 | 985.05 KB |
| 01. Introduction/01_04-Challenges explained.mp4 | 851.21 KB |
| 02. Creating Normalized Tables/02_08-Solution Normalizing a dataset.mp4 | 35.36 MB |
| 02. Creating Normalized Tables/02_03-Understanding the second normal form 2NF.mp4 | 13.61 MB |
| 02. Creating Normalized Tables/02_02-Understanding the first normal form 1NF.mp4 | 13.48 MB |
| 02. Creating Normalized Tables/02_05-Understanding the third normal form 3NF.mp4 | 13.05 MB |
| 02. Creating Normalized Tables/02_01-Reducing redundancy with normalization.mp4 | 8.72 MB |
| 02. Creating Normalized Tables/02_04-Fixing partial dependencies.mp4 | 6.85 MB |
| 02. Creating Normalized Tables/02_06-Exploring the fourth and fifth normal form 4NF 5NF.mp4 | 4.61 MB |
| 02. Creating Normalized Tables/02_07-Challenge Normalizing a dataset.mp4 | 1.63 MB |
| 03. Adding Key Fields/03_02-Creating a tables primary key in SQL Server Management Studio.mp4 | 15.73 MB |
| 03. Adding Key Fields/03_05-Linking tables with foreign keys.mp4 | 13.92 MB |
| 03. Adding Key Fields/03_04-Creating composite primary keys.mp4 | 10.01 MB |
| 03. Adding Key Fields/03_06-Creating a foreign key relationship in SSMS.mp4 | 8.02 MB |
| 03. Adding Key Fields/03_01-Understanding the role of key fields.mp4 | 6.64 MB |
| 03. Adding Key Fields/03_03-Understanding composite primary keys.mp4 | 4.23 MB |
| 04. Indexing Records/04_02-Adding a clustered index.mp4 | 9.27 MB |
| 04. Indexing Records/04_04-Creating a nonclustered index in SSMS.mp4 | 8.59 MB |
| 04. Indexing Records/04_05-Creating a nonclustered index using DDL.mp4 | 8.12 MB |
| 04. Indexing Records/04_01-Understanding clustered indexes.mp4 | 4.34 MB |
| 04. Indexing Records/04_07-Solution Creating table indexes.mp4 | 4.08 MB |
| 04. Indexing Records/04_03-Understanding nonclustered indexes.mp4 | 3.1 MB |
| 04. Indexing Records/04_06-Challenge Creating table indexes.mp4 | 1.1 MB |
| 05. Conclusion/05_01-Next steps.mp4 | 2.2 MB |
Trackers
No trackers found.