What do you want to learn today?

Performance Tuning and Optimizing SQL Databases (SQL Server 2017)

ENDED
Training by  NetCom Learning
Inquire Now
On-Site / Training

Details

This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

This course is based on the objectives of the course version 10987C.

Outline

      1. SQL Server Architecture, Scheduling, and Waits
        1. SQL Server Components and SQL OS
        2. Windows Scheduling vs SQL Scheduling
        3. Waits and Queues
        4. Lab : SQL Server Architecture, Scheduling, and Waits
      2. SQL Server I/O
        1. Core Concepts
        2. Storage Solutions
        3. I/O Setup and Testing
        4. Lab : Testing Storage Performance
      3. Database Structures
        1. Database Structure Internals
        2. Data File Internals
        3. TempDB Internals
        4. Lab : Database Structures
      4. SQL Server Memory
        1. Windows Memory
        2. SQL Server Memory
        3. In-Memory OLTP
        4. Lab : SQL Server Memory
      5. SQL Server Concurrency
        1. Concurrency and Transactions
        2. Locking Internals
        3. Lab : SQL Server Concurrency
      6. Statistics and Index Internals
        1. Statistics Internals and Cardinality Estimation
        2. Index Internals
        3. Columnstore Indexes
        4. Lab : Statistics and index Internals
      7. Query Execution and Query Plan Analysis
        1. Query execution and optimizer internals
        2. Query execution plans
        3. Analyzing query execution plans
        4. Lab : Query execution and query plan analysis
      8. Plan Caching and Recompilation
        1. Plan cache internals
        2. Troubleshooting plan cache issues
        3. Query store
        4. Lab : Plan caching and recompilation
      9. Extended Events
        1. Extended events core concepts
        2. Working with extended events
        3. Lab : Extended events
      10. Monitoring, Tracing, and Baselining
        1. Monitoring and tracing
        2. Baselining and benchmarking
        3. Lab : Monitoring, Tracing and Baselining

Special Offer

For special offers, visit https://www.netcomlearning.com/
Reviews
Be the first to write a review about this course.
Write a Review

NetCom Learning helps build innovative learning organizations in the workplace by structuring a smarter workforce, supporting learning changes, and driving learning growth. Since 1998 we have been empowering organizations to reach optimal performance results and address challenges by managing all aspects of organizational learning.

With a team of dedicated and knowledgeable learning professionals having deep subject-matter expertise, NetCom Learning has serviced over 80% of Fortune 100 companies. We've helped over 10,000 organizations achieve their business goals by offering a full complement of Managed Learning Services, including IT and business training, curriculum design and content development, learning delivery and administration, consulting and advisory services, and management of learning technology.

NetCom Learning is honored to be recognized as Microsoft's Worldwide Training Partner of the Year by Microsoft and as a Top 20 IT Training Company by TrainingIndustry.com for three years. We offer over 1,500 courses available to organizations around the world, encompassing all your technology and business training needs. From authorized or foundational training to specialized certifications, we empower organizations to achieve a competitive advantage. In addition, we provide customers with a choice of customized private programs, convenient scheduling options, flexible delivery formats, and continuous learning support, all tailored towards minimizing the skills gap and gaining maximum business impact for your organization. ...

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.