This course is targeted at the professional level SQL Server 2008 Database Developer.
After the completion of this course the candidates will be able to implement tables and views, implement programmable objects, work with query fundamentals and apply additional query techniques in SQL Server 2008 R2
They will also learn how to work with additional SQL Server 2008 R2 components, XML data and gather performance information and perform query optimization.
Then the course will move on to designing conceptual and logical database design, designing strategies for database access, optimal query performance and transactions and concurrency.
After completing this course, students will be able to:
-
Design a database design strategy
-
Design a database for optimal performance
-
Design security for a database
-
Design programming objects
-
Design queries for performance
-
Design a transaction and concurrency strategy
-
Design an XML strategy
Koenig offers MCITP Database Developer: SQL Server 2008 Boot Camp in 3 different tracks and 4 locations in India - Delhi, Dehradun, Shimla (Himalayas) and Goa Beach.
|
Database Developer: SQL Server 2008 |
|
Course# |
Course Contents |
Exam# |
Exam |
Regular Track (days) |
Fast Track (days) |
Super Fast Track (days) |
|
2778 |
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL |
70-433* |
TS: Microsoft SQL Server 2008, Database Development |
3 |
2 |
1 |
|
6232B |
Implementing a Microsoft SQL Server 2008 R2 Database |
6 |
4 |
2 |
|
50401 |
Designing and Optimizing Database Solutions with Microsoft SQL Server 2008 |
70-451* |
PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 |
5 |
3 |
2 |
Balance Days for day of arrival, exam(s) and practice |
4 |
3 |
2 |
|
Total duration |
18 |
12 |
7 |
* The Exam will Expire on July 31, 2013
Prerequisite:
-
Working knowledge of relational databases (database design skills).
-
Core Windows Server skills.
-
Basic programming language.
Related Boot Camps: MCTS: Microsoft SQL Server 2008, Database Development | Career Enabler: Microsoft Database Developer |
Prices include:
»
Pre-course technical evaluation and baseline training
» Hands-on classroom training
» Exam Fee
» In-house testing in all locations
» Microsoft Official Curriculum
» Single occupancy accommodation and all
meals (breakfast, lunch & dinner)
*
»
Free Wi-Fi Internet in the training centre
» Three months
after-course usability reinforcement
» Airport pick and drop
*
» Daily transport to training centre
*
» Hospitality Desk Support - Renting / buying mobile phone, laptop, tours, etc.
» 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.