Microsoft MTA: Database Administration Fundamentals
Pluralsight
Course Summary
This is a practical course for someone new to relational databases that moves you through basic concepts right into real-world usage, demonstrating core tasks in Microsoft SQL Server itself.
-
+
Course Description
This is a practical course for someone new to relational databases that moves you through basic concepts right into real-world usage, demonstrating core tasks in Microsoft SQL Server itself. You'll not only gain new knowledge, but cement that knowledge by seeing it in action and being able to follow along at home.
-
+
Course Syllabus
Getting Started with Database Administration Fundamentals- 2m 56s
—Introduction 2m 56sDifferent Types of Databases- 15m 5s
—Introduction 0m 32s
—What's a Database? 6m 10s
—Flat-File Databases 0m 54s
—Hierarchical Databases 1m 13s
—Relational Databases 6m 16sRelational Database Concepts- 15m 30sDatabase Data Types- 14m 42sThe SQL Language- 12m 29sIntroducing the SQL Server Management Studio- 14m 29sCreating and Using Tables- 13m 28sCreating and Using Views- 13m 14sCreating Stored Procedures- 10m 8sBasic Queries- 20m 42sComplex Conditions- 17m 16sMulti-Table Queries- 15m 8sModifying Data- 19m 27sDatabase Normalization- 14m 39sKeys and Constraints- 11m 28sIndexes- 12m 30sSecurity- 17m 4sBackup and Recovery- 15m 1sContinual Maintenance- 13m 35sPreparing for Your DBA Fundamentals (98-364) Exam- 4m 26sNext Steps- 1m 51s
This course is listed under
Data & Information Management
, Digital Media & Games
, Server & Storage Management
and IT Compliance & Audit
Community
Related Posts:
