by Editorial | Aug 19, 2026 | Grade 12 - SQL
In grade 12 you need to be familiar with composite SQL statements (embedded / nested SQL statements). This means that two statements are joined together – the result set on one query is passed to the other. Therefore there are two SELECT / FROM statements joined...
by Editorial | Jun 6, 2025 | Grade 10 - SQL, Grade 11 - SQL
Here is a paried down SQL summary suitable for grade 10 and 11. Version 10 Click...
by Editorial | Mar 3, 2025 | Grade 11, Grade 11 - SQL, Grade 12, Grade 12 - SQL
SQL TIPS for exams. STUDY the database first (at least 5 full minutes). Study both the data and the fields. Know how many records are in each table so that you can recognize any potential errors in the returned dataset. The better you understand the database, the...
by Editorial | Mar 15, 2020 | Grade 12, Grade 12 - SQL
I have shown you how to join tables using the WHERE clause. This is a great way to start understanding joins. But there is a better way ie using the JOIN keyword (inner joins and outer joins) Here is a very cool video explaining inner and outer joins in SQL. More SQL...
by Editorial | Aug 18, 2019 | Grade 11 - SQL, Grade 12 - SQL
An excellent introductory resource is “w3.schools.com” which has interactive exercises for you to practice in real time. Once you have mastered those, try “sqlzoo.net” ** which has more difficult questions – take your time, take notes....
