Чему вы научитесь
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.
753