Overview 

Microsoft 70-432: SQL Server 2008 Implementation and Maintenance 

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.

Module 1: Installing Microsoft SQL Server

• 1.1 Introduction
• 1.2 Installing Microsoft SQL Server-Part 1
• 1.3 Installing Mircosoft SQL Server-Part 2
• 1.4 Choosing A Collation Setting
• 1.5 Installing Microsoft SQL Server Demo

Module 2: Navigating SQL Server

• 2.1 Navigating SQL Server
• 2.2 Management Studio Demo
• 2.3 SQL Server Configuration Manager
• 2.4 SQL Server Configuration Manager Demo

Module 3: Data Types

• 3.1 Data Types

Module 4: Databases

• 4.1 Databases
• 4.2 Creating A Database
• 4.3 Creating A Database Demo

Module 5: Tables

• 5.1 Tables
• 5.2 Sparse Columns
• 5.3 Creating A Table Demo

Module 6: Views

• 6.1 Views
• 6.2 Creating A View Demo

Module 7: Constraints

• 7.1 Constraints
• 7.2 Creating A Contsraint Demo

Module 8: Store Procedures

• 8.1 Store Procedures
• 8.2 Common Language Runtime
• 8.3 Store Procedures Demo

Module 9: Functions

• 9.1 Functions
• 9.2 Three Function Types
• 9.3 Functions Demo

Module 10: Service Broker

• 10.1 Service Broker
• 10.2 Using Service Broker

Module 11: Data Integrity

• 11.1 Data Integrity
• 11.2 Planning And Education (demo to be recorded)

Module 12: Permissions

• 12.1 Permissions

Module 13: Logins, Roles, and Credentials

• 13.1 Logins And Roles
• 13.2 More Roles And Credentials
• 13.3 Users And Roles Demo
• 13.4 Assigning A Role Demo

Module 14: Additional Security Tools

• 14.1 Additional Security Tools
• 14.2 Some Security Tools Demo

Module 15: Backing Up and Restoring Databases

• 15.1 Backups
• 15.2 Restoring Databases
• 15.3 Backups Demo

Module 16: Endpoints

• 16.1 Endpoints
• 16.2 Endpoints Demo

Module 17: Linking Servers

• 17.1 Linking Servers

Module 18: Triggers

• 18.1 Triggers-Part 1
• 18.2 Triggers-Part 2
• 18.3 Triggers Demo

Module 19: Replication

• 19.1 Replication
• 19.2 Replication Coverage-Part 1
• 19.3 Replication Coverage-Part 2
• 19.4 Replication Demo

Module 20: Performing Indexing and Full-Text Searching

• 20.1 Indexing
• 20.2 SQL Searching
• 20.3 Searching And Indexing In SQL Demo

Module 21: Transactions and Locks

• 21.1 Transactions
• 21.2 Locks
• 21.3 Locks Demo

Module 22: Moving Data

• 22.1 Moving Data

Module 23: Handling Specialty Data

• 23.1 Handling Specialty Data
• 23.2 XML Demo

Module 24: High-Availability Methods

• 24.1 High-Availability-Part 1
• 24.2 High-Availability-Part 2
• 24.3 Creating A Snapshot Demo

Module 25: Maintaining and Automating a SQL Server

• 25.1 Maintaining And Automating A SQL Server-Part 1
• 25.2 Maintaining And Automating A SQL Server-Part 2
• 25.3 Setting Up A SQL Email Demo

Module 26: Monitoring and Optimizing SQL Server

• 26.1 Monitoring And Optimizing SQL Server
• 26.2 Monitoring And Optimizing SQL Server Demo

Module 27: SQL Server Management Tools

• 27.1 SQL Server ManagementTools-Part 1
• 27.2 SQL Server ManagementTools-Part 2

Module 28: Troubleshooting Techniques

• 28.1 TroubleshootingTechniques-Part 1
• 28.2 TroubleshootingTechniques-Part 2
• 28.3 Troubleshooting Utilities Demo
• 28.4 Conclusion

This package is designed for any individual wishing to pursue or enhance their career as a Microsoft Engineer.

Our Online Courses is a cost-effective and successful approach for many individuals. It provides a flexible learning method, allowing candidates to schedule learning at a time that suits them and fits in with other commitments; ideal for those who find it difficult to take time away from their workplace. It also allows candidates to work at their own pace, and revisit sections of the course as often as needed, leading to a fuller understanding of all the topics covered.

In addition, there are none of the high costs of travel and accommodation associated with courses at an external venue.

Exam Information

You'll sit an exam at a local test centre. We provide interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for the real thing. Once you've passed with at least 80%, you'll be able to book your exam as a private candidate.

Please NOTE: Exams are not included.

How To Schedule Your Microsoft Exam

• Go to the Microsoft exam page
• Select the exam you are looking to take from the list
• Click the orange button that says 'Schedule with Pearson VUE', you will then be asked to sign in
• If you already have a Microsoft profile, please sign in here, or if it is the first time you have used this site, please click 'Sign up now'
• Fill out your details on the registration form and click 'Save and continue'
• Confirm your details and click 'Submit'
• You will then be transferred to the 'Pearson VUE' website to select your exam date and complete your booking
• Then check out using your personal payment details

Got a question about exams? Contact our course advisors by email or by phone on 0203 633 4671. We're happy to help!

Good Luck in your exams!