 |
GET IN THE LEAD - get certified today!
Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back!
Read why successful professionals choose QuickCert > |
The Microsoft MCITP Database Developer Training Package from QuickCert include 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.
QuickCert's MCITP Database Developer Training Package includes the following exams:
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 2005.
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 QuickCert's comprehensive MCITP: Database Developer training courses will provide you with all the tools necessary to successfully prepare for your MCITP: Database Developer certification. We guarantee it!
Click on one of the tabs above to learn more about our course curriculum or QuickCert product features, or to learn more about a specific exam, click on a course number below.
Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.
MCITP: Database Developer Certification Training Course: Microsoft Certified IT Professional Curriculum
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
Optimizing 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
Optimizing Performance by Using Views
Module-7 Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterized 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 Backup 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
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 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
Module 3: Designing a Data Modeling 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 Behavior 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: Modeling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models
Module 3: 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
Module 4: Designing for Database Performance
Designing Indexes
Planning for Table Optimization
Planning for Database Optimization
Module 5: Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures
Module 6: Modeling Database Dependencies
Modeling Local Database Dependencies
Modeling Remote Database Dependencies
Exam 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 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
Module 3: Designing a Data Modeling 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 Behavior 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
Designing the Data Tier for a Microsoft SQL Server 2005
Module-1 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
Module-2 Designing an Exception Handling Strategy
Exception Types and Their Purposes
Detecting Exceptions
Managing Exceptions
Module 3: Choosing a Cursor Strategy
Common Scenarios for Row-Based vs. Set-Based Operations
Selecting Appropriate Server-Side Cursors
Selecting Appropriate Client-Side Cursors
Module 4: 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
Module 5: 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
Module 6: 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
Module 1: Measuring Database Performance
Importance of Benchmarking
Key Measures for Query Performance: Sysmon
Key Measures for Query Performance: Profiler
Guidelines for Identifying Locking and Blocking
Module 2: Optimizing Physical Database Design
Performance Optimization Model
Schema Optimization Strategy: Keys
Schema Optimization Strategy: Responsible Denormalization
Schema Optimization Strategy: Generalization
Module 3: Optimizing Queries for Performance
Performance Optimization Model: Queries
What Is Query Logical Flow?
Considerations for Using Subqueries
Module 4: Refactoring Cursors into Queries
Performance Optimization Model: Query-Set-based solutions
Five Steps to Building a Cursor
Strategies for Refactoring Cursors
Module 5: 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
Module 6: 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
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
