Understanding Indexes

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Great job! Now you know how to create indexes.

Now you'll learn when to create them.

Next exercise

13/13 Congratulations

1. Welcome

2. Creating single-column indexes

3. Creating indexes on VARCHAR columns

4. Indexes on VARCHAR columns – explanation

5. Creating multi-column indexes

6. Multi-column indexes – explanation

7. ASC and DESC keywords in indexes

8. ASC and DESC keywords in indexes – example

9. NULLS FIRST and NULLS LAST

Perfect! That was the last exercise in this part. Congratulations!

In the next part, we'll explain when we should create indexes ourselves and when they are created for us automatically by the database. See you soon!

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Great job!

Instruction

Exercise

Need assistance?