What do you need to work with the textbook?
To solve the exercises analyzed in the textbook, you may:
1. Use the available console for query execution. Currently, queries are run against Microsoft SQLServer, but we plan to expand the range of DBMS’s used in the textbook. In particular, we intend implementing query execution against Oracle, PostgreSQL, MySQL.
2. If you prefer to use the DBMS installed locally on your computer, you can download the sample databases scripts at www.sql-ex.ru/db_script_download.php. Each of these scripts will create the necessary tables of the respective sample database and populate them with data.
3. If you are already familiar with SQL, try visiting www.sql-ex.ru where you can solve online not just simple exercises for beginners presented here. More complex tasks will help you to assess your competency level in practical application of SQL, and the rating system will allow you to compete with about 20’000 its other participants. The check system of the site will test whether your queries are correct, and the forum there is a great place to get acquainted with solutions by other visitors. You may learn a lot from analyzing queries posted on the forum, since many of them have been written by true professionals.