MCTS Accelerated: SQL Server 2008, Database Development

Level
Total time
Logo Perpetual Solutions
Provider rating: starstarstarstarstar 10 Perpetual Solutions has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Prerequisites:

This course is intended for IT Professionals who administer and maintain SQL Server databases. They should have experience in:

- 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.

Course Description:

This Accelerated certification programmes provide you with everything you need to gain certification in a shortest time. Includin…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Prerequisites:

This course is intended for IT Professionals who administer and maintain SQL Server databases. They should have experience in:

- 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.

Course Description:

This Accelerated certification programmes provide you with everything you need to gain certification in a shortest time. Including:

  • Course based on Microsoft Official Curriculum
  • All events delivered by QA's expert MCT team
  • Extended delivery days – normally 8:30am – 6:00pm
  • Practice tests taken with full support from your instructor
  • Exam 70-433 TS: Microsoft SQL Server 2008, Database Development taken on the last day of the course

This course includes the following modules:

Course Objectives

  • 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 and Database Files
  • Creating Data Types and Tables
  • Creating and Tuning Indexes.
  • Implementing Data Integrity by Using Constraints and Triggers
  • Using XML
  • Implementing Views.
  • Implementing Stored Procedures
  • Implementing Functions
  • Implementing Managed Code in the Database
  • Managing Transactions and Locks
  • Using Service Broker

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.