Module 1
SQL Server Overview
1.1 What is SQL Server?
1.2 Login, User Accounts & Roles

Module 2
Planning to Install SQL Server
2.1 Hardware requirements and Installation
2.2 Review of the Installation
2.3 Testing Our Connections
2.4 Troubleshooting Your Connection
Review Quiz

Module 3
Managing Database Files
1.1 How is Data Stored
1.2 Creating Databases
1.3 Managing Databases
1.4 Creating Filegroups
1.5 Filegroup Performance & Fault Tolerance

Module 4
Managing Security
2.1 Authentication Processing
2.2 User Accounts and Roles
2.3 Adding Roles & Types of Permissions
2.4 Managing Security within SQL Server

Module 5
Performing Administrative Tasks
1.1 Configuration Tasks
1.2 SQL Agent Mail vs SQL Mail
1.3 Routine Tasks & Creating Jobs
1.4 Alerts
1.5 Troubleshooting Alerts
Review Quiz

Module 6
Backing Up Databases
1.1 Having a Backup Strategy
1.2 Different Ways to Perform Backups

Module 7
Restoring Databases
2.1 SQL Server Recovery Process
2.2 Restoring or Rebuilding Master Database
Review Quiz

Module 8
Monitoring SQL Server Performance
1.1 Performance Monitoring of SQL Server
1.2 Memory Use, Indexes, Locks & Queries

Module 9
Transferring Data
2.1 Importing & Exporting Data
2.2 DTS (Data Transformation Services)
2.3 Tasks
Review Quiz

Module 10
Maintaining High Availability
1.1 Availability
1.2 Clustering

Module 11
Introducing Replication
2.1 Considerations for Distributing Data
2.2 Replication
2.3 Physical replication Models
Review Quiz