◈IRAQI.FITDATABASE OS / ACADEMY
MODULE 05 / LESSON 20● READY TO LEARN

Indexes

Hands-on tutorial

01 / THE CONCEPT

Understand the idea

In this lesson, explore indexes. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

02 / SQL EXAMPLE
◉ example.sqlSQL
CREATE INDEX idx_students_city ON students(city);
Try in SQL Lab ↗
03 / KNOWLEDGE CHECK

Check your understanding

Which statement best describes indexes?

◈

Enjoying the lesson?

Create a free account to take the quiz and save your progress.

Create account ↗