"
Thank you soooo much!
You guys are awesome. I have been recommending you and will continue to do so in the future!
"
-
Sean Butler
|
|
Live, Online Instructor-led MCITP: SQL 2008 Database Developer
Training
|
Microsoft Certified Information Technology Professional (MCITP): SQL 2008 Database Developer Certification Training Packages | Course Overview
Our complete MCITP: SQL 2008 packages give you the expert knowledge and hands-on experience you need to master SQL Server 2008 database development and pass
the Microsoft exam for this advanced level certification. For one low price, you‘ll tap into the most powerful learning system available anywhere. The Insider Training Multi-Path Learning System will maximize what you learn, and more importantly, how much you retain.
Important Note: Passing the MCTS: SQL 2008 Developer exam is NOT a prerequisite for taking this MCITP course.
However, we strongly recommend learning the MCTS: SQL 2008 objectives, which cover a broad range of database developer topics,
before attending the MCITP course. Passing the MCTS: SQL 2008 Developer exam is a prerequisite for achieving MCITP certification. If you are interested in a
combination MCTS/MCITP course, click here.
Students who register for any SQL 2008 course will also receive
access to SQL 2005 training for free.
This course provides a comprehensive learning track for database developers to understand advanced implementation,
design and optimization issues for SQL 2005. Designing Database Solutions focuses on developer specific
topics such as database design, object design, code-based security, programming objects, and optimal performance.
The Designing and Optimizing Data Access portion of the course focuses on advanced topics such as caching, cursors, locking, XML,
transaction optimization, data management, and optimizing code for performance.
Available Course Formats: |
| | Available Formats | | Key Benefits | +LIVE Premium | On Demand
* | | Expert instructors | X |
X | | Flexible scheduling | X |
X | | No travel required | X |
X | | No out of office days | X |
X | | Key Features | | +LIVE class hours |
20 | 20 | | +LIVE class duration |
5 weeks | 5 weeks | | +LIVE class recordings | X | X | | Live hands-on labs on your schedule | 60 hours | * | | Extended Online access (months) | 12 | 6 | | Study Guide | X | * | | Ongoing instructor mentoring | X | * | |
1 Transcender test prep product (included in reg. fee) | $149 value | * | |
1 Premium course book (included in reg. fee) | $60 value | * | | Guaranteed certification | X | | | 1 Premium headset with microphone (included in reg. fee) | $75 value | $75 value |
* On Demand Premium is currently not available for this course |
PREPARATION FOR EXAMS:
MCITP: SQL 2008 Developer - 70-451: PRO: Designing Database Solutions and Data Access by Using Microsoft SQL Server 2008
|  | +LIVE Online Instructor Led Sessions
We know you‘re busy. That‘s why we‘ve designed a flexible training schedule that works around you! The +LIVE course meets twice a week for two hours at a time for live, online, instructor-led sessions.
Our unique 7-step program starts with hand-picked, certified trainers with extensive consulting and training backgrounds. Each week you‘ll attend live, information-packed sessions that cover three to four major topics in depth. Because it‘s live, you‘ll be able to get your toughest questions answered right away. In-class quizzes and surveys will ensure that you‘re absorbing the key points along the way. | | 24/7 Access to Class Recordings
Need to miss a class? No problem! All class sessions are
digitally recorded and automatically indexed so that you can review the material at any time. You‘ll be able to tap into your class recordings immediately after the live sessions
and have extended access for a full twelve months starting from when
your course begins. | | Hands-On Lab Time
Insider Training‘s remote lab gives you the ability to put your knowledge to work on real systems on your own schedule. Your private lab time is scheduled in advance at any time convenient for you. When you connect in, you‘ll be in total control of multiple real systems. | | Ongoing Instructor Mentoring
Your instructor is available to answer your questions inside and outside of class. You‘ll have email access for
twelve months starting from when your course begins. | | Highest-Rated Transcender Practice Exam Simulations Before tackling the real exam, you‘ll know you‘re prepared by taking these hard-hitting practice exams. Each simulation provides three complete practice exams with questions that closely match the style and wording of the real thing. Each question explains both the right and wrong answers with references to supporting documentation.
|
| | | Exam ID | Price | Transcender Product | | 1 | 70-451 | $149.00 | MSCert: PRO - Designing Database Solutions and Data Access by Using SQL Server 2008 |
| | TOTAL VALUE | $149.00 | This is included your +Live Premium and On Demand Premium registration fees. |
| |
1 Microsoft Press Self-Paced Training Kit
Each kit includes hands-on practice labs, and sample test questions. They‘re clearly written and highly regarded by our instructors and students alike.
|
| | | Publisher | Price | Name | | 1 | Microsoft Press | $59.99 | MCITP Self-Paced Training Kit (Exam 70-451): Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 |
| | TOTAL VALUE | $59.99 | This is included your +Live Premium and On Demand Premium registration fees. |
|
Certification Guarantee
If you purchase the +LIVE Premium and you meet the course prerequisites, we guarantee that you will pass your certification exams. If you do not pass an exam, we will assign an instructor to work with you until you succeed.
| PREREQUISITES: - Broadband Internet connectivity (DSL, Cable or other high-speed connection)
AND -
Training or certification on MCTS: SQL 2008 Developer
AND
- 1 year of hands-on experience as a database administrator or developer
|
|
Course Overview
|
SQL 2008 Designing Database Solutions and Data Access
- Identify SQL Server components to support business requirements
- Design a database model
- Design a Service Broker solution
- Design a full text search strategy
- Identify when to use the new datatypes
- Design tables, views, data integrity, and stored procedures
- Design scalar and table-valued user defined functions
- Design CLR user defined functions
- Design CLR stored procedures, aggregates and types
- Protect against SQL injection
- Design locking hints
- Design transactions
- Design for concurrency
- Design XML storage
- Query and Modify XML data
- Use the FOR XML types
- Transform XML to relational data
- Optimize and tune queries
- Analyze execution plans
- Design index strategies
- Design scalable solutions
- Resolve performance issues
- Design a compression strategy
- Design table and index partitioning strategies
|
| |
|
|
|
