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 | 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...
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 | 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....
