Lynda Database Fundamentals Storage | 83E55AC188A02C2F2C7AE568D93D4CCE6E54898C

Lynda Database Fundamentals Storage

Name	Lynda - Database Fundamentals - Storage	DOWNLOAD Copy Link
Total Size	223.5 MB
Total Files	27
Hash	83E55AC188A02C2F2C7AE568D93D4CCE6E54898C

/01. Introduction/
01_01-Welcome.mp4	7.0 MB
01_02-Preparing for MTA Exam 98364.mp4	6.0 MB
01_03-Using the exercise files.mp4	1.0 MB
01_04-Challenges explained.mp4	871.6 KB
01_05-What you should know.mp4	2.4 MB
/02. Creating Normalized Tables/
02_01-Reducing redundancy with normalization.mp4	9.1 MB
02_02-Understanding the first normal form 1NF.mp4	14.1 MB
02_03-Understanding the second normal form 2NF.mp4	14.3 MB
02_04-Fixing partial dependencies.mp4	7.2 MB
02_05-Understanding the third normal form 3NF.mp4	13.7 MB
02_06-Exploring the fourth and fifth normal form 4NF 5NF.mp4	4.8 MB
02_07-Challenge Normalizing a dataset.mp4	1.7 MB
02_08-Solution Normalizing a dataset.mp4	37.1 MB
/03. Adding Key Fields/
03_01-Understanding the role of key fields.mp4	7.0 MB
03_02-Creating a tables primary key in SQL Server Management Studio.mp4	16.5 MB
03_03-Understanding composite primary keys.mp4	4.4 MB
03_04-Creating composite primary keys.mp4	10.5 MB
03_05-Linking tables with foreign keys.mp4	14.6 MB
03_06-Creating a foreign key relationship in SSMS.mp4	8.4 MB
/04. Indexing Records/
04_01-Understanding clustered indexes.mp4	4.6 MB
04_02-Adding a clustered index.mp4	9.7 MB
04_03-Understanding nonclustered indexes.mp4	3.3 MB
04_04-Creating a nonclustered index in SSMS.mp4	9.0 MB
04_05-Creating a nonclustered index using DDL.mp4	8.5 MB
04_06-Challenge Creating table indexes.mp4	1.2 MB
04_07-Solution Creating table indexes.mp4	4.3 MB
/05. Conclusion/
05_01-Next steps.mp4	2.3 MB
Total files 27