Otra Información:
This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment. Se dispone de un ordenador por alumno. El curso tiene una duración de 6 horas (consultar los horarios disponibles en el calendario de New Horizons). El nº de plazas es limitado. www.nhbarcelona.com

Descripción :This course provides students with the knowledge and skills to design the data tier for Microsoft SQL ServerT 2005. The course focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today. After completing this course, students will be able to: 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 using Multiple Active Result Sets (MARS). Design caching strategies for database applications. Design a scalable data tier for database applications. www.nhbarcelona.com

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 SQL Common Language Runtime (CLR) Objects Available Data Object Models for Administering SQL Server Designing an Exception Handling Strategy Exception Types and Their Purposes Detecting Exceptions Managing Exceptions Choosing a Cursor Strategy Common Scenarios for Row-Based vs. Set-Based Operations Selecting Appropriate Server-Side Cursors Selecting Appropriate Client-Side Cursors 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 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 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 a Service-Oriented Architecture Improving Availability and Scalability by Scaling Out Front-End Systems www.nhbarcelona.com