Koenig Solutions
Français | Nederlands | Deutsch | العربية
SQL Server Implementation and Maintenance Training, SQL Server Implementation and Maintenance Boot Camp, SQL Server Implementation and Maintenance Training Course, Image 1






Printer-Friendly Version

MCTS: Microsoft SQL Server 2008, Implementation and Maintenance Boot Camp Training


This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database.

The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

After completing this course, students will be able to:
  • Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
  • Plan, install and configure SQL Server 2008 R2
  • Backup and restore databases
  • Import and export wizards and explain how they relate to SSIS
  • Use BCP and BULK INSERT to import data
  • Manage security
  • Assign, configure fixed database roles and create and assign user defined database roles
  • Configure and assign permissions
  • Implement SQL Server 2008 R2 Audits
  • Manage SQL Server 2008 R2 Agent and Jobs
  • Configure database mails, alerts and notifications
  • Maintain databases
  • Configure SQL Profiler Traces and Use the Database Tuning Advisor
  • Monitor data by using Dynamic Management Views
  • Execute multi-server queries and configure a central management server
  • Deploy a data-tier-application
  • Troubleshoot common issues

Koenig offers MCTS: Microsoft SQL Server 2008, Implementation and Maintenance Boot Camp Training in 3 different tracks and 4 locations in India - Delhi, Dehradun, Shimla (Himalayas) and Goa Beach. To ascertain the right track for you, request for Knowledge Level Test.


Delhi Delhi Goa Dehradun
Without Hotel | Koenig Apartment | Koenig Inn | Koenig Inn Deluxe | 4 Star | 5 Star |
  Regular Track Fast Track Super Fast Track
Duration 9 Days 6 Days 4 Days
Prices
(USD)
1,100
(USD)
810
(USD)
710
 Schedule
Feb 1220 Feb - 27 Feb06 Feb - 10 FebAny Date™
Mar 1219 Mar - 26 Mar05 Mar - 09 MarAny Date™
Apr 1216 Apr - 23 Apr02 Apr - 06 AprAny Date™
May 1221 May - 28 May07 May - 11 MayAny Date™
Jun 1218 Jun - 25 Jun04 Jun - 08 JunAny Date™
Jul 1216 Jul - 23 Jul02 Jul - 06 JulAny Date™
Aug 1220 Aug - 27 Aug06 Aug - 10 AugAny Date™
Sep 1217 Sep - 24 Sep03 Sep - 07 SepAny Date™
Oct 1215 Oct - 22 Oct01 Oct - 05 OctAny Date™
Nov 1219 Nov - 26 Nov05 Nov - 09 NovAny Date™
Dec 1217 Dec - 24 Dec03 Dec - 07 DecAny Date™
Jan 1321 Jan - 28 Jan07 Jan - 11 JanAny Date™
Feb 1318 Feb - 25 Feb04 Feb - 08 FebAny Date™
Mar 1318 Mar - 25 Mar04 Mar - 08 MarAny Date™
Apr 1315 Apr - 22 Apr01 Apr - 05 AprAny Date™
May 1320 May - 27 May06 May - 10 MayAny Date™
Jun 1317 Jun - 24 Jun03 Jun - 07 JunAny Date™
Jul 1315 Jul - 22 Jul01 Jul - 05 JulAny Date™
Aug 1319 Aug - 26 Aug05 Aug - 09 AugAny Date™
Sep 1316 Sep - 23 Sep02 Sep - 06 SepAny Date™
Oct 1321 Oct - 28 Oct07 Oct - 11 OctAny Date™
Nov 1318 Nov - 25 Nov04 Nov - 08 NovAny Date™
Dec 1316 Dec - 23 Dec02 Dec - 06 DecAny Date™
Jan 1420 Jan - 27 Jan06 Jan - 10 JanAny Date™
Feb 1417 Feb - 24 Feb03 Feb - 07 FebAny Date™
Mar 1418 Mar - 25 Mar03 Mar - 07 MarAny Date™
Apr 1421 Apr - 28 Apr07 Apr - 11 AprAny Date™
May 1419 May - 26 May05 May - 09 MayAny Date™
Jun 1416 Jun - 23 Jun02 Jun - 06 JunAny Date™
Jul 1421 Jul - 28 Jul07 Jul - 11 JulAny Date™
• Regular Track and Fast Track can also be taken with 1-on-1™ training (at an extra cost) and you can start from Any Date™.
• Since Super Fast Track is held 1-on-1™, you can start from Any Date™.
• Prices include all applicable taxes.
  Prices include:
  Arrow Pre-course technical evaluation and baseline training
  Arrow Hands-on classroom training
  Arrow Exam Fee
  Arrow In-house testing in all 4 locations
  Arrow Microsoft Official Curriculum
  Arrow Single occupancy room and all meals (breakfast, lunch & dinner)*
  Arrow Free Wi-Fi Internet in the training centre
  Arrow Three months after-course usability reinforcement
  Arrow Airport pick and drop*
  Arrow Daily transport to training centre*
  Arrow Hospitality Desk Support - Renting / buying mobile phone, laptop, tours, etc.
  Arrow Travel from Delhi to Shimla / Dehradun & back by Train / Volvo and 2 transit nights stay in Delhi (if your training is in Shimla / Dehradun)

Koenig Prices include all costs from the time you arrive in India till you fly back.

* Applicable if you opt for accommodation provided by Koenig.
  
SQL Server Implementation and Maintenance Training, SQL Server Implementation and Maintenance Boot Camp, SQL Server Implementation and Maintenance Training Course, Image 2
SQL Server Implementation and Maintenance Training, SQL Server Implementation and Maintenance Boot Camp, SQL Server Implementation and Maintenance Training Course, Image20
SQL Server Implementation and Maintenance Training, SQL Server Implementation and Maintenance Boot Camp, SQL Server Implementation and Maintenance Training Course, Image 3
Quick Links
» Free Course Advice
» Check References
» Knowledge Level Test
» Testimonials
» How To Register
» Contact Us
Quick Information
Name
Email
Phone
Country
Comments / Question
How did you get to know about Koenig Solutions?
I wish to receive Koenig newsletters
Enter the code below
Schedule for MCTS: Microsoft SQL Server 2008, Implementation and Maintenance Boot Camp Training
Course# Course Contents Exam# Exam Regular Track (days) Fast Track (days) Super Fast Track (days)
6231B Maintaining a Microsoft SQL Server 2008 R2 Database 70-432
TS: Microsoft SQL Server 2008, Implementation and Maintenance 6 4 2
Balance Days SQL Server Implementation and Maintenance Training, SQL Server Implementation and Maintenance Boot Camp, SQL Server Implementation and Maintenance Training Course, Image 4 for day of arrival, exam(s) and practice 3 2 2
Total duration 9 6 4
Prerequisites :
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.
Some experience with database design.
Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.
 
SQL Server Implementation and Maintenance Training, SQL Server Implementation and Maintenance Boot Camp, SQL Server Implementation and Maintenance Training Course, Image 5 Top
Boot Camps: MCITP SQL Server 2008 Database Administration | MCTS SQL Server 2008 Database Development | MCITP SQL Server 2008 Database Development | MCTS SQL Server 2008 Business Intelligence Developer
  Privacy Policy | Terms of Service | Links | Passing Guarantee | Contact Us
All rights reserved. ©1997 - 2012, Koenig Solutions Pvt. Ltd.
  
SQL Server Implementation and Maintenance Training | SQL Server Implementation and Maintenance Boot Camp | SQL Server Implementation and Maintenance Training Course