MCTS Accelerated: SQL Server 2008, Database Development

5 Day Course
Hands On
Official Microsoft Curriculum
Code QAMCTSSQDD

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

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

Course Objectives (21 topics)

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

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor

  • SQL Language

    The SQL Language training course will teach the student how to read and write good SQL for querying, updating and maintaining SQL databases

    course code DBSQLLG-2 Onsite available
Ask a Question

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course