"
This guy, intelligently, taught us the entire curriculum in a logical, sensible, concise, easy to understand, interesting manner. He reiterated the courseware and made it sound like poetry - and made it an enjoyable experience.
"
-
Ajay Prashar
|
|
MCTS/MCITP: SQL 2005 Database Developer
|
|
Microsoft Certified Information Technology Professional (MCITP): SQL 2005 Developer Certification Training Packages
with Microsoft Certified Technology Specialist (MCTS): SQL 2005 | Course Overview
Our complete MCITP: SQL 2005 packages give you the expert knowledge and hands-on experience you need to master SQL Server 2005 database development and pass all 3 Microsoft exams for this advanced level certification. This course includes preparation for both the MCTS: SQL 2005 prerequisite exam and the two advanced MCITP Developer exams. 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 2005 exam is a prerequisite
for achieving MCITP certification. This class includes both MCTS and
MCITP training. If you are interested in MCTS:
SQL 2005 only, click here. If you are interested in
MCITP Developer training only, click here.
 This course provides a comprehensive learning track for database developers to understand implementation, maintenance, database infrastructure design and optimization of SQL 2005. The course begins with a detailed focus on SQL 2005 Implementation and Design which includes foundational topics required by both database administrators and developers such as installation, configuration, Transact-SQL, data management, XML interactions, and backup and restore. Designing Database Solutions focuses on developer specific topics such as database design, object design, code-based security, reporting services, and notification services. 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 | 64 | 64 | | +LIVE class duration | 16 weeks | 16 weeks | | +LIVE class recordings | X | X | | Live hands-on labs on your schedule | 80 hours | * | | Extended Online access (months) | 12 | 6 | | Study Guide | X | * | | Ongoing instructor mentoring | X | * | | 3 Transcender test prep products (included in reg. fee) | $447 value | * | | 3 Premium course books (included in reg. fee) | $179 value | * | | Guaranteed certification | X | | | 1 Premium headset with microphone (included in reg. fee) | $75 value | $75 value |
* Included with On Demand Premium |
PREPARATION FOR EXAMS: MCTS: SQL 2005 and MCITP: SQL 2005 Developer - 70-431: TS: Microsoft SQL Server 2005: Implementation and Maintenance
- 70–441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0
- 70–442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
|  | +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-431 | $149.00 | MSCert: TS - Microsoft SQL Server 2005 Implementation and Maintenance | | 1 | 70-441 | $149.00 | MSCert: PRO - Designing Database Solutions Using Microsoft SQL Server 2005 | | 1 | 70-442 | $149.00 | MSCert: PRO - Designing and Optimizing Data Access Using Microsoft SQL Server 2005 | | | TOTAL VALUE | $447.00 | This is included in your +Live Premium and On Demand Premium registration fees. |
| | 3 Microsoft Press Self-Paced Training Kits
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 70-431): Implementing and Maintaining Microsoft SQL Server 2005 | | 1 | Microsoft Press | $59.99 | MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005 | | 1 | Microsoft Press | $59.99 | MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 | | | TOTAL VALUE | $179.97 | 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 administrator or developer
|
|
Course Overview
| SQL 2005 Implementation and Maintenance - Installing SQL Server 2005
- Configuring SQL Server 2005
- Creating Tables, Constraints, and User-Defined Types
- Creating Indexes
- Working with Transact-SQL
- Creating Partitions
- Implementing Views
- Managing XML Data
- Creating Functions, Stored Procedures, and Triggers
- Working with Flat Files
- Backing Up, Restoring, and Moving a Database
- Using Transact-SQL to Manage Databases
- Working with HTTP Endpoints
- Working with SQL Server Agent Jobs
- Monitoring and Troubleshooting SQL Server Performance
- Managing Database Snapshots
- Implementing Database Mirroring
- Implementing Log Shipping
- Managing Replication
- Working with Service Broker
- Creating Full-Text Catalogs
| SQL 2005 Designing Database Solutions - Designing a unit test plan for a database
- Creating a performance baseline and benchmarking strategy
- Creating a plan for deploying a database
- Controlling changes to source code
- Selecting and designing services to support business needs
- Designing a logical database
- Designing an application solution to support security
- Selecting appropriate database technologies and techniques
- Designing an application solution that supports reporting
- Designing data distribution
- Designing objects that define data
- Designing objects that retrieve data
- Designing objects that extend the functionality of the server
- Designing objects that perform actions
- Designing attributes
- Designing entities
- Designing entity relationships (ER)
- Designing database security
- Developing application that use reporting services
- Developing applications for notification services
- Developing packages for integration services
| SQL 2005 Designing and Optimizing Data Access - Designing appropriate data access technologies
- Designing an appropriate data access object model
- Designing a cursor strategy for a data access component
- Designing caching strategies
- Designing client libraries to write applications that administer a SQL server service
- Designing queries that use multiple active result sets (MARS)
- Writing and modify queries
- Designing queries for retrieving data from XML sources
- Designing a cursor strategy
- Designing code that validates input data and permissions
- Designing code that detects and reacts to errors
- Designing user-defined messages to communicate application events
- Managing concurrency by selecting the appropriate transaction isolation levels
- Designing the locking granularity level
- Designing transaction scopes
- Designing code that uses transactions
- Optimizing and tune queries for performance
- Optimizing indexing strategies
- Scaling database applications
- Resolving performance problems
- Optimizing data storage
|
| |
|
|
