Site Name!

This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You’ll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you’re new to SQL Server administration, you’ll benefit from this introduction as it introduces you to a broad range of topics.

Lessons

Lesson 01 - Course Introduction
Lesson 02 - Planning
Lesson 03 - Installing SQL Server 2012
Lesson 04 - Advanced Installation
Lesson 05 - Basic Database Objects
Lesson 06 - Using SQL Server Management Studio
Lesson 07 - Database File Management
Lesson 08 - Database Configuration Options
Lesson 09 - Special Database Space Considerations
Lesson 10 - Server-Level Configurations
Lesson 11 - Database Console Commands (DBCC)
Lesson 12 - Server-Level Security
Lesson 13 - Database-Level Security
Lesson 14 - Transaction Logs and Recovery Models
Lesson 15 - Instance Configuration and Management
Lesson 16 - Working with Concurrency Problems
Lesson 17 - Collecting Troubleshooting Data
Lesson 18 - Auditing SQL Server
Lesson 19 - Backup Basics
Lesson 20 - Restore Basics
Lesson 21 - Indexes
Lesson 22 - Basic Execution Plans
Lesson 23 - Query Tuning
Lesson 24 - SQL Server Agent
Lesson 25 - Database Mail
Lesson 26 - Importing and Exporting Data
Lesson 27 - High Availability Basics
Lesson 28 - PowerShell