|
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
5/18/2012
WHILE SUPPLIES LAST.
|
