From Videos/CDs to Boot Camp Classes...
      at Training Planet it's all about choice.™

"I did it and so can you. Self-Study can and does work"

Ask a Question

MCITP Database Developer 2008 Certification Training Course:
Microsoft Certified IT Professional

The Microsoft MCITP Database Developer 2008 Training Package from QuickCert include expert instructor-led training modules with customized presentations, practice exam simulators and learning supplements for an all-inclusive training program that provides all the benefits of classroom training at your own pace.

Quickert's MCITP Database Developer 2008 Training Package includes the following exams:
70-433
70-451

The Microsoft Certified IT Professional: Database Developer 2008 (MCITP: Database Developer 2008) certification training course from QuickCert enables students with the knowledge and skills needed to design a secure, stable, enterprise database solution by using Microsoft SQL Server 2008.

Database developers design and implement relational database models and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or CLR. They retrieve or modify data by using SQL queries or tune and optimize queries.

As a Microsoft Certified Partner, you can be certain that QuickCert's comprehensive MCITP: Database Developer 2008 training courses will provide you with all the tools necessary to successfully prepare for your MCITP: Database Developer certification.




MCITP: Database Developer - Core Curriculum
Exam 70-433:TS: Microsoft SQL Server 2008 -Database Development
Exam 70-451:PRO: Designing Database Solutions and Database Access Using SQL Server 2008

Implementing a Microsoft SQL Server 2005 Database Exam 70-433:TS:
(Course 2779)
Module-1 Creating Databases and Database Files
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Module-2 Creating Data Types and Tables
Creating Data Types
Creating Tables
Creating Partitioned Tables
Module-3 Using XML
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Using the XML Data Type
Module-4 Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes
Creating XML Indexes
Module-5 Implementing Data Integrity
Data Integrity Overview
Implementing Constraints
Implementing Triggers
Implementing XML Schemas
Module-6 Implementing Views
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
Module-7 Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Creating Functions
Handling Errors
Controlling Execution Context
Module-8 Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
Module-9 Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Maintaining a Microsoft SQL Server 2005 Database
(Course 2780)
Module-1 Installing and Configuring SQL Server 2005
Preparing to install SQL Server
Installing SQL Server
Managing a SQL Server 2005 Installation
Module-2 Managing Databases and Files
Planning databases
Creating databases
Managing databases
Module-3 Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Recovering Data from Database Snapshots
System Database and Disaster Recovery
Module-4 Managing Security
Overview of SQL Server Security
Securing the Server Scope
Securing the Database Scope
Managing Keys and Certificates in SQL Server
Module-5 Monitoring SQL Server
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Module-6 Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services
Module-7 Automating Administrative Tasks
Automating Administrative Tasks in SQL Server 2005
Configuring the SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers
Managing SQL Server Agent Security
Module-8 Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Module-9 Introduction to Replication
Overview of Replication
Replication Scenarios


Microsoft Exam 70-451: PRO- Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Course Introduction
Instructor Introduction
Course Outline
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

YOUR TRAINING PACKAGE INCLUDES:
Instructor-Led Training on Video
Demos and Lab Learning
Multi-Media Presentations
Practice Exams and Test Simulators
Self-Paced Navigation
DVD/CD-ROM Delivery

Microsoft Exam 70-433 and 70-451: MCITP: Database Developer Certification Training Course by Specialized Solutions / QuickCert:
ON DVD-ROM
Reg. $1195.00  ON SALE FOR $895.00    


 
SALE EXTENDED TO 03/12/2010
WHILE SUPPLIES LAST.

GET CERTIFIED
IN DAYS WITH
NATIONWIDE
BOOT CAMPS
Class Info >>>

MCSE Boot Camp
Cisco Boot Camp
PMP Boot Camp
SOX Boot Camp
CISSP Class
A+ / Network+

Train your entire company with any of our titles for one low price! Check out the
Site License
Online Training
and
Networkable Solutions
Details

THIS MONTHS MOST POPULAR COURSES ARE NOW ALL ON SALE!

PC Diagnostics

PMP Exam Prep

ITIL Certification Foundations

Autocad 2006 2D with FREE 3D

Certified Hacking Forensic Investigator
FREE Cisco PIX training

CDIA+ Document Imaging

Microsoft Project

CISSP Certification

Crystal Reports

Photoshop

Visual Studio 2008 C# and VB .NET 3.5

NEWLY UPDATED
A+ Certification

CISCO CCNA Security

EVERTHING YOU NEED TO WORK
AND SUPPORT WITH CONFIDENCE!

 HUGE WINTER SALE!