This section of the course covers more advanced SQL topics, such as database design strategies, how to leverage diagrams to model relationships, and an analysis of SQL indexing.

This guide walks through: what database indexes are, how they are used to improve performance, and when they should be used when managing a SQL database.

This guide walks through a poorly constructed database and explains how to implement database normalization techniques in order to ensure the database structure has limited duplication and data integrity issues.

This guide provides an introduction to EER diagrams and how you can utilize them to model a database schema. Additionally, we'll examine how to generate the EER diagram by reverse engineering a database.