Performance Engineering: Optimizing Database Performance

Performance Engineering    |    Intermediate
  • 13 Videos | 1h 27m 12s
  • Includes Assessment
  • Earns a Badge
Most software solutions are backed by a database, meaning the overall application performance is greatly affected by the database's performance. It's therefore highly advantageous for software professionals to know how to analyze and optimize database performance. Take this comprehensive course to learn about the many facets of database performance optimization. Discover how to optimize data structures and examine the data definition language (DDL) used to manage that structure. Find out how to optimize data storage within a database as well as SQL queries that act on that data. Study performance tuning techniques. Practice optimizing a SQL table using indexes. And explore several optimization tools. Next, examine several strategies for optimizing database performance. Then see how to troubleshoot slow database symptoms in the context of an application. Upon completion, you'll know how to optimize database performance in isolation and as part of an application.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    summarize what's meant by database performance optimization, briefly noting the three domains: database structure (DDL), data, and SQL
    outline the basic elements of optimizing a database design, including the use of keys and indexes
    describe the ways you can optimize data definition language (DDL) queries and data structure, noting how database optimizers tend to ignore DDL statements, using MySQL as an example, and relating back to the primary factors of database performance
    list factors that can affect the performance of your queries, using MySQL as an example, and relating back to the primary factors of database performance
    describe the ways you can optimize data storage, using MySQL as an example, relating back to the primary factors of database performance
    outline how to optimize SQL commands, using MySQL as an example, noting the role of the query optimizer, relating back to the primary factors of database performance
  • detail techniques and best practices for performance tuning
    optimize a MySQL table using indexes
    compare database optimization tools from several vendors
    list strategies for optimizing database performance
    describe database performance as part of an application, focusing on code best practices and determining the root cause of slow downs
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 50s
    UP NEXT
  • Playable
    2. 
    Database Performance Optimization
    6m 36s
  • Locked
    3. 
    Database Design Optimization
    9m 17s
  • Locked
    4. 
    Data Structure Optimization
    7m 28s
  • Locked
    5. 
    Database Query Performance Considerations
    9m 27s
  • Locked
    6. 
    Data Storage Optimization
    6m 37s
  • Locked
    7. 
    SQL Query Optimization
    10m 2s
  • Locked
    8. 
    Performance Tuning Techniques and Best Practices
    9m 27s
  • Locked
    9. 
    Optimizing Tables Using Indexes
    11m 9s
  • Locked
    10. 
    Database Optimization Tools
    3m 49s
  • Locked
    11. 
    Optimizing Database Performance
    5m 57s
  • Locked
    12. 
    Application Database Performance
    4m 54s
  • Locked
    13. 
    Course Summary
    41s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.