Home > Training > Microsoft > SQL8DAD

MCITP: SQL 2008 R2 Database Administrator & Developer (SQL8DAD)

Download PDF Download Course Outline (PDF)
Course Description Schedule Course Outline
 

What's Included?

  • 14 days of intensive boot- camp style training with no distractions
  • After Hours Sessions: Instructors remain into the evening hours in order to help students in need.
  • Authorized Microsoft Curriculum
  • Pre-class Study Guide, shipped to your home
  • Supplemental Exam Prep material and Practice Exams
  • All 4 Exams Delivered during class
  • 14 Hotel Nights
  • Make-up exam vouchers if necessary
  • Breakfasts, Lunch, snacks and beverages all day, every day
  • Flight to and from Sarasota from anywhere in the Continental U.S.
  • Shuttle to and from the Airport
  • Shipment of course books back home after the program (we provide you a lot of materials, and want to save you the headache/back ache and the cost of extra baggage fees)
  • Top-notch training facilities with cutting edge computers and 20 inch monitors
  • Student Work areas with executive chairs and 5 ft of desk area
  • Small class sizes: no more than 16 students per class
  • Ground transportation

Who should attend

Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) for SQL Server 2008 is the premier certification for database server administrators. The certification confirms that you are fully qualified to administer Microsoft SQL databases and architect entire application level solutions.

Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) for SQL Server 2008 is the premier certification for database server developers. The certification confirms that you are fully qualified to develop databases and architect entire application level solutions.

Certifications:

  • MCTS: SQL Server 2008, Implementation and Maintenance
  • MCITP: Database Administrator 2008
  • MCTS: SQL Server 2008, Database Development
  • MCITP: Database Developer

Exams:

  • Exam 70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance
  • Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
  • Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
  • Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Prerequisites

The candidate works in a development environment that uses SQL Server technologies. The candidate should have at least one year of experience installing, configuring and securing SQL Servers.

The candidate should also have a fundamental understanding of database concepts. While the course starts with foundations, it’s moves quickly into more advanced topics. A background in any TSQL database environment would beneficial.

Course Objectives

Database administrators install, configure and secure databases. Administrators are often tasked with evaluating the performance of the SQL Server by implements partitions and index tuning. Additionally, high availability strategies like Database Mirroring, Log Shipping and Clustering are included in administrators' responsibilities. Database administrators are typically employed by small or mid-sized to large-sized organizations.

Our MCITP: SQL Server 2008 R2 Administrator bootcamp is a very hands on environment. Our instructors guide you through step by step examples and demonstrations, not just long lectures. Your instructor will create real world scenarios for lab environments

Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. Database developers are typically employed by mid-sized to large-sized organizations.

Our MCITP: SQL 2008 Developer bootcamp is a very hands-on environment. Our instructors guide you through step by step examples and demonstrations, not just long lectures. Your instructor will create real world scenarios for lab environments.

Duration: 14 days

Price:
  • US$ 6,995
 
Click City Name To BookSchedule
This green checkmark in the Upcoming Schedule below indicates that this date/time is Guaranteed To Run in accordance with Fast Lane's terms and conditions.
United States
 May 26-Jun 8, 2012 Guaranteed to Run Sarasota 11 days Partner Delivery Partner Delivery Enroll
Jul 7-20, 2012 Sarasota 11 days Partner Delivery Partner Delivery Enroll