| MCTS Exam 70-432: Microsoft SQL Server 2008 - Implementation and Maintenance |
| Course Code : B97 |
 |
. Take Advantage of Software Assurance Vouchers for Free Training
|
|
Home > Course Catalog > Boot Camp Courses > |
| View Printable Format |  |
| Bootcamp Package Contents |
|
| Skill Level: Intermediate+ |
 
|
Course Benefits :
|
When you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance, you complete the requirements for the following certification:
• Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance
|
| FREE complete set of course materials |
| |
Who Should Attend?
|
This course is intended for IT Professionals who administer and maintain SQL Server databases. |
Course Overview
|
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. |
Course Pre-requisites
|
Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of Relational databases.
Core Windows Server skills.
Database design skills. |
Course Contents
|
Install and configure SQL Server 2008.
Backup and restore databases.
Manage security.
Transfer data into and out of SQL Server.
Automate administrative tasks.
Replicate data between SQL Server instances.
Maintain high availability.
Monitor SQL Server.
Create databases and database files.
Create data types and tables.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
Implement data integrity in Microsoft SQL Server 2008 databases by using triggers.
Implement views.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Your course materials (Kit)includes:
15% exam discount from Microsoft. Offer expires 12/31/13. Details inside.
Official self-paced study guide.
Practice tests with multiple, customizable testing options and a learning plan based on your results.
250+ practice and review questions.
Case scenarios, exercises, and best practices.
Sample chapters from related Microsoft Press® books.
180-day trial of SQL Server 2008 Enterprise Edition.
Fully searchable eBook of this guide.
|
 |
| |
