LYNDA DATABASE FUNDAMENTALS STORAGE TUTORIAL

  • CategoryXXX
  • TypeVideo
  • LanguageEnglish
  • Total size213.1 MB
  • Uploaded ByBarCraft
  • Downloads1065
  • Last checkedJun. 13th '18
  • Date uploadedJun. 20th '16
  • Seeders 4
  • Leechers0
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 16FCF046DD2727C0ABE139889A74F6BA2A900B22

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

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)

Code:

  • 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