Microsoft Certified IT Professional (MCITP): Database Developer
Course Schedule & Online Registration
If you are an individual, please click here.
If you are representing a company, please click here
Target Audience
IT professionals who wanted to pursue careers as database administrators, database developers, or business intelligence developers.
Course Overview
MCITP certifications build on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. Therefore, you will earn one or more MCTS certifications on your way to earning an MCITP credential.
The course enables the trainees:
Design and Implement relational database models (logical and physical) and database storage objects
Retrieve or modify data using SQL queries or tune and optimise queries
Course Duration
133 hours / 19 days
Assessment
Trainess are required to sit for 1 MCTS exam and 2 Professional Series Exams
Core exams
(3 required) |
Classroom Training |
Exam 70-431:
Microsoft SQL Server 2005 - Implementation and Maintenance |
Course 2779:
Implementing a Microsoft SQL Server 2005 Database
(5 Days)
and
Course 2780:
Maintaining a Microsoft SQL Server 2005 Database
(5 Days) |
Exam 70-441:
Designing Database Solutions by Using Microsoft SQL Server 2005 |
Course 2781:
Designing Microsoft SQL Server 2005 Server Side Solutions
(3 Days)
and
Course 2782
Designing Microsoft SQL server 2005 Databases
(2 Days) |
Exam 70-442:
Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 |
Course 2781:
Designing Microsoft SQL Server 2005 Server Side Solutions
(3 days)
and
Course 2783
Designing the Data Tier for Microsoft SQL Server 2005
(1 Day)
and
Course 2784
Tuning and Optimizing Queries Using Microsoft SQL Server 2005
(3 Days)
|
Course Outline
Implementing a Microsoft SQL Server 2005 Database
Course Code: 2779
Course Duration: 35hrs / 5 days
Creating Databases and Database Files
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Creating Data Types and Tables
Creating Data Types
Creating Tables
Creating Partitioned Tables
Using XML
Retrieving XML by using FOR XML
Shredding XML by using OPEN XML
Introducing XQuery
Using the XML Data Type
Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes
Creating XML Indexes
Implementing Data Integrity by using Constraints
Data Integrity Overview
Implementing Constraints
Implementing Data Integrity by using Triggers and XML Schemas
Implementing Triggers
Implementing XML Schemas
Implementing Views
Introduction to Views
Creating and Managing Views
Optimizing Performance by using Views
Implementing Stored Procedures
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Working with Execution Plans
Handling Errors
Implementing Functions
Creating and Using Functions
Working with Functions
Controlling Execution Context
Implemeting Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
Managing Transactions and Locks
Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks
Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Using Notification Services
Introduction to Notification Services
Developing Notification Services Solutions
Maintaining a Microsoft SQL Server 2005 Database
Course Code: 2780
Course Duration: 35hrs / 5 days
Planning for Windows Server 2008 Deployment
Overview of Windows Server 2008 Deployment
Identifying Windows Server 2008 Compatibility Issues
Installing and Configuring SQL Server 2005
Preparing to Install SQL Server
Installing SQL Server 2005
Managing a SQL Server 2005 Installation
Managing Databases and Files
Planning Databases
Creating Databases
Managing Databases
Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Performing Online Restore Operations
Recovering Data from Database Snapshots
System Database and Disaster Recovery
Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Monitoring SQL Server
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services
Features of SQL Server Integration Services
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
Implementing Replication
Overview of Replication
Implementing Replication
Configuring Replication in Some Common Scenarios
Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Implementing Peer-to-Peer Replication
Designing Microsoft SQL 2005 Server Side Solutions
Course Code: 2781
Course Duration: 21hrs / 3 days
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
Designing a Security Strategy
Overview of Authentication Modes and Authorization 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
Designing a Data Modeling Strategy
Defining Standards for Storing XML Data in a Solution
Designing a Database Solution Schema
Designing a Scale-Out Strategy
Designing a Transaction Strategy for a SQL Server 2005 Solution
Defining Data Behavior Requirements
Defining Isolation Levels
Designing a Resilient Transaction Strategy
Designing a Notification Services Solution
Defining Event Data
Designing a Subscription Strategy
Designing a Notification Strategy
Designing a Notification Delivery Strategy
Designing a Service Broker Solution
Designing a Service Broker Solution Architecture
Designing Service Broker Data Flow
Designing Service Broker Solution Availability
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
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
Designing Microsoft SQL Server 2005 Databases
Course Code: 2782
Course Duration: 14hrs / 2 days
Approaching Database Design Systematically
Overview of Database Design
Gathering Database Requirements
Creating a Conceptual Database Design
Modeling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models
Modeling 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
Designing for Database Performance
Designing Indexes
Planning for Table Optimization
Planning for Database Optimization
Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures
Modeling Database Dependencies
Modeling Local Database Dependencies
Modeling Remote Database Dependencies
Designing the Data Tier for Microsoft SQL Server 2005
Course Code: 2783
Course Duration: 7hrs / 1 days
Choosing Data Access Technologies and an Object Model
Introduction to Data Access Technologies
Choosing Technologies for Accessing Data
Building a Data Access Layer
Designing Data Access from SQL Common Language Runtime (CLR) Objects
Available Data Object Models for Administering SQL Server
Designing an Exception Handling Strategy
Exception Types and Their Purposes
Detecting Exceptions
Managing Exceptions
Choosing a Cursor Strategy
Common Scenarios for Row-Based vs. Set-Based Operations
Selecting Appropriate Server-Side Cursors
Selecting Appropriate Client-Side Cursors
Designing Query Strategies Using Multiple Active Result Sets
Introduction to MARS
Designing Query Strategies for Multiple Reads
Designing Query Strategies for Mixing Reads and Writes in the Same Connection
Concurrency Considerations When Using MARS
Designing Caching Strategies for Database Applications
Why Caching Is Important
Data and Query Caching in SQL Server 2005
Using Caching Technologies Outside of SQL Server
Custom Caching Techniques
Designing a Scalable Data Tier for Database Applications
Identifying the Need to Scale
Scaling Database Applications to Avoid Concurrency Contention
Scaling SQL Server Database Systems
Scaling Database Applications Using a Service-Oriented Architecture
Improving Availability and Scalability by Scaling Out Front-End Systems
Tuning and Optimizing Queries using Microsoft SQL Server 2005
Course Code: 2784
Course Duration: 21hrs / 3 days
Measuring Database Performance
Importance of Benchmarking
Key Measures for Query Performance: Sysmon
Key Measures for Query Performance: Profiler
Guidelines for Identifying Locking and Blocking
Optimizing Physical Database Design
Performance Optimization Model
Schema Optimization Strategy: Keys
Schema Optimization Strategy: Responsible Denormalization
Schema Optimization Strategy: Generalization
Optimizing Queries for Performance
Performance Optimization Model: Queries
What Is Query Logical Flow
Considerations for Using Subqueries
Guidelines for Building Efficient Queries
Refactoring Cursors into Queries
Performance Optimization Model: Query-Set-based solutions
Five Steps to Building a Cursor
Strategies for Refactoring Cursors
Optimizing an Indexing Strategy
Performance Optimization Model: Indexes
Considerations for Using Indexes
Best Uses of the Clustered Index
Best Practices for Non-Clustered Index Design
How to Document an Indexing Strategy
Managing Concurrency
Performance Optimization Model: Locking and Blocking
Multimedia - "How to Use Efficient Queries to Reduce Locking and Blocking”
Strategies to Reduce Locking and Blocking
Pre-requisites
Trainees are required to have some experience in database and programming work, which may include 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.
Medium of Instruction
Instructor-Led Classroom Training
Course Location
NTUC Trade Union House
73 Bras Basah Road
#02-01
Singapore 158828
Methodology
Instructor - Led
Certification
Microsoft Certified IT Professional (MCITP): Database Developer
Funding Info
Please click here for more information
