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.
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:
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
Note that right join is not supported in sqlite3.