Course 4355: Designing a Scalable Data Tier for Microsoft SQL Server 2005 Database Applications
Description
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 c…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
- 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.
- Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
- Microsoft Internet Explorer 6.0 or higher
- Window-Eyes from GW Micro
- JAWS from Freedom Scientific
- MSAA enabled
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.