Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

$99.00

This course will cover the following topics to prepare students for the Microsoft 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.

Microsoft certifications are in high demand across small and large Information Technology organizations around the world. Hiring managers prefer candidates who not only have an understanding of the topic(s) and experience, but having the training certification in the subject. As a result, all Microsoft certifications are accepted worldwide and are part of the industry standards.

This Microsoft 70-432 exam measures your ability to accomplish the technical tasks below:

  • 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%)

Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database administration is their main area of responsibility. Or who work in environments in which databases are central to their primary job roles.

These job roles include the following:

  • IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
  • IT professionals who manage systems that run SQL Server 2008
  • Developers who build applications that use SQL Server 2008
  • IT professionals who work with third-party applications that are built on SQL Server 2008

This exam has been retired, but continues to be a valuable resource for learning!

For complete information on this certification course, please visit the Microsoft website for details and exam pricing.

To see more Microsoft related training, click here.

Course Outline

Installing on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance
  •  Introduction
  •  Installing Part 1
  •  Installing Part 2
  •  Installing Part 2 Demo 1
  •  Installing Part 2 Demo 2
Getting familiar with SQL on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance
  •  Getting Familiar With SQL Part 1
  •  Getting Familiar With SQL Part 1 Demo
  •  Getting Familiar With SQL Part 2
  •  Getting Familiar With SQL Part 2 Demo
  •  Getting Familiar With SQL Part 3
  •  Getting Familiar With SQL Part 3 Demo
Types of Data on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance
  •  Data Types
  •  Data Types Demo
Databases on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance
  •  Databases Part 1
  •  Databases Part 1 Demo
  •  Databases Part 2
  •  Databases Part 2 Demo
  •  Databases Part 3
Looking at Tables on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance
  •  Tables
  •  Tables Demo
Module 6: Looking at Views
  •  Views Part 1
  •  Views Part 1 Demo
  •  Views Part 2
  •  Views Part 2 Demo
  •  Views Part 3
Module 7: About Constraints
  •  Constraints Part 1
  •  Constraints Part 1 Demo
  •  Constraints Part 2
Module 8: Looking at Stored Procedures
  •  Stored Procedures Part 1
  •  Stored Procedures Part 1 Demo
  •  Stored Procedures Part 2
Module 9: Functions
  •  Functions
  •  Functions Demo
Modules 10: About Service Broker
  •  Service Broker Part 1
  •  Service Broker Part 2
Modules 11: Integrity
  •  Data Integrity Part 1
  •  Data Integrity Part 2
Modules 12: Permissions in SQL
  •  Permissions Part 1
  •  Permissions Part 1 Demo
  •  Permissions Part 2
Modules 13: Accounts
  •  Logins Roles And Credentials
  •  Logins Roles And Credentials Demo
Modules 14: Security
  •  Additional Security Tools
  •  Additional Security Tools Demo
Modules 15: Backups/Restores
  •  Backing Up And Restoring Databases Part 1
  •  Backing Up And Restoring Databases Part 2
  •  Backing Up And Restoring Databases Demo
Modules 16: Endpoints
  •  Endpoints
Modules 17: Servers working together
  •  Linking Servers
Modules 18: Triggers in SQL
  •  Triggers
Modules 19: Replication between servers
  •  Replication Part 1
  •  Replication Part 2
Modules 20: Indexes
  •  Performing Indexing And Full Text Searching
Modules 21: Transactions in SQL
  •  Transaction And Locks
Modules 22: Data moves
  •  Moving Data
Modules 23: Data specialties in SQL
  •  Handling Specialty Data
Modules 24: Fault Tolerance
  •  High-Availability Methods Part 1
  •  High-Availability Methods Part 2
Modules 25: SQL Management
  •  Maintaining And Automating SQL Server
Modules 26: SQL Management Monitoring
  •  Monitoring And Optimizing SQL Server
  •  Monitoring And Optimizing SQL Server Demo
Modules 27: SQL Management tools
  •  SQL Server Management Tools
Module 28: Troubleshooting
  •  Troubleshooting Techniques
  •  Troubleshooting Techniques Demo
Module 29: Course Review
  •  Course Review Part 1
  •  Course Review Part 2
  •  Course Review Part 3
  •  Course Review Part 4
  •  Course Review Part 5
Module 30: Common Questions
  •  Common Student Questions Part 1
  •  Common Student Questions Part 2
Module 31: Real World Scenarios
  •  Real World Scenarios Part 1
  •  Real World Scenarios Part 2
Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

9 Hours 10 Minutes

146 Course Videos

58 Test Questions


Save For Later
Add to Wishlist