⌬ Aytict Academy
🗄️

SQL Beginner

SELECT, WHERE, ORDER BY and basic data changes.

3 lessons 7 tasks
Lessons Quiz Certificate

📚 Lessons

1 SELECT & WHERE

SQL reads rows from tables. SELECT chooses columns; WHERE filters rows. List columns explicitly rather than using *.

SELECT name, email
FROM users
WHERE country = 'FI';

2 ORDER BY & LIMIT

Sort results with ORDER BY (ASC/DESC) and cap them with LIMIT.

SELECT name, score
FROM players
ORDER BY score DESC
LIMIT 10;

3 INSERT, UPDATE, DELETE

Change data with INSERT, UPDATE and DELETE. Always include a WHERE on updates and deletes, or you change every row.

INSERT INTO users (name, country) VALUES ('Ada', 'GB');
UPDATE users SET country = 'UK' WHERE name = 'Ada';
DELETE FROM users WHERE name = 'Ada';

📝 Tasks

7 tasks across 3 pages — multiple-choice and fill-in (type the answer). Score 70% or higher to earn your certificate.

🎓 Certificate of Completion

🔒 Pass the quiz above (70%+) to unlock your downloadable certificate.