"
You did a great service for me in helping me pass all my exams in a
2-month period and I am happy to say that my job is working out great.
Your training program is first rate. Your program makes it easy to learn, but most important you don't forget what you did learn from the course.
"
-
Paul Joyner
|
|
Live, Online Instructor-led MCTS: SQL 2008 Database
Developer Training
|
|
Microsoft Certified Technology Specialist (MCTS): SQL 2008 Database Developer Certification Training Packages |
Course Overview
Our complete MCTS: SQL 2008 Database
Developer packages give you the expert knowledge and hands-on experience you need to master SQL Server 2008 core technologies and pass the Microsoft exam for this important certification. Passing the MCTS: SQL 2008
Database Development exam is a prerequisite for attaining the advanced level
MCITP: SQL 2008 Developer 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 Notes: For information on the
combination MCTS/MCITP SQL 2008 Database Developer course
click here or on the
certification path chart.
Students who register for SQL
2008 training courses will also receive free access to SQL
2005 training.
|
These courses provide a comprehensive learning track for both new and experienced database administrators or developers to understand implementation, maintenance, database infrastructure, design and optimization of SQL 2008. The courses
include a detailed focus on SQL 2008 core topics required by either database administrators or developers such as installation, configuration, Transact-SQL queries, data management, XML interactions, database mirroring, high availability strategies, configuration for web service communications, and backup and restore.
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 | 30 hours | * | | 1 year of online access | X | 6 months | | Certification 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) | $59 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: MCTS: SQL 2008
Database Developer
- 70-433: TS: Microsoft SQL Server 2008: Database Development
|  | +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 | | 11 | 70-433 | $149.00 | Microsoft SQL Server 2008 Database Development | | | TOTAL VALUE/strong> | $149.00 | This is included in 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 | MCTS Self-Paced Training Kit (Exam Exam 70-433): Microsoft SQL Server 2008 Database Development | | | TOTAL VALUE/strong> | $59.99 | This is included in 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
- 1 year of hands-on experience as a database developer
OR
- 1 year of hands-on experience as a
database systems administrator or support specialist
|
|
Course Overview
|
SQL 2008 Database Development
- Creating and Altering Tables, Views, and Indexes
- Implementing Partitioning Solutions
- Creating Constraints, and User-Defined Types
- Creating and Altering Stored Procedures
- Working with Transact-SQL
- Working with Table Valued Parameters (TVP)
- Creating DML and DDL Triggers
- Managing XML Data
- Creating CLR-based objects
- Returning Data with the OUTPUT Clause
- Modifying Data with MERGE Statements
- Combining Datasets
- Applying Scalar Functions
- Implementing Subqueries
- Implementing Common Table Expressions (CTE)
- Applying Ranking Functions
- Controlling Execution Plans
- Managing International Considerations
- Integrating Database Mail
- Implementing Full Text Search
- Using Windows PowerShell and SQL Server Management Objects (SMO)
- Implementing Service Broker Solutions
- Gathering Performance Information
|
|
| | |
|
|
©/a> 2003 - 2008 INSIDER TRAINING, INC. All rights reserved. |
