Customer Service 0121 248 2400
Learning247 - CareerVision Training Ltd
Learn From the Experts
Training The World
Have a Question?Have a Question? Call 0121 248 2400 or Click here to send us a message.

TRAINING CATEGORIES

Top Selling Courses

MORE CATEGORIES

 


We've Trained Thousands
Pay by Installments

MS Office Training Bundles


Powered by WorldPay




  

  Home > IT CERTIFICATION >

  MCITP Database Developer 2008 Certification Training Course
MCITP Database Developer 2008 Certification Training Course


 
List Price: £572.00 (£686.40 inc VAT)
Our Price: £249.00 (£298.80 inc VAT)

Product Code: RC194651

Purchase Options

Choose Purchase Options*: 		DVD-ROM Course
12 Month Online Course

Qty:  
Description
 


This Item is Eligible for Instalment Payments - Please email sales@cvision.co.uk for details or call 0121 248 2400.

PACKAGE INCLUDES:

 •  Instructor Led Video Training on DVD or Online
 •  Demos and Lab Learning
 •  Multimedia Presentations and Self-Paced Navigation
 •  Practice Exam and Test Simulator
 •  Online & Telephone Tutor Support

Compatible with:
Windows NT , 95 , 98 , 2000 , ME , XP , 2003 , Vista , Windows 7
 
Microsoft Certified

GET IN THE LEAD - Get Certified Today!

Experience the benefits of classroom learning - anytime,
anywhere! Our expert instruction and multi-media
courses are to get you certified - or your money back!

 

COURSE DESCRIPTION

The Microsoft MCITP Database Developer Training Package includes 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.

Our MCITP Database Developer Training Package includes the following exams:

  • 70-433
  • 70-451

The Microsoft Certified IT Professional: Database Developer (MCITP: Database Developer) 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 our comprehensive MCITP: Database Developer training courses will provide you with all the tools necessary to successfully prepare for your MCITP: Database Developer certification.  

COURSE OUTLINE

MCITP Database Developer SQL Server 2008 Certification Training:


SQL Server 2008 - Database Development (70-433) Training Course Curriculum:


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

SQL Server 2008 (70-451) - Designing Database Solutions and Data Access Training Course Curriculum:

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

Share your knowledge of this product. Be the first to write a review »
Sign up for our emails to save 10% off your first purchase and
receive information on:
  • New Training Titles, Industry News & Events
  • Tips & Tricks from our Expert Presenters
  • Increasing your Skills, Marketability & Income.
  • Free Training Clips & Special Offers
Save10%Off
SUBSCRIBE NOW & JOIN TENS OF THOUSANDS OF PEOPLE WORLDWIDE
WHO LEARN TO GET THE MOST FROM THEIR SOFTWARE WITH US!
No Thanks!