LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL

seeders: 1

leechers: 17

Download torrent

Added on November 10, 2015 by BarCraftin Other > Tutorials
Torrent verified.

Main

add to bookmarks

LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL (Size: 213.12 MB)

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