Course
Skills Expanded
Microsoft MTA: Database Administration Fundamentals
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.
What you'll learn
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.
Table of contents
Getting Started with Database Administration Fundamentals
2mins
Different Types of Databases
15mins
Relational Database Concepts
15mins
Database Data Types
14mins
The SQL Language
12mins
Introducing the SQL Server Management Studio
14mins
Creating and Using Tables
13mins
Creating and Using Views
13mins
Creating Stored Procedures
10mins
Basic Queries
20mins
Complex Conditions
17mins
Multi-Table Queries
15mins
Modifying Data
19mins
Database Normalization
14mins
Keys and Constraints
11mins
Indexes
12mins
Security
17mins
Backup and Recovery
15mins
Continual Maintenance
13mins
Preparing for Your DBA Fundamentals (98-364) Exam
4mins
Next Steps
1min