Gr 12 – SQL Term Test

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

Gr 12 – SQL Joins

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

GR 11, 12 – SQL Select

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