Microsoft SQL Server Administration Course Outline

Content Description Hours Notes
Introduction to Database -
Advantages and Features of SQL Server -
Versions, Editions, Licensing and Pricing -
Architecture of SQL Server -
SQL Server Components -
SQL Server Management Tools -
Scope of SQL Server, Roles of a DBA -
Installation Consideration -
File Stream Options -
Step by Step Installation -
Installing Hotfix, Cumulative Updates, and Service Packs -
Uninstalling and Cleanup of a Failed SQL Server Installation -
Types of Servers & Client/Server and N-Tier Architecture -
SQL Server Architecture -
Types of Databases -
Database Architecture -
Creating a Database -
T-SQL (Transact SQL) and SQL -
SQL Server Database Objects -
Restore Data for Database Refresh -
Database Migration and/or Upgrade -
Automation -
Minimizing Downtime and Data Loss -
Disaster Recovery Solutions -
AlwaysOn High Availability -
Replication -
Data Movement -
Latest Version of SQL Server, New Features, Advanced Troubleshooting -
Performance Tuning, Monitoring, and Troubleshooting -
SQL Server Partitions -
SQL Server Full Text Search -
Database Snapshots -