Optimize Your Database with Indexes

About this course

In this 1 hour guided project, you will learn about what database indexes are and how they optimize certain database operations. By the end of this guided project, you will be able to profile database operations and design appropriate indexes to improve the performance of your relational database. Basic SQL required as a prerequisite (for example, perform multi-column selection with multiple criteria).

What you will learn

• Learn the principles of database indexes
• Learn how to design and manage database indexes
• Learn how to measure performance of SQL and indexes