MSEL Collection Info

Collection 2781: Designing Microsoft® SQL Server™ 2005 Server-Side Solutions

These eight courses (16 hours) will teach database developers working in enterprise environments to design server-side database solutions that utilize SQL Server 2005 services. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.

Topics covered within the collection:
Database Services Strategy
Security Strategy
Data Model Strategy
Transaction Strategy
Notification Services
Service Broker
Source Control, Unit Testing and Deployment
Advanced Query Techniques

These courses will also prepare for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.

Cursos contenidos en esta colección:

- Course 3175: Selecting MS SQL Server 2005 Services to Support Business Needs

In this 2 hour course you will learn how to select the right SQL Server service for a particular business requirement.

You will also learn how to evaluate the considerations for using database enhancements in SQL Server 2005. This knowledge will allow you to choose the best mix of server solutions and the associated coding strategies.

This course will also help prepare you for certification exam 70-441.

Ver contenidos del curso

- Course 3176: Designing a Security Strategy for a MS SQL Server 2005 Database Solution

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.

Ver contenidos del curso

- Course 3177: Designing a Data Model Strategy for a MS SQL Server 2005 Solution

In this 2 hour course you will learn how to ensure that company information databases are well designed.

By having a well-defined data modeling strategy, you will provide a platform that is flexible enough to accommodate current and projected business needs.

This course will also help prepare you for certification exam 70-441.

Ver contenidos del curso

- Course 3178: Designing a Transaction Strategy for a MS SQL Server 2005 Solution

In this 2 hour course you will learn how to design a transaction strategy that provides higher transaction rates while maintaining a high level of performance and a low response time.

You will also learn how the design will address production issues such as excessive locking, blocking, deadlocking, performance, and scalability.

This course will also help prepare you for certification exam 70-441.

Ver contenidos del curso

- Course 3179: Designing a Notification Services Solution Using MS SQL Server 2005 Notification Services

In this 2-hour premium course, you will learn how to incorporate Notification Services into your SQL Server 2005 Database solutions. Topics range from defining event data to designing subscription and notification strategy. In the lab, you will use these skills to build a Notifcation Services solutions.

Having this experience will enable you to design scaleable notification-based systems that support a wide range of devices.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3180: Designing Asynchronous, Queued Operations Using MS SQL Server 2005 Service Broker

In this 2-hour premium course, you will 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, you will use these skills to build a SQL Server 2005 Service Broker solution.

Having this experience will enable you to design databases that utilize the integrated messaging system to perform asynchronous processing.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3181: Planning for Source Control, Unit Testing, and Deployment Using MS SQL Server 2005

In this 2-hour premium course, you will learn various strategies that you can use 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, you will apply these strategies.

Using these techniques will allow you to provide a more stable environment for developing and deploying your database applications.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3182: Applying Advanced Query Techniques in MS SQL Server 2005

In this 2-hour premium course, you will learn how to harness advanced query capabilities within your SQL Server 2005 Database solutions. Topics range from CTEs and Pivot Queries to working with XML Data. In the lab, you will write different kinds of queries and evaluate their execution plans.

Using these advanced query techniques will enable you to build more scaleable and responsive databases.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.

Ver contenidos del curso