Microsoft Certified IT Professional (MCITP): Database Developer

Call 0800 056 3983 to discuss payment options.

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.

Related Courses

• MCITP Database Administrator
• MCTS SQL Server 2005.

Database Developer 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

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.

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

120 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.