SQL skills are highly demanded in
the labour market and are part of most programmer's daily work.
In addition, they are paid well, see eg.
SQL Programmer Salary.
So please stay focused as you study SQL and complete your assignment work.
We'll use SQLite3 which is a reasonably complete implementation of the SQL-92
standard and generally follows PostgreSQL syntax.
Set up your computer to have a working installation of a database
browser and an actual database.
Download DB Browser for SQLite
(available via apt when using Debian based Linux
distributions
Download the
Northwind-SQLite3
database, extract it and open it with SQLite DB Browser
To get an understanding of the database, study the entity relationship
diagram (ERD) of the northwind database:
Northwind ERD
Look at the database structure and try to understand the fields of the 13 tables in the database
Browse the data to get a feeling for the data tables present
To prepare for your exam and get help for our exercises, work through the
SQL Tutorial, but
execute the examples in your local database (use the
Execute SQL tab of DB Brower for SQLite).
So far, we covered everything up to and including join.
Wikipedia also provides a good introduction to
SQL Joins.
Note that right join is not supported in sqlite3.
KDE Neon Linux-based VirtualBox image with all programming tools we need:
progamming.ova
Download with username: student, ask in class for the password
Login with username: student, password: changeme