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.
Course info
Rating
(510)
Level
Beginner
Updated
October 2, 2012
Duration
4h 35m
Table of contents
Getting Started with Database Administration Fundamentals
Different Types of Databases
Relational Database Concepts
Database Data Types
The SQL Language
Introducing the SQL Server Management Studio
Creating and Using Tables
Creating and Using Views
Creating Stored Procedures
Basic Queries
Complex Conditions
Multi-Table Queries
Modifying Data
Database Normalization
Keys and Constraints
Indexes
Security
Backup and Recovery
Continual Maintenance
Preparing for Your DBA Fundamentals (98-364) Exam
Next Steps
Description
Course info
Rating
(510)
Level
Beginner
Updated
October 2, 2012
Duration
4h 35m
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.

About the author
About the author

Don Jones' broad IT experience comes from 20 years in the business, with a strong focus on Microsoft server technologies.

More from the author
PowerShell & DevOps Global Summit 2016 Sessions
Intermediate
25h 35m
29 Apr 2016
More courses by Don Jones