by Editorial | Mar 1, 2023 | 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 | Aug 22, 2022 | Grade 12, Grade 12 - SQL
Here is a SQL exercise based on the 2022 SQL exam set by Dr C Kader and moderated by Mr T de Jager and Mr R Viljoen of the IEB Pretoria 480 cluster. In some cases you may find comments which can be annoying if you print the documents shown below. These can be turning...
by Editorial | Aug 17, 2020 | Grade 11, Grade 11 - Text Files, Grade 12, Grade 12 - PAT, Grade 12 - SQL, Grade 12 - text files
In your three class OOP programs – when working with textfiles, while-loops, creating an array of objects and databases . . . . there is a golden thread of consistency that you must adhere to ie the fields, the field types, number of fields and their order, must...
by Editorial | May 16, 2020 | Grade 12, Grade 12 - SQL
Here is a SQL Term Test based on the Ms Access database “BP Challenge” (Slightly modified. I do not know who the original author of this database is.). The database can be opened and SQL queries written in SQLBrowser (so you don’t need to have a copy...
by Editorial | May 9, 2020 | Grade 12 - SQL, PWC grade 12 - All
SQL summary cheat sheet version 5 Click here SQL summary cheat sheet. Author unknown. Click...
by Editorial | May 2, 2020 | Grade 10 - SQL, Grade 11 - SQL, Grade 12 - SQL
If you do not have Ms Access you can still run SQL queries using SQLBrowser. Click to download SQLBrowser for Windows. (note: it only works with Ms Access databases with the old “mdb” extension. It does not work with “accdb”) NOTE: In Access...
