Actualidad | Newsletter | Centros | Contacto | Nosotros | Site Map | Home
Informática y telecomunicaciones
Moc 2783 - Designing the Data Tier for Microsoft SQL Server 2005
Tipo : Curso
Precio :
Duración :
Idioma: Español
Pais: España
Provincia: Álava
Modalidad: Presencial
Centro : New Horizons Barcelona

Ver temario


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


SOLICITUD DE INFORMACIÓN
Moc 2783 - Designing the Data Tier for Microsoft SQL Server 2005
Para recibir personalmente más información sobre este curso, rellena el formulario con tus datos.
Formulario :
* Campos obligatorios
  *Nombre   *Apellidos
  *E-mail   *Teléfono

 *¿Eres mayor de 16 años?   Si        No
  *País de residencia
 * Provincia
  Dirección
  Tipo vía     Piso
  Localidad   C.P.  

He leído y acepto los términos y condiciones y la política de privacidad.
Registrándote en Estucurso aceptas recibir información de Estucurso y empresas asociadas sobre productos y servicios que seleccionaremos según tus intereses y la información que proporciones a la página web de Estucurso. Tienes la posibilidad de darte de baja de estos servicios en cualquier momento.


Temario

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


Curso Centro
Tipo
Búsqueda avanzada

estucurso.com
© Grupo Antevenio