In college_database.sql, the sql file is completed on MySQL Workbench 8.0 with the topics:
🔹 Basic SQL Commands.
🔹 Creating tables.
🔹 Table-related queries.
🔹 SELECT Clause.
🔹INSERT Clause.
🔹 WHERE clause.
🔹Operators (AND, OR, etc).
🔹LIMIT clause.
🔹ORDER BY clause.
🔹Aggregate functions (COUNT, SUM, AVG, etc.).
🔹GROUP BY clause.
🔹HAVING clause.
🔹UPDATE command.
🔹DELETE command.
🔹Revisiting and working with keys.
🔹ALTER TABLE.
🔹CHANGE & MODIFY.
🔹TRUNCATE.
🔹JOINS (inner/ left/ right etc).
🔹UNION.
🔹Sub-queries (Under SELECT, FROM, and WHERE).
🔹Views (virtual tables).