Hands On

Hands On Training

This course includes practical application of the subjects covered.

Curriculum Microsoft
Course Code QAMCTSSQIM
Duration 5 Days
Price $4,060
Booking Book Now Request Info

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-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance exam taken on the final day of your course

Course Modules

Course Topics (17 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, 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

Prerequisites

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

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 9 Classroom dates 6 locations

Course Dates

CodeLocationDurationPrice Apr May Jun Jul Aug Sep
QAMCTSSQIM 5 days $4,060

Save

Share

Recommend

Sales: 408-759-5074
Callback
Enter your number
Live Chat Email