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