Expanded Library
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
3mins
Different Types of Databases
15mins
Relational Database Concepts
16mins
Database Data Types
15mins
The SQL Language
13mins
Introducing the SQL Server Management Studio
14mins
Creating and Using Tables
14mins
Creating and Using Views
14mins
Creating Stored Procedures
11mins
Basic Queries
22mins
Complex Conditions
19mins
Multi-Table Queries
16mins
Modifying Data
20mins
Database Normalization
15mins
Keys and Constraints
11mins
Indexes
12mins
Security
18mins
Backup and Recovery
15mins
Continual Maintenance
14mins
Preparing for Your DBA Fundamentals (98-364) Exam
4mins
Next Steps
2mins