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 | Mar 14, 2020 | Grade 11 - SQL, Grade 12 - SQL
Retrieving data out of a relational database is done mainly through the SELECT keyword in SQL. Here is a great video to explain the SQL SELECT statement. Part One. Note that our version of SQL supports TOP 1 and not LIMIT. Here is the link to SQL SELECT statement Part...
by Editorial | Feb 27, 2020 | Grade 12 - SQL, PWC grade 12 - All
Here is the IEB 480 SQL cluster test from 2018. The Ms Access DB will download into your downloads folder but the question paper and memo which are pdf documents will render in your browser. AnimalDB Test Paper...
by Editorial | Sep 24, 2019 | Grade 12 - Prelim Papers, Grade 12 - SQL, PWC grade 12 - All
Here is the SQL question from the 2019 Prelim practical paper. While it is useful to be able to run the Ms Access DB on your computer, it is not necessary. The question paper has all you need to write the SQL statements. Do these questions over and over again...
by Editorial | Sep 3, 2019 | Grade 12 - SQL, PWC grade 12 - All
A SQL practice exercise with both one, two and three tables. How to use SQL with more than one table is explained in the exercise. I suggest that you cover over the SQL statement with a piece of paper (on the left) and then read the explanation only (on the right)....
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....
