Microsoft Certified IT Professional (MCITP): Database Developer

Prerequisites
To successfully complete your exams, you should have:

Experience of being a professional database developer who designs and implements database solutions
At least 3 years dedicated to database work, including, but not limited to, writing Transact-SQL queries, designing and implementing programming objects, optimising databases, designing databases at both the conceptual and logical levels, and implementing databases at the physical level
Worked in an enterprise or a medium-sized organisation
Experience in using Microsoft SQL Server 2005.
You should also have expertise in the following areas:

Writing Transact-SQL queries
Programming databases
Troubleshooting programming objects (e.g. stored procedures, triggers, user-defined functions and types, and queries)
Performing database performance tuning and optimisation
Designing databases, at both the conceptual and logical levels
Implementing databases at the physical level
Designing and troubleshooting the data access layer of the application
Gathering business requirements.
Who is this course for?
This course is for those looking to show that, with Microsoft SQL Server 2005, they can design a secure, stable, enterprise database solution.
What will I learn?
Upon successful completion of the course, you will be able to:
SQL Server 2005:

Install and configure SQL Server 2005
Implement high availability and disaster recovery
Support data consumers
Maintain databases
Monitor and troubleshoot SQL Server performance
Create and implement database objects.
Database Solutions Design:

Design Database Testing and Code Management Procedures
Design an Application Solution for SQL Server 2005
Design Database Objects
Design a Database
Develop Applications That Use SQL Server Support Services.
Data Access Design and Optimisation:

Design efficient access to a SQL Server service
Design a database query strategy
Design error-handling routines
Design a transaction strategy
Performance tune a database and a database application.
What certificate will I get?
After passing this course, you will receive the MCITP Database Developer certification, as well as the MCTS SQL Server 2005 certification.
You will also have passed one of three exams necessary to gain the MCITP Database Administrator certification.
What course materials do I get?
To help you excel in your examinations through effective and efficient learning, ICS will provide you with all the learning materials necessary:

Flash video tutorials led by a virtual instructor
Interactive simulations and resources
E-books
Practice exams
Microsoft-branded supporting textbook 
Course and assessment guide to help you pass your exams.
What support do I get?
You will have access to our dedicated ICS Technology Student Community, which will allow you to share and collaborate with your peers, get interactive and expert feedback from tutors and browse our resource library.
You will also receive 12 months of email tutorial support.
Sample Course Material
You need to upgrade your Flash Player!

This web site makes use of the Macromedia Flash player version 8 or newer.

svp_clip_id = 'd263691e2a30';
svp_player_color1 = '#a6a6a6';
svp_player_color = '#a6a6a6';
svp_player_height = '499';
svp_player_width = '640';
svp_transparent = 'false';
svp_pause='1';
svp_repeat='';
svp_bg_color='#FFFFFF';
svp_fs_mode='2';
svp_no_fullscreen='0';
svp_no_controls='';
svp_skin='0';
svp_start_img='0';
svp_use_div='v_playerd263691e2a30';
svp_brand_new_window='1';

Your browser does not support JavaScript! JavaScript is needed to display this video player!






Related Courses

MCITP Database Administrator
MCTS SQL Server 2005.



Course Outline
EXAM 70-431
Implementing a Microsoft SQL Server 2005 Database

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
Optimising 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
Optimising Performance by Using Views
Module 7 - Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterised 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

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 Back-up 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.
EXAM 70-441 & 70-442
You need to upgrade your Flash Player!

This web site makes use of the Macromedia Flash player version 8 or newer.

svp_clip_id = '3548351f6a87';
svp_player_color1 = '#a6a6a6';
svp_player_color = '#a6a6a6';
svp_player_height = '499';
svp_player_width = '640';
svp_transparent = 'false';
svp_pause='1';
svp_repeat='';
svp_bg_color='#FFFFFF';
svp_fs_mode='2';
svp_no_fullscreen='0';
svp_no_controls='';
svp_skin='0';
svp_start_img='0';
svp_use_div='v_player3548351f6a87';
svp_brand_new_window='1';

