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
-
1m 50s
-
6m 36s
-
3. Database Design Optimization9m 17s
-
4. Data Structure Optimization7m 28s
-
5. Database Query Performance Considerations9m 27s
-
6. Data Storage Optimization6m 37s
-
7. SQL Query Optimization10m 2s
-
8. Performance Tuning Techniques and Best Practices9m 27s
-
9. Optimizing Tables Using Indexes11m 9s
-
10. Database Optimization Tools3m 49s
-
11. Optimizing Database Performance5m 57s
-
12. Application Database Performance4m 54s
-
13. Course Summary41s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
Rating 4.6 of 25 users
(25)
