Performance Engineering: Optimizing Database Performance

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.