Learn about the latest version of SQL Server 2008.
This instructor-led course provides you with the knowledge and skills to implement and maintain a Microsoft SQL Server 2008 database. You will learn to use SQL Server 2008 product features and tools related to implementing and maintaining a database.
This course incorporates materials from the Official Microsoft Learning Products:
- 6231: Maintaining a Microsoft SQL Server 2008 Database
- 6232: Implementing a Microsoft SQL Server 2008 Database
What You'll Learn
-
Install and configure SQL Server 2008
-
Manage database files
-
Back up and restore databases
-
Manage security
-
Replicate data between SQL Server instances
-
Maintain high availability
-
Monitor SQL Server
-
Create data types and tables
-
Implement data integrity in Microsoft SQL Server 2008 databases by using constraints
-
Implement data integrity in Microsoft SQL Server 2008 by using triggers
-
Implement views
-
Implement stored procedures
Course Outline
1. Installing and Configuring SQL Server
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
2. Managing Databases and Files
- Planning Databases
- Creating Databases
- Using Policy-Based Management
3. Disaster Recovery
- Planning a Backup Strategy
- Backing Up User Databases
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Databases and Disaster Recovery
4. Managing Security
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Protecting the Server Scope
- Auditing Security
5. Implementing Replication
- Overview of Replication
- Managing Publications and Subscriptions
- Configuring Replication in Some Common Scenarios
6. Maintaining High Availability
- Introduction to High Availability
- Implementing Log Shipping
- Implementing Database Mirroring
- Implementing Server Clustering
- Using Distributed High Availability Solutions
7. Monitoring SQL Server
- Viewing Current Activity
- Using SQL Server Profiler
- Monitoring with DDL Triggers
- Using Event Notifications
8. Troubleshooting and Performance Tuning
- Troubleshooting SQL Server
- Performance Tuning in SQL Server
- Using Resource Governor
- Using Data Collector
9. Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
10. Implementing Data Integrity by Using Constraints and Triggers
- Data Integrity Overview
- Implementing Constraints
- Implementing Triggers
11. Implementing Views
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by Using Views
12. Implementing Stored Procedures
- Implementing Stored Procedures
- Creating Parameterized Stored Procedures
- Working With Execution Plans
- Handling Errors
Labs
Lab 1: Installing and Configuring SQL Server
- Installing SQL Server
- Configuring SQL Server
Lab 2: Managing Databases and Files
- Creating a Database
- Monitoring and Managing Filegroup Usage
- Creating a Policy
Lab 3: Disaster Recovery
- Designing a Backup Strategy
- Implementing a Backup Strategy
- Restoring and Recovering a Database
- Performing Piecemeal Backup and Restore Operations
- Restoring the master Database
Lab 4: Managing Security
- Creating Logins and Assigning Server-Scope Permissions
- Creating and Managing Users
- Using a Certificate to Protect Data
- Implementing SQL Server Audit
Lab 5: Implementing Replication
- Implementing Snapshot Replication
- Implementing Peer-to-Peer Transactional Replication
- Implementing HTTP Merge Replication
Lab 6: Maintaining High Availability
- Configuring Log Shipping
- Configuring Database Mirroring
- Implementing SQL Server Clustering
Lab 7: Monitoring SQL Server
- Monitoring SQL Server Activity
- Tracing SQL Server Activity
- Using DDL Triggers
- Using Event Notifications
Lab 8: Troubleshooting and Performance Tuning
- Troubleshooting Connectivity Problems
- Troubleshooting Concurrency Problems
- Using the Database Engine Tuning Advisor
- Implementing Resource Governor
- Implementing Data Collector
Lab 9: Creating Data Types and Tables
- Creating Data Types
- Using New Date and Time Data Types
- Creating Tables
- Creating Partitioned Tables
Lab 10: Implementing Data Integrity by Using Constraints and Triggers
- Creating Constraints
- Disabling Constraints
- Creating Triggers
Lab 11: Implementing Views
- Creating Views
- Creating Indexed Views
- Creating Partitioned Views
Lab 12: Implementing Stored Procedures
- Creating Stored Procedures
- Working with Execution Plans
