Tutorial Section

1) SELECT:
In which we query the BBC country profile table.
2a) More practice with SELECT:
Additional practice of the basic features using a table of Nobel Prize winners.
2b) SELECT in SELECT:
In which we form queries using other queries.
3) SUM and COUNT:
In which we apply aggregate functions.
4) The JOIN operation:
In which we join two tables; ttms and country. (previously music tutorial)
5) More JOIN operations:
In which we join actors to movies in the Movie Database.
6) The OUTER JOIN:
In which we include the parties without people and the people outwith parties in the Scottish Parliament.
In which we join Edinburgh bus routes to Edinburgh bus routes.

To Download this E-Book Click Here.