Dutch version of this page

Below you will find additional pieces you can view with Adobe Acrobat Reader or download.

Book 'Databases and SQL': practice material SQL
There is an English and Dutch version of the book Databases and SQL. In these books two databases are used for the explanation of SQL. You can download these databases. You can also download an explanation of the use of these databases and a file with a number of exercises.

Access database English
You can download the two databases used in the English version of the book 'Databases and SQL' in the shape of tables of an Access database by using the following link:
Access database with the databases used in the English book

Script for creating the databases
Those who have an Oracle, SQL-server, DB2, MySQL, PostgreSQL, SQLite3 et cetera database environment, can download here a script with which you can create the tables of the book in a database:
Script for making the tables

Explanation of the use of Access and Oracle databases
The use of Access as a database environment is not that obvious. You cannot immediately start with the composition of a query. For this you first need to already have a query that you subsequently rewrite. For the trial of queries with Oracle you first need to execute the script after which you can use SQL Plus. For Access and Oracle you will find an explanation in the download:
The use of the databases in Access en Oracle

SQL exercises
Obviously you can use the queries in the book to exercise. However, it is probably nicer to have a few extra exercises. In the download you will find 32 exercises:
Exercises SQL

workshop SQL
Not everybody succeeds in learning to make SQL queries by using the book. If you would like to attend a workshop, you may consider to attend one of the workshops Ton de Rooij lectures himself. The workshop is given in English. See the website of his company for subscribing:
Workshop SQL held in ENGLISH by Ton de Rooij



Embedded SQL
If you want to use SQL statements in a 3GL program the compiler of the 3GL programming language needs to know which code is for the compiler and which code is for the SQL database environment. In addition to that a data exchange between the program and the database is needed. This is accomplished with variables. SQL must be able to see whether a variable is supplied by the 3GL program. For the use of SQL in a 3GL program you can use Embedded SQL language elements.
In the download an explanation is given of the most important language elements. A number of examples are given.




Information analysis using the ER-model
(written in Dutch)
The book 'Datamodellering' (data modeling) came out July 2010. The subject of the book is information analysis using the ER-model. It took (a long) time to write the book. To be of service to his readers, Ton de Rooij already had made a comprehensive explanation of information analysis using the ER-model. It is not a part of the book, but rather a text that is fully separate from it. The way the modeling is explained (in the download and the book) meets the way EXIN took exams in the modules HSB.1 (no longer in existance) and SIAA (structured information analysis advanced. The text of the download cannot supplant the book. Ton de Rooij strongly recommends you to buy the book 'Datamodellering' (if you can read Dutch).