Before attending this course, students must have:
•Basic knowledge of the Microsoft Windows operating system and its core functionality.
•Working knowledge of Transact-SQL.
•Working knowledge of relational databases.
•Some experience with database design.
At Course CompletionAfter completing this course, students will be able to:
•Install and configure SQL Server 2008.
•Manage database files.
•Backup and restore databases.
•Transfer data into and out of SQL Server.
•Automate administrative tasks.
•Replicate data between SQL Server instances.
•Maintain high availability.
•Monitor SQL Server.
Module 1: Installing and Configuring SQL Server
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Transferring Data
Module 6: Automating Administrative Tasks
Module 7: Implementing Replication
Module 8: Maintaining High Availability
Module 9: Monitoring SQL Server
Module 10: Troubleshooting and Performance Tuning