LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL

seeders: 4
leechers: 0
updated:
Download torrent
Added by BarCraft in XXX > Video
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 1065
  • Language: English

Files

01. Introduction
  • 01_01-Welcome.mp4 (6.6 MB)
  • 01_02-Preparing for MTA Exam 98364.mp4 (5.8 MB)
  • 01_05-What you should know.mp4 (2.3 MB)
  • 01_03-Using the exercise files.mp4 (985.0 KB)
  • 01_04-Challenges explained.mp4 (851.2 KB)
02. Creating Normalized Tables
  • 02_08-Solution Normalizing a dataset.mp4 (35.4 MB)
  • 02_03-Understanding the second normal form 2NF.mp4 (13.6 MB)
  • 02_02-Understanding the first normal form 1NF.mp4 (13.5 MB)
  • 02_05-Understanding the third normal form 3NF.mp4 (13.0 MB)
  • 02_01-Reducing redundancy with normalization.mp4 (8.7 MB)
  • 02_04-Fixing partial dependencies.mp4 (6.8 MB)
  • 02_06-Exploring the fourth and fifth normal form 4NF 5NF.mp4 (4.6 MB)
  • 02_07-Challenge Normalizing a dataset.mp4 (1.6 MB)
03. Adding Key Fields
  • 03_02-Creating a tables primary key in SQL Server Management Studio.mp4 (15.7 MB)
  • 03_05-Linking tables with foreign keys.mp4 (13.9 MB)
  • 03_04-Creating composite primary keys.mp4 (10.0 MB)
  • 03_06-Creating a foreign key relationship in SSMS.mp4 (8.0 MB)
  • 03_01-Understanding the role of key fields.mp4 (6.6 MB)
  • 03_03-Understanding composite primary keys.mp4 (4.2 MB)
04. Indexing Records
  • 04_02-Adding a clustered index.mp4 (9.3 MB)
  • 04_04-Creating a nonclustered index in SSMS.mp4 (8.6 MB)
  • 04_05-Creating a nonclustered index using DDL.mp4 (8.1 MB)
  • 04_01-Understanding clustered indexes.mp4 (4.3 MB)
  • 04_07-Solution Creating table indexes.mp4 (4.1 MB)
  • 04_03-Understanding nonclustered indexes.mp4 (3.1 MB)
  • 04_06-Challenge Creating table indexes.mp4 (1.1 MB)
05. Conclusion
  • 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



Download torrent
213.1 MB
seeders:4
leechers:0
LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL

Trackers

tracker name
udp://tracker.openbittorrent.com:80/announce
udp://tracker4.piratux.com:6969/announce
udp://p4p.arenabg.ch:1337/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://coppersurfer.tk:6969/announce
udp://open.demonii.com:1337/announce
udp://9.rarbg.com:2710/announce
udp://tracker.pomf.se/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://eddie4.nl:6969/announce
udp://9.rarbg.me:2710/announce
udp://tracker.opentrackr.org:1337/announce
udp://p4p.arenabg.com:1337
udp://open.demonii.com:1337
udp://11.rarbg.com/announce
µTorrent compatible trackers list

Download torrent
213.1 MB
seeders:4
leechers:0
LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL

Torrent hash: 16FCF046DD2727C0ABE139889A74F6BA2A900B22