Your browser does not support JavaScript! JavaScript is needed to display this video player!






You need to upgrade your Flash Player!

This web site makes use of the Macromedia Flash player version 8 or newer.

svp_clip_id = 'fbfb9691afa3';
svp_player_color1 = '#a6a6a6';
svp_player_color = '#a6a6a6';
svp_player_height = '499';
svp_player_width = '640';
svp_transparent = 'false';
svp_pause='1';
svp_repeat='';
svp_bg_color='#FFFFFF';
svp_fs_mode='2';
svp_no_fullscreen='0';
svp_no_controls='';
svp_skin='0';
svp_start_img='0';
svp_use_div='v_playerfbfb9691afa3';
svp_brand_new_window='1';

Your browser does not support JavaScript! JavaScript is needed to display this video player!






Designing Microsoft SQL Server 2005 Server-Side Solutions

Module 1 - Selecting SQL Server Services to Support Business Needs
Overview of the Built-in SQL Server Services
Evaluating When to Use the New SQL Server Services
Evaluating the Use of Database Engine Enhancements
Module 2 - Designing a Security Strategy
Overview of Authentication Modes and Authorisation Strategies
Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing Objects to Manage Application Access
Creating an Auditing Strategy
Managing Multiple Development Teams Using the SQL Server 2005 Security Features
Module 3 - Designing a Data Modelling Strategy
Defining Standards for Storing XML Data in a Solution
Designing a Database Solution Schema
Designing a Scale-Out Strategy
Module 4 - Designing a Transaction Strategy for a SQL Server 2005 Solution
Defining Data Behaviour Requirements
Defining Isolation Levels
Designing a Resilient Transaction Strategy
Module 5 - Designing a Notification Services Solution
Defining Event Data
Designing a Subscription Strategy
Designing a Notification Strategy
Designing a Notification Delivery Strategy
Module 6 - Designing a Service Broker Solution
Designing a Service Broker Solution Architecture
Designing Service Broker Data Flow
Designing Service Broker Solution Availability
Module 7 - Planning for Source Control, Unit Testing, and Deployment
Designing a Source Control Strategy
Designing a Unit Test Plan
Creating a Performance Baseline and Benchmarking Strategy
Designing a Deployment Strategy
Module 8 - Evaluating Advanced Query and XML Techniques
Evaluating Common Table Expressions
Evaluating Pivot Queries
Evaluating Ranking Queries
Overview of XQuery
Overview of Strategies for Converting Data Between XML and Relational Formats.
Maintaining a Microsoft SQL Server 2005 Database

Module 1 - Approaching Database Design Systematically
Overview of Database Design
Gathering Database Requirements
Creating a Conceptual Database Design
Module 2 - Modelling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models
Module 3 - Modelling a Database at the Physical Level
Designing Physical Database Objects
Designing Constraints
Designing for Database Security
Designing Server and Database Options
Evaluating the Physical Model
Module 4 - Designing for Database Performance
Designing Indexes
Planning for Table Optimisation
Planning for Database Optimisation
Module 5 - Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures
Module 6 - Modelling Database Dependencies
Modelling Local Database Dependencies
Modelling Remote Database Dependencies.



Related CoursesPeople who viewed this course also viewed the following courses:








Assessment
Your knowledge of the course materials will be assessed by three examinations. These can be sat at your local authorised Prometric test centre:

TS: Microsoft SQL Server 2005 - Implementation and Maintenance: Exam 70-431
PRO: Designing Database Solutions by Using Microsoft SQL Server 2005: Exam 70-441
PRO: Designing and Optimising Data Access by Using Microsoft SQL Server 2005: Exam 70-442
Please note that examination fees are additional to course fees.
Hours of Study
80-200 hours
Minimum System Requirements

600MHz Intel Pentium III processor or equivalent
Windows 98, Windows 2000, Windows XP or Windows Vista
128MB RAM (256MB RAM recommended)
128MB available disc space
CD-ROM drive
Microsoft Internet Explorer 5.01SP2.