Kursbeschreibung: MOC 2783B

Designing the Data Tier for SQL Server 2005 (1 Tag)

Lernziele:

• Choose data access technologies and an object model to support an organization's business needs.
• Design an exception handling strategy
• Choose a cursor strategy
• Design query strategies by using Multiple Active Result Sets (MARS)
• Design caching strategies for database applications
• Design a scalable data tier for database applications

Dauer:

1 Tag

Zielgruppe:

Professional database developers who are already proficient in using database technologies and applying them at a professional job role level. These database developers have experience using earlier versions of Microsoft SQL Server or other database technologies but have not worked with SQL Server 2005. Most audience members are expected to work for enterprise-level organizations consisting of at least 500 personal computers and 100 servers.

Voraus-setzungen:

• Experience reading user requirements and business-need documents - for example, project vision/mission statements or business analysis reports.
• Basic knowledge of the Microsoft .NET Framework, .NET concepts, Microsoft ADO.NET, and service-oriented architecture (SOA).
• Familiarity with the tasks that application developers typically perform.
• Understanding of Transact-SQL syntax and programming logic.
• Experience with professional-level database design - specifically, the ability to design a normalized database and know the tradeoffs involved in denormalization and designing for performance and business requirements.
• Basic monitoring and troubleshooting skills - specifically, how to use SQL Server Profiler and dynamic management views.
• Basic knowledge of the operating system and platform - that is, how the operating system integrates with the database, what the platform or operating system can do, and how interaction between the operating system and the database works.
• Basic knowledge of application architecture - that is, how applications can be designed based on SOA, what applications can do, how interaction between the application and the database works, and how the interaction between the database and the platform or operating system works.

Inhalte:

Session 1: Choosing Data Access Technologies and an Object Model

• Introduction to Data Access Technologies
• Choosing Technologies for Accessing Data
• Building a Data Access Layer
• Designing Data Access from SQLCLR Objects
• Available Data Object Models for Administering SQL Server

Session 2: Designing an Exception Handling Strategy

• Exception Types and Their Purposes
• Detecting Exceptions
• Managing Exceptions

Session 3: Choosing a Cursor Strategy

• Common Scenarios for Cursor-Based vs. Result Set–Based Operations
• Selecting Appropriate Server-Side Cursors
• Selecting Appropriate Client-Side Cursors

Session 4: Designing Query Strategies Using Multiple Active Result Sets

• Introduction to MARS
• Designing Query Strategies for Multiple Reads
• Designing Query Strategies for Mixing Reads and Writes in the Same Connection
• Concurrency Considerations When Using MARS

Session 5: Designing Caching Strategies for Database Applications

• Why Caching Is Important
• Data and Query Caching in SQL Server 2005
• Using Caching Technologies Outside of SQL Server
• Custom Caching Techniques

Session 6: Designing a Scalable Data Tier for Database Applications

• Identifying the Need to Scale
• Scaling Database Applications to Avoid Concurrency Contention
• Scaling SQL Server Database Systems
• Scaling Database Applications Using Service-Oriented Architecture
• Improving Availability and Scalability by Scaling Out Front-End Systems

Dieser Kurs ist als "Clinic" konzipiert, d.h., die praktischen Teile werden als Demo vorgeführt. Auf Wunsch kann der Kurs auch als zweitägiges Seminar mit Labs durchgeführt werden.
Wir beraten Sie gerne!

Die Schulungsunterlage ist nur auf Englisch verfügbar!