Focus on earning an MCTS Training Implementation and Maintenance certification on our intensive ACCELERATED track. Demonstrate your skill in working with SQL Server 2008.
Overview
This five-day accelerated track provides students with the knowledge and skills to implement and 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 implementing and maintaining a database.
This course is intended for IT Professionals who need to implement, administer and maintain SQL Server databases
Prerequistes
* Basic knowledge of the Microsoft Windows operating system and its core functionality. (Use windows explorer / internet explorer (i.e. things like find web page , create a folder); Login (CTRL+ALT+DELETE); Start a service using services add-in. (administration tools); Use a mouse, start menu etc.)
* Working knowledge of Transact-SQL.
* Working knowledge of relational databases.
* Some experience with database design.
What will the track cover?
* Installing and Configuring SQL Server
* Managing Databases and Files
* Disaster Recovery
* Managing Security
* Transferring Data
* Automating Administrative Tasks
* Implementing Replication
* Maintaining High Availability
* Monitoring SQL Server
* Troubleshooting and Performance Tuning
* Creating Databases, Database Files, Data Types and Tables
* Implementing Data Integrity by Using Constraints and Triggers
* Using XML
* Implementing Views, Stored Procedures and Functions
* Implementing Managed Code in the Database
* Managing Transactions and Locks
* Using Service Broker
Examination
Delegates will be provided with examination vouchers included in the price of the course. All exams are to be sat within 12 months of the voucher being issued and at the client’s convenience after the event:
* 70-432 Microsoft MCTS Certification SQL Server 2008, Implementation and Maintenance
No comments:
Post a Comment