SQL and MySQL course Β· Module 11: Capstone project

Journey's end - Master of the Catalog

2 min read Β·
In this lesson3

It is done. You have reached the very summit of the Great Library of Alexandria. Look down at the road you have travelled.

Your journey through the Library

  • The Gate - you learned about databases, tables, rows and columns, and your first SELECT.
  • The Catalog Hall - you filtered (WHERE), sorted (ORDER BY) and limited results (LIMIT).
  • The Table Workshop - you created tables (CREATE TABLE) and added data (INSERT).
  • The Scriptorium - you changed and deleted data (UPDATE, DELETE).
  • The Great Halls - you linked shelves with joins (JOIN).
  • The Sages' Abacus - you grouped and counted (GROUP BY, aggregate functions).
  • The Chamber of Riddles - you delved into subqueries and HAVING.
  • The Vault of Speed - you sped up queries with indexes.
  • The Hall of Seals - you protected data with transactions and ordered it with views.

What's next, Master?

The Library never stops growing. If you wish to go further, here are your next scrolls:

  • Stored procedures - whole programs living inside the database.
  • Triggers (TRIGGER) - actions run automatically when data changes.
  • Normalization - the art of designing tables without repetition.
  • Query optimization - reading execution plans (EXPLAIN).
  • Other databases - PostgreSQL, as well as NoSQL databases like MongoDB.

Callimachus's final word

I created the Pinakes so that no scroll would be lost in the dark. You have learned the same art - to bring order to knowledge. Now go and build your own catalog. May your database stand as firm as the walls of Alexandria. You are a Master of the Catalog. THE TREASURY BELONGS TO YOU!

Spotted a mistake in this lesson?

Check yourself

Answer the questions from this lesson. Pick an answer to see right away whether it is correct.

  1. 1. Which of the following skills did you master throughout the whole journey through the Great Library?

  1. QuestionThe knowledge of a Master of the Catalog
  2. Project to submitYour Magnum Opus
  3. VideoModule summary

Useful articles