• Online, Self-Paced
Course Description

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.

Learning Objectives

{"discover the key concepts covered in this course"}

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Software Development