LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL

seeders: 1
leechers: 17
Added on November 10, 2015 by BarCraftin Other > Tutorials
Torrent verified.



LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL (Size: 213.12 MB)
 01_01-Welcome.mp46.64 MB
 01_02-Preparing for MTA Exam 98364.mp45.76 MB
 01_05-What you should know.mp42.29 MB
 01_03-Using the exercise files.mp4985.05 KB
 01_04-Challenges explained.mp4851.21 KB
 02_08-Solution Normalizing a dataset.mp435.36 MB
 02_03-Understanding the second normal form 2NF.mp413.61 MB
 02_02-Understanding the first normal form 1NF.mp413.48 MB
 02_05-Understanding the third normal form 3NF.mp413.05 MB
 02_01-Reducing redundancy with normalization.mp48.72 MB
 02_04-Fixing partial dependencies.mp46.85 MB
 02_06-Exploring the fourth and fifth normal form 4NF 5NF.mp44.61 MB
 02_07-Challenge Normalizing a dataset.mp41.63 MB
 03_02-Creating a tables primary key in SQL Server Management Studio.mp415.73 MB
 03_05-Linking tables with foreign keys.mp413.92 MB
 03_04-Creating composite primary keys.mp410.01 MB
 03_06-Creating a foreign key relationship in SSMS.mp48.02 MB
 03_01-Understanding the role of key fields.mp46.64 MB
 03_03-Understanding composite primary keys.mp44.23 MB
 04_02-Adding a clustered index.mp49.27 MB
 04_04-Creating a nonclustered index in SSMS.mp48.59 MB
 04_05-Creating a nonclustered index using DDL.mp48.12 MB
 04_01-Understanding clustered indexes.mp44.34 MB
 04_07-Solution Creating table indexes.mp44.08 MB
 04_03-Understanding nonclustered indexes.mp43.1 MB
 04_06-Challenge Creating table indexes.mp41.1 MB
 05_01-Next steps.mp42.2 MB


Description

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

Sharing Widget


Download torrent
213.12 MB
seeders:1
leechers:17
LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL