Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

Manhattan Studies Institute

Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

$ 0.00

Course Description

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Installing and configuring SQL Server 2008 (11%) Maintaining SQL Server instances (9%) Managing SQL Server security (18%) Maintaining a SQL Server database (17%) Performing data management tasks (10%) Monitoring and troubleshooting SQL Server (14%) Optimizing SQL Server performance (12%) Implementing high availability (9%)

Course Outline

Mod 1 Installing Microsoft SQL Server
Mod 2 Navigating SQL Server
Mod 3 Data Types
Mod 4 Databases
Mod 5 Tables
Mod 6 Views
Mod 7 Constraints
Mod 8 Store Procedures
Mod 9 Functions
Mod 10 Service Broker
Mod 11 Data Integrity
Mod 12 Permissions  
Mod 13 Logins, Roles, and Credentials
Mod 14 Additional Security Tools
Mod 15 Backing Up and Restoring Databases
Mod 16 Endpoints
Mod 17 Linking Servers
Mod 18 Triggers
Mod 19 Replication
Mod 20 Performing Indexing and Full-Text Searching
Mod 21 Transactions and Locks
Mod 22 Moving Data
Mod 23 Handling Specialty Data
Mod 24 High-Availability Methods
Mod 25 Maintaining and Automating a SQL Server
Mod 26 Monitoring and Optimizing SQL Server
Mod 27 SQL Server Management Tools
Mod 28 Troubleshooting Techniques