Performance Engineering: Optimizing Database Performance

Most software solutions are backed by a database meaning the overall application performance is greatly affected by the databases performance. 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 youll know how to optimize database performance in isolation and as part of an application.