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.
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
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