This course will cover the following topics to prepare students for the 70-432 SQL Server 2008 Implementation and Maintenance exam: how to install and configuring SQL Server 2008, maintaining SQL Server instances, managing SQL Server security, maintaining a SQL Server database, performing data management tasks, monitoring and troubleshooting SQL Server, optimizing SQL Server performance, and implementing high availability.
Course Modules
The Microsoft 70-432: SQL Server 2008 Implementation and Maintenance course is organized into the following modules
Module 1: Installing Microsoft SQL Server
- Introduction
- Installing Microsoft S Q L Server- Part1
- Installing Microsoft S Q L Server- Part2
- Choosing A Collation Setting
- Installing Microsoft S Q L Server Demo
Module 2: Navigating SQL Server
- Navigating S Q L Server
- Management Studio Demo
- S Q L Server Configuration Manager
- S Q L Server Configuration Manager Demo
Module 3: Data Types
- Data Types
Module 4: Databases
- Databases
- Creating A Database
- Creating A Database Demo
Module 5: Tables
- Tables
- Sparse Columns
- Creating A Table Demo
Module 6: Views
- Views
- Creating A View Demo
Module 7: Contraints
- Contraints
- Creating A Contraint Demo
Module 8: Store Procedures
- Store Procedures
- Common Language Runtime
- Store Procedures Demo
Module 9: Functions
- Functions
- Three Function Types
- Functions Demo
Module 10: Service Broker
- Service Broker
- Using Service Broker
Module 11: Data Integrity
- Data Integrity
- Planning And Education
Module 12: Permissions
- Permissions
Module 13: Logins, Roles and Credentials
- Logins And Roles
- More Roles And Credentials
- Users And Roles Demo
- Assigning A Role Demo
Module 14: Additional Security Tools
- Additional Security Tools
- Some Security Tools Demo
Module 15: Backing Up and Restoring Databases
- Backups
- Restoring Databases
- Backups Demo
Module 16: Endpoints
- Endpoints
- Endpoints Demo
Module 17: Linking Servers
- Linking Servers
Module 18: Triggers
- Triggers- Part1
- Triggers- Part2
- Triggers Demo
Module 19: Replication
- Replication
- Replication Coverage- Part1
- Replication Coverage- Part2
- Replication Demo
Module 20: Performing Indexing and Full-Text Searching
- Indexing
- S Q L Searching
- Searching And Indexing In S Q L Demo
Module 21: Transactions and Locks
- Transactions
- Locks
- Locks Demo
Module 22: Moving Data
- Moving Data
Module 23: Handling Specialty Data
- Handling Specialty Data
- X M L Demo
Module 24: High-Availability Methods
- High- Availability- Part1
- High- Availability- Part2
- Creating A Snaphot Demo
Module 25: Maintaining and Automating a SQL Server
- Maintaining And Automating A S Q L Server- Part1
- Maintaining And Automating A S Q L Server- Part2
- Setting Up A S Q L Email Demo
Module 26: Monitoring and Optimizing SQL Server
- Monitoring And Optimizing S Q L Server
- Monitoring And Optimizing S Q L Server Demo
Module 27: SQL Server Management Tools
- S Q L Server Management Tools- Part1
- S Q L Server Management Tools- Part2
Module 28: Troubleshooting Techniques
- Troubleshooting Techniques- Part1
- Troubleshooting Techniques- Part2
- Troubleshooting Utilities Demo
- Conclusion
