SQL 9 for BIL

SQL 9 for BIL is a beginner SQL course for grade 9 informatics students at Atyrau BIL. Every lesson uses one story: the School Library database, with Kazakh books, authors and students.

How a lesson works

Lessons are 40 minutes. First the teacher explains the topic, then you practise here. Each lesson has the same structure:

• Theory: a short summary with examples you can read again at home.
• 4 SQL tasks (2 points each): you write real queries and Stepik checks them right away.
• Matching task (1 point): connect SQL words with their meaning.
• Challenge (1 point): a harder task for the strongest students.

Every lesson is worth 10 points, which is your formative grade for the lesson.

What you will learn

1st quarter: creating tables (CREATE TABLE, INSERT), reading data (SELECT, WHERE, ORDER BY, LIMIT), counting with aggregate functions and GROUP BY, and changing data (UPDATE, DELETE). Practice project: School Canteen.

2nd quarter: why a database has many tables, primary and foreign keys, INNER JOIN and LEFT JOIN, statistics with JOIN + GROUP BY, and queries across three tables. Practice project: Sports Clubs.

No previous programming experience is needed.