MCITP Database Developer 2008 Certification (70-433 & 70-451) Online Training Bundle

MCITP Database Developer 2008 Certification (70-433 & 70-451) Online Training Bundle

Course Outline

The MCITP: Database Developer SQL 2008 certification training course enables students with the knowledge and skills needed to design a secure, stable, enterprise database solution by using Microsoft SQL Server 2008. It covers exams 70-433 & 70-451.

OUR Price

£240.00

£200.00+ VAT

R.R.P.

£354.00

£295.00+ VAT

 

Key Features

  • 12 Months Unlimited 24x7 Online Access
    • 24x7 online access to the course materials - anytime, anywhere, and on any device. Just log-in online and learn the skills you need - all at your own pace.
  • Self-Paced Navigation
    • With all courses arranged via multiple on-demand sections, comprehensive navigation & controls allow you to fast forward, skip, rewind, restart, and effectively control your learning pace. This makes it easy to stop at any time, and then quickly get back to where you left off.
  • Expert Instructor-Led Multimedia Training
    • Get trained with full multimedia materials by the finest expert instructors in IT today. This creates a truly personal learning experience, and simulates all the benefits of classroom based learning - all from the comfort of your own home/office.
  • Multi-Tiered Exam Preparation
    • Objective Testing : Utilising questions that follow a specific module, focusing on specific key skills within that area of knowledge.
    • Full Practice Exams : Broad-base exams that cover multiple modules, or the entire syllabus.
    • Certification Practice : Learn where your strong & weak points exist. Simulators give you the chance to practice an actual certification exam. These simulators adhere to the same format as the actual exam provided by a testing centre.
    • The flexibility of these exam simulators & practice-tests allows you to monitor what you've learned, giving you the confidence required to pass your exams at the first attempt.
MCITP Database Developer 2008 Certification (70-433 & 70-451) Online Training Bundle

Course Description

This Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) certification training course 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.

This program covers the following exams:

Exam 70-433 : Microsoft SQL Server 2008, Database Development

Instructor Introduction
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

Exam 70-451 : Designing Database Solutions & Data Access Using Microsoft SQL Server 2008

Course Introduction
Instructor Introduction
Course Overview

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

(Any associated exam costs are not included)
FREE : IT Certification & Career Training Guide