MCITP Database Developer Certification Course
- Price: US$ 799.00
- Publisher: Element K
- Number of modules: 26
- Length: 52 hours
- Language: English
- Subscription: 12 months
Join the Community of 4,000 Certified Microsoft Database Developers. Study Online and Practice on Live Software in our Virtual Lab
These online certification courses are the premier online training courses for MCITP Database Administrator candidates. They are Official Microsoft Learning Products published by ElementK.
Use this online course to Prepare for the following Microsoft exams:
- 70-441
- 70-442
This MCITP certification course contains the 19 virtual labs:
1. Beginning the Database Design Process
2. Designing a Data Modeling Strategy
3. Designing a Database Access Strategy
4. Designing a Notification Services Solution
5. Designing a Security Strategy
6. Designing a Service Broker Solution
7. Designing a Transaction Strategy for a SQL Server Solution
8. Designing for Database Scalability
9. Evaluating Advanced Query and XML Techniques
10. Managing Concurrency
11. Measuring Database Performance
12. Modeling a Database at the Logical Level
13. Modeling a Database at the Physical Level
14. Modeling Database Dependencies
15. Optimizing a Schema
16. Optimizing an Indexing Strategy
17. Optimizing Queries
18. Planning for Source Control, Unit Testing, and Deployment
19. Refactoring Cursors into Queries
MCITP Database Developer Certification Course Details
| Module Name |
Description |
| Applying Advanced Query Techniques in Microsoft SQL Server 2005 (3182) | Learn how to harness advanced query capabilities within SQL Server 2005 Database solutions. Topics range from CTEs and Pivot Queries to working with XML Data. The lab will demonstrate how to write different kinds of queries and evaluate their execution plans. Using these advanced query techniques will enable user to build more scalable and responsive databases. |
| Approaching Database Design Systematically Using Microsoft SQL Server 2005 (3300) | Learn how to take a systematic approach to database design. Topics range from design steps, and requirements gathering to creating a conceptual design. The lab will show how to gather requirements and model a database.
Using these design principles, design databases in a consistent, manageable fashion. |
| Choosing a Cursor Strategy for Microsoft SQL Server 2005 (4352) | Learn about how to design a cursor strategy within Microsoft SQL Server 2005 Database solutions. Topics covered include client-side and server-side cursors as well as best practices and pros and cons of each type.
It will show how to design databases that correctly meet the data retrieval and processing needs of organizations applications. |
| Choosing Data Access Technologies and an Object Model for Microsoft SQL Server 2005 (4350) | Learn about the various data access technologies available for retrieving data and working with Microsoft SQL Server 2005. Topics within the course range from choosing between the different data access methods, building a data access layer, and working with Microsoft SQL Server programmatically.
It teaches how to determine the appropriate data access technologies to access and consume data for application developers. |
| Designing a Data Model Strategy for a Microsoft SQL Server 2005 Solution (3177) | Learn how to ensure that company information databases are well designed. By having a well-defined data modeling strategy, it will explain a platform that is flexible enough to accommodate current and projected business needs. |
| Designing a Database Access Strategy with Microsoft SQL Server 2005 (3304) | Learn how to address data retrieval requirements through stored procedures, user defined functions and security context. Then design a database to which these concepts will be applied. |
| Designing a Notification Services Solution Using SQL Server 2005 Notification Services (3179) | Learn how to incorporate Notification Services into SQL Server 2005 Database solutions. Topics range from defining event data to designing subscription and notification strategy. Then build a Notification Services solutions.
It enables one to design scalable notification-based systems that support a wide range of devices. |
| Designing a Scalable Data Tier for Microsoft SQL Server 2005 Database Applications (4355) | Learn about how to design a scalable database solution in Microsoft SQL Server 2005. Topics covered include scaling at the Database, Middle-Tier and at the front end.
It will enable one to design database applications that will scale as load increases. |
| Designing a Security Strategy for a Microsoft SQL Server 2005 Database Solution (3176) | In this 2 hour course you will learn how to plan for security during the design phase including designing a security strategy for the various components of a SQL Server 2005 solution. You will also learn how to choose an authentication and authorization strategy, design security for various solution components, design objects, and create an auditing strategy for your solution. This course will also help prepare you for certification exam 70-441. |
| Designing a Transaction Strategy for a Microsoft SQL Server 2005 Solution (3178) | Learn how to design a transaction strategy that provides higher transaction rates while maintaining a high level of performance and a low response time. Will also learn how the design will address production issues such as excessive locking, blocking, deadlocking, performance, and scalability. |
| Designing an Exception Handling Strategy for Microsoft SQL Server 2005 (4351) | Learn about how to design an exception handling strategy within SQL Server 2005 Database solutions. Topics covered include defining, handling and detecting exceptions.
It will enable one to design databases which notify applications of unexpected events that occur on the server so that they can be properly handled. |
| Designing Asynchronous, Queued Operations Using SQL Server 2005 Service Broker (3180) | Learn how to incorporate Service Broker into your SQL Server 2005 Database solutions. Topics range from discussing Service Broker architecture to data flow and availability. In the lab, use these skills to build a SQL Server 2005 Service Broker solution.
This will enable one to design databases that utilize the integrated messaging system to perform asynchronous processing. |
| Designing Caching Strategies for Microsoft SQL Server 2005 Database Applications (4354) | Learn about designing a caching strategy within Microsoft SQL Server 2005 Database solutions. Topics covered include server-side and client-side caching techniques as well as conflict resolution and query notifications.
It will enable the design of reliable database applications that can perform well under heavy load. |
| Designing for Database Performance with Microsoft SQL Server 2005 (3303) |
Learn how to optimize databases through the use of indexes, table optimizations and database optimizations. In the lab, design a database using these optimizations.
|
| Designing Query Strategies Using Multiple Active Result Sets in Microsoft SQL Server 2005 (4353) | Learn about how to design queries for SQL Server 2005 that take advantage of Multiple Active Result Sets (MARS). Topics include types of queries supported by MARS, as well as concurrency considerations.
It enables one to design database applications that efficiently use database server resources. |
| Managing Concurrency Using Microsoft SQL Server 2005 (4375) |
Learn how to apply a locking strategy to Microsoft SQL Server 2005 Database solutions. Topics include transaction isolation levels and effective techniques to reduce locking and blocking. Within the workshop, Then analyze database locking and blocking issues and apply techniques to reduce concurrency issues. As a workshop, most of the learning will be done within the lab itself. It will enable one to address bottlenecks that occur in multi-user databases due to locking. |
| Measuring Database Performance Using Microsoft SQL Server 2005 (4370) | Learn about monitoring performance in your Microsoft SQL Server 2005 Database solutions. Topics include performance monitoring and tools, as well as the causes of locking and blocking. In the lab, analyze tables and SQL scripts and use SQL scripts to simulate user activity for capturing baseline and concurrency performance. Also, learn how to prioritize discovered bottlenecks and improvements to the database. As a workshop, most of the learning will be done within the lab itself. It will enable one to address performance issues that arise within deployed database solutions. |
| Modeling a Database at the Logical Level with Microsoft SQL Server 2005 (3301) | Learn how to logically model a database. Topics range from working with Primary, Natural and Surrogate Keys to designing for OLTP and Data Warehousing.
It allows one to design databases that are optimized for an organization's data retrieval and update needs. |
| Modeling a Database at the Physical Level with Microsoft SQL Server 2005 (3302) | Learn how to physically model a database. Topics range from designing database objects, and constraints, to security and server options. In the lab you will model a database at the physical level.
It allows one to design databases that are optimized according to organization's operational needs. |
| Modeling Database Dependencies with Microsoft SQL Server 2005 (3305) | Learn how to handle local and remote dependencies within database design. In the lab, configure cross-database access and linked servers.
It helps to design databases that can access both local and remote resources. |
| Optimizing an Indexing Strategy Using Microsoft SQL Server 2005 (4374) | Learn how to apply various indexing strategies in order to enhance performance in Microsoft SQL Server 2005 Database solutions. Topics include index types, guidelines for designing indexes, and using clustered vs. nonclustered indexes. Within the workshop, analyze bottlenecks and apply indexes to various tables in order to improve performance. As a workshop, most of the learning will be done within the lab itself.
It helps to address performance issues that arise from poorly performing queries within your database solutions. |
| Optimizing Physical Database Design Using Microsoft SQL Server 2005 (4371) | Learn about how to optimize schema design to meet the performance requirements of Microsoft SQL Server 2005 database solutions. In the lab, optimize various schema objects, as well as measure the performance after the objects have been optimized. As a workshop, most of the learning will be done within the lab itself.
Prevent performance issues form occurring, as well as address issues that arise during deployed database solutions. |
| Optimizing Queries for Performance Using Microsoft SQL Server 2005 (4372) | Optimize database queries to enhance performance in Microsoft SQL Server 2005 Database solutions. Topics include the importance of query optimization, the role of the query optimizer, and the guidelines for building efficient queries. In the lab, one will optimize stored procedures and views, as well as measure the performance after these databases have been optimized. As a workshop, most of the learning will be done within the lab itself.
Address performance issues that arise from poorly performing queries within database solutions. |
| Planning for Source Control, Unit Testing, and Deployment Using SQL Server 2005 (3181) | Learn various strategies that can be used to keep a manageable database environment during development. Topics range from incorporating source control and unit testing to performance baselining and deployment. In the lab, one will apply these strategies.
Provide a more stable environment for developing and deploying database applications. |
| Refactoring Cursors into Queries Using Microsoft SQL Server 2005 (4373) | Learn how to refactor row-cursor based operations into queries in order to enhance performance in your Microsoft SQL Server 2005 Database solutions. The workshop shows several different methods for refactoring, as well as guidelines for when to use cursors. The lab will refactor several different types of cursors into queries. As a workshop, most of the learning will be done within the lab itself.
It allows one to address performance issues that arise from poorly performing queries within your database solutions. |
| Selecting Microsoft SQL Server 2005 Services to Support Business Needs (3175) | Learn how to select the right SQL Server service for a particular business requirement. Then learn how to evaluate the considerations for using database enhancements in SQL Server 2005.
It helps to choose the best mix of server solutions and the associated coding strategies. |
