Course 4355: Designing a Scalable Data Tier for Microsoft SQL Server 2005 Database Applications

Introduction In this 1-hour premium course, you will learn about how to design a scaleable database solution in Microsoft® SQL Server™ 2005. Topics covered include scaling at the Database, Middle-Tier and at the front end.

Having this experience will enable you to design database applications that will scale as load increases.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005. Objectives At the end of the course, students will be able to:

• Identify capacity planning strategies
  • Scale Multi-Layer Systems
  • Perform capacity planning
  • Improve Scalability
  • Monitor data access
  • Prevent data access bottlenecks
• Minimize concurrency contention
  • Avoid Concurrency Contention
  • Improve concurrency with database snapshots
  • Improve concurrency through denormalization
• Distribute data
  • Distribute data and requests
  • Use Log Shipping
  • Use Replication
  • Use Data Partitioning
  • Use well-defined Interfaces
• Scale Multi-Tier Database Applications
  • Create middle-tier strategies
  • Use COM+ to build a data access layer
  • Use web services
  • Use HTTP Endpoints
• Scale Out Front-End Systems
  • Improve applicaton availability and Scalability
  • Scale Out web front-end systems
  • Implement data access in web forms

Modules & Lessons Course Overview Module Introduction Navigation Overview Designing a Scalable Data Tier for Database Applications Module Introduction Designing a Scalable System Lesson Introduction Identifying Capacity Planning Strategies Considerations to Scale Multi-Layer Systems The Process of Capacity Planning Considerations to Improve the Scalability of a Database System Monitoring Data Access Guidelines to Prevent Data Access from Becoming a Bottleneck Self Test Minimizing Concurrency Contention Lesson Introduction Concurrency Contention Techniques to Avoid Concurrency Contention Guidelines to Improve Concurrency by Using Database Snapshots Denormalizing Databases to Improve Concurrency Guidelines to Denormalize a Database Self Test Distributing Data in SQL Server Database Systems Lesson Introduction Identifying Methods to Distribute Data and Requests Guidelines to Scale Out by Using Log Shipping Guidelines to Scale Out by Using Replication How Data Partitioning Works Considerations to Implement Data Partitioning to Scale Database Systems Considerations to Implement Well-Defined Interfaces for Distributed Database Systems Self Test Scaling Multi-Tier Database Applications Lesson Introduction Creating Middle-Tier Strategies to Connect to SQL Server Building a Data Access Layer That Is Based on COM+ Components Guidelines to Build Web Services to Provide Data Access Guidelines to Build HTTP Endpoints to Scale Up Data Access to SQL Server 2005 Self Test Scaling Out Front-End Systems Lesson Introduction Considerations to Scale Out Front-End Systems Considerations to Improve Availability and Scalability of Windows-Based Applications Guidelines to Scale Out Web Front-End Systems Guidelines to Implement Data Access in Web Farms Self Test Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled