Microsoft Certified IT Professional (MCITP): Database Developer
Certification Training
Overview
This globally recognised credential validates your skills in designing secure, stable enterprise database solutions using Microsoft SQL Server 2005 - and is the premier certification for database designers and developers.
SEEK Learning will provide you with all the training you need to pass the MCITP exams 70-431, 70-441 and 70-442 and get certified.
|
Who is this course for?
- Database developers
- Database administrators
- Business intelligence developers
- Anyone who wants to work with Microsoft SQL Server 2005
|
|
Quick Course Guide
|
|
Qualification
|
MCITP: Database Developer
|
Student support
|
24x7 access to a comprehensive reference library
|
|
Study time
|
18 weeks
|
Pre-requisites
|
MCTS: SQL Server 2005. Package deal available.
|
|
Enrolment dates
|
Enrol anytime - start now!
|
Assessment
|
MCITP exams 70-431, 70-441 & 70-442 (by external provider)
|
|
Delivered by
|
SkillSoft
|
Resources required
|
Internet, email
|
Stand Out with Certified Database Development Skills
Typically employed by medium- to large-sized organisations, database developers design and implement relational database models and database storage objects. They also program servers, retrieve or modify data, and optimise queries.
With employment for database developers expected to be strong over the next few years,* now's a great time to gain - and become certified for - database development skills.
The widely recognised MCITP: Database Developer credential proves your expertise in designing enterprise database solutions - and can help boost your career prospects.
Skills You'll Gain
|
Among other things, you'll gain the skills to: - Install and configure SQL Server 2005
- Support data consumers
- Maintain databases
- Monitor and troubleshoot SQL Server performance
- Design a database and database objects
- Develop applications that use SQL Server support services
- Write and modify queries
- Design error-handling routines
- Design transaction strategies
- Optimise data storage
|
|
Pre-requisite Package Deal
MCTS: SQL Server 2005 certification is a pre-requisite for this MCITP course. If you do not already have your MCTS SQL Server 2005 certification, you can do both the MCTS and MCITP courses for a discounted package price.
Contact a SEEK Learning consultant now for more information about this package, including discounts.
MCITP: Database Developer Course Details
Course Outline
|
70-431
|
- Installing SQL Server 2005
- Configuring SQL Server 2005
- Creating and Implementing Database Objects in SQL Server 2005
- Retrieving Data and Running Queries in SQL Server 2005
- SQL Server 2005 Messaging and Querying Tools
|
- Managing and Maintaining SQL Server 2005 Databases
- SQL Server 2005 Database Performance and Optimization
- Monitoring and Diagnosing Database Problems in SQL Server 2005
- SQL Server 2005 High Availability and Disaster Recovery
- SQL Server 2005 Backup and Restores
|
|
|
70-441
|
- Designing an application solution for SQL server 2005
- Designing database objects
- Programming with SQL server 2005
- Using XML
- CLR integration
|
- Database testing and code management
- Developing applications that use SQL server business intelligence services
- Developing applications that use SQL server support services
- Database deployment and data distribution
|
|
|
70-442
|
- Designing access to SQL server data
- Designing efficient application access
- Designing queries in SQL 2005
- Designing a SQL server 2005 cursor strategy
- Designing a SQL server 2005 transaction strategy
|
- SQL server 2005 error handling techniques
- Optimizing query performance and index strategies
- Optimizing storage in SQL server 2005
- Scaling applications and resolving performance issues
|
|
SEEK Learning's MCITP certification training will fully prepare you for the MCITP: Database Developer exams (70-431, 70-441 and 70-442).
Please note that the MCITP exams are held by an external provider. For your convenience, SEEK Learning will help you find your nearest exam centre. Contact a SEEK Learning consultant for further information or assistance.