SQL SERVER SYSTEM ADMINISTRATION
3 DAYS
MODULE 1:
INTRODUCTION TO MICROSOFT SQL SERVER
Exploring the components of SQL Server
Identifying SQL Server administration tasks
MODULE 2: INSTALLING SQL SERVER
Identifying the requirements to install SQL Server
Installing SQL Server
Exploring the SQL Server installation
Troubleshooting the SQL Server installation
Configuring SQL Server
MODULE 3: DESIGNING & CONFIGURING SQL SERVER SECURITY
Identifying the security features of SQL Server
Implementing Microsoft Windows NT Authentication Mode security
Implementing Mixed Authentication Mode security
Designing security for a SQL server
Assigning login accounts
Assigning permissions
MODULE 4: OPTIMIZING SQL SERVER'S PERFORMANCE
Identifying the factors that affect performance
Designing a strategy for monitoring performance
Using performance monitoring tools
MODULE 5: AUTOMATING SQL SERVER ADMINISTRATION
Overview of automating administration
Managing alerts
Automating tasks across multiple SQL servers
Automating the publication of data on the Web
Automating maintenance tasks
Troubleshooting
MODULE 6: BACKING UP SQL SERVER DATABASES
Designing a backup strategy
Performing a backup
Automating backups
Implementing hardware fault tolerance
MODULE 7: RESTORING SQL SERVER DATABASES
Identifying methods to restore databases
Restoring databases
Recovering system databases
Recovering data through a backup SQL server
MODULE 8: DESIGNING AND IMPLEMENTING REPLICATION
Understanding the components of SQL Server replication
Designing a replication strategy
Implementing publishing
Implementing subscribing
Implementing replication in a mixed environment
Publishing on the Internet
MODULE 9: MANAGING REPLICATION
Monitoring replication
Troubleshooting replication