Lynda - Database Fundamentals: Storage
- Type:
- Other > Other
- Files:
- 39
- Size:
- 213.24 MiB (223600609 Bytes)
- Uploaded:
- 2015-11-28 04:32:40 GMT
- By:
-
2boweb
- Seeders:
- 0
- Leechers:
- 1
- Comments
- 0
- Info Hash: 8A833DE15A5B4C7A8A07C7A29DC991A97A03842F
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Database Fundamentals: Storage This Course will be good to the Best for DL within 30 days after has been post, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 1h 22m Beginner Oct 20, 2015 | Uploaded in Nov 28, 2015 by 2boweb Subject: IT Software: SQL Server Author: Adam Wilbert 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 /////////////////////////////////////////////////////////////////////////////////////
| 013 Solution - Normalizing a dataset.mp4 | 35.36 MiB |
| 015 Creating a table`s primary key in SQL Server Management Studio.mp4 | 15.73 MiB |
| 018 Linking tables with foreign keys.mp4 | 13.92 MiB |
| 008 Understanding the second normal form (2NF).mp4 | 13.61 MiB |
| 007 Understanding the first normal form (1NF).mp4 | 13.48 MiB |
| 010 Understanding the third normal form (3NF).mp4 | 13.05 MiB |
| 017 Creating composite primary keys.mp4 | 10.01 MiB |
| 021 Adding a clustered index.mp4 | 9.27 MiB |
| 006 Reducing redundancy with normalization.mp4 | 8.72 MiB |
| 023 Creating a nonclustered index in SSMS.mp4 | 8.59 MiB |
| 024 Creating a nonclustered index using DDL.mp4 | 8.12 MiB |
| 019 Creating a foreign key relationship in SSMS.mp4 | 8.02 MiB |
| 009 Fixing partial dependencies.mp4 | 6.85 MiB |
| 014 Understanding the role of key fields.mp4 | 6.64 MiB |
| 001 Welcome.mp4 | 6.64 MiB |
| 002 Preparing for MTA Exam 98-364.mp4 | 5.76 MiB |
| 011 Exploring the fourth and fifth normal form (4NF) (5NF).mp4 | 4.61 MiB |
| 020 Understanding clustered indexes.mp4 | 4.34 MiB |
| 016 Understanding composite primary keys.mp4 | 4.23 MiB |
| 026 Solution - Creating table indexes.mp4 | 4.08 MiB |
| 022 Understanding nonclustered indexes.mp4 | 3.1 MiB |
| 005 What you should know.mp4 | 2.29 MiB |
| 027 Next steps.mp4 | 2.2 MiB |
| 012 Challenge - Normalizing a dataset.mp4 | 1.63 MiB |
| 025 Challenge - Creating table indexes.mp4 | 1.1 MiB |
| 003 Using the exercise files.mp4 | 985.08 KiB |
| 004 Challenges explained.mp4 | 851.24 KiB |
| Exercise Files/mta_DBA Fun_handout.pdf | 67.47 KiB |
| Exercise Files/Chapter 2/DatabaseReset.txt | 42.55 KiB |
| Exercise Files/Chapter 1/ChallengeData.txt | 13.71 KiB |
| Exercise Files/Chapter 1/3NF-Complete.txt | 65 B |
| Exercise Files/Chapter 1/ChallengeScript.txt | 616 B |
| Exercise Files/Chapter 1/3NF-Start.txt | 547 B |
| Exercise Files/Chapter 2/02_02_PrimaryKey-Complete.txt | 434 B |
| Exercise Files/Chapter 3/03_05_NonClusteredIndex-Complete.txt | 373 B |
| Exercise Files/Chapter 2/02_04_CompositeKey-Complete.txt | 263 B |
| Exercise Files/Chapter 2/02_06_ForeignKey-Complete.txt | 206 B |
| Exercise Files/Chapter 1/2NF-Start.txt | 188 B |
| Exercise Files/Chapter 3/ChallengeSolution.txt | 67 B |
