Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
The Microsoft Certified IT Professional (MCITP) credential validates that an individual has the comprehensive set of skills necessary to perform a particular job role, such as database administrator or enterprise messaging administrator. MCITP certifications build on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. Therefore, you will earn one or more MCTS certifications on your way to earning an MCITP credential.
MCITP candidates are capable of deploying, building, designing, optimizing, and operating technologies for a particular job role. They make the design and technology decisions necessary to ensure successful technology implementation projects.
The MCITP for Database Developers is designed for individuals working with SQL Server 2008 and writing application code against systems that run SQL Server 2008, writing T-SQL or Microsoft .NET CLR code that runs inside SQL Server 2008, or developing solutions in SQL Server 2008
AUDIENCE PROFILE:
- Candidates for this exam typically work in an enterprise environment that has more than 500 personal computers and more than 100 servers and mostly create solutions for all types of enterprise issues. Candidates should have experience with the following:
- •Writing transact SQL queries
- Programming the database
- Troubleshooting programming objects (for example, stored procedures, triggers, user-defined functions [UDFs], user-defined types [UDTs], and queries)
- Database performance tuning and optimization
- Designing databases at both the conceptual and logical levels
- Implementing databases at the physical level
- Might be involved in designing and troubleshooting the data access layer of the application
- Gathering business requirements
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Microsoft Exam 70-433
Implementing Tables
Implementing Schemas
Creating Tables
Implementing Filestreams
Working Constraints
Partitioning Tables
Modifying Partitions
Module Review
TSQL Fundamentals
Retrieving Data
Modifying Data
Module Review
Advanced Querying Concepts
Built-In Functions
Handling Transactions and Errors
Advanced Query Techniques
Module Review
Specialized Data Types
XML
Spatial Types
Module Review
Creating Objects
Views
Stored Procedures
Functions
Triggers
CLR-Based Objects
Module Review
Service Broker
Service Broker Concepts
Implementing the Service Broker
Module Review
Managing SQL
Database Mail
External Tools
Tracking Data Changes
Module Review
Creating and Maintaining Indexes
Indexes
Specialized Indexes
Module Review
SQL Server Concurrency
Locks and Latches
Isolation Levels
Monitoring Locks
Module Review
Optimizing Performance
System Monitor
SQL Server Profiler
Database Engine Tuning Advisor
Module Review
Course Review
Exam Tips
70-433 Demo Scripts
Microsoft Exam 70-451
Module 1:
Module Overview
Table Design
Data Integrity
Data Types and Using a Filestream
Indexing
Module Review
Module 2: Physical Design
Module Overview
Server Design
Physical Table Design
Partitioned Tables
Module Review
Module 3: Database Services
Module Overview
SQL Agent
Service Broker
Full Text Search
Module review
Module 4: Security
Module Overview
Authentication
Authorization
Module Review
Module 5: Creating Objects
Module Overview
Views
Stored Procedures
Functions and triggers
Error Handling
CLR Based Objects
Module Review
Module 6: SQL Server Concurrency
Module Overview
Locks and Latches
Isolation Levels
Monitoring Locks and Managing Transactions
Module Review
Module 7: XML
Module Overview
Retrieving XML Data
Converting XML into Relational Data
Querying XML Data
Using the Nodes Method
Utilizing the Modify Method
Implementing Schemas
Module Overview
Module 8: Improving Queries
Module Overview
Advanced TSQL
Improving Performance
Module Review
Course Review
Exam Tips
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116