Optimize query performance in Azure SQL

*Looking for a flexible schedule (after hours or weekends)? Please call or email us: 858-208-4141 o sales@ccslearningacademy.com.


Opciones de financiación para estudiantes están disponibles.
¿Buscas formación en grupo? Contáctenos
CategorĂ­a:

Descargar PDF de detalles del curso

DescripciĂłn del curso:

Analyze individual query performance and determine where improvements can be made. Explore performance-related Dynamic Management Objects. Investigate how indexes and database design affect queries.

This Course helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions.

Formato

Dirigido por un instructor

Tema

Proveedor

microsoft

Longitud

Temas del curso

Module 1: Explore query performance optimization

Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated. Understand the purpose and benefits of the Query Store.

  • IntroducciĂłn
  • Understand query plans
  • Explain estimated and actual query plans
  • Describe dynamic management views and functions
  • Explore Query Store
  • Identify problematic query plans
  • Describe blocking and locking
  • Exercise: Identify and resolve blocking issues

Module 2: Explore performance-based design

Explore normalization for relational databases. Investigate the impact of proper datatype usage. Compare types of indexes.

  • IntroducciĂłn
  • Describe normalization
  • Choose appropriate data types
  • Design indexes
  • Exercise: Identify database design issues

Module 3: Evaluate performance improvements

Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore Query Store hints.

  • IntroducciĂłn
  • Describe wait statistics
  • Tune and maintain indexes
  • Understand query hints
  • Exercise: Isolate problem areas in poorly performing queries

PĂşblico objetivo

The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure

Requisitos previos

  • Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based
  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
  • Basic understanding of structure and usage of SQL Server indexes
  • Basic understanding of relational database concepts

Inclusiones

Con CCS Learning Academy, recibirás:

  • 1 dĂ­a de capacitaciĂłn dirigida por un instructor certificado
  • Manual del Estudiante del Seminario Oficial de CapacitaciĂłn
  • ColaboraciĂłn con compañeros de clase (actualmente no disponible para cursos a su propio ritmo)
  • Escenarios y actividades de aprendizaje del mundo real.
  • Soporte para la programaciĂłn de exámenes*
  • Disfrute de asistencia para la colocaciĂłn laboral durante los primeros 12 meses despuĂ©s de finalizar el curso.
  • Este curso es elegible para el programa Learn and Earn de CCS Learning Academy: obtenga un reembolso de la matrĂ­cula de hasta 50% si se le coloca en un trabajo a travĂ©s de CCS Global Tech. DivisiĂłn de colocaciĂłn*
  • Precios gubernamentales y privados disponibles.*

*Para más detalles llame al: 858-208-4141 o correo electrónico: formación@ccslearningacademy.com; ventas@ccslearningacademy.com

Carro de la compra
es_CRSpanish