Interactive SQL Tutorial

If you’d like to know what SQL is, this site is for you.

If you already have an idea what SQL is, but want to learn how to write queries in this language, this site is for you.

If you think you’re already quite skilled in SQL query writing, don’t quit this site immediately. There is a good chance you will discover something new.

If you don’t know how and using what server to write queries, this site probably is exactly what, for a long time, you have been looking for. Queries can be executed* against sample databases directly on site.

If everything seems clear to you in this textbook, test your skills using exercises from SQL-EX.RU. The learning stage here already allows the usage of several DBMS including MSSQL, MySQL, Oracle, and PostgreSQL.

The goal of this book is to let you learn SQL quickly. Here, «quickly» does not mean «superficially». On the contrary, while leaving aside many aspects of the language, the author tries to convey a thorough understanding of logical data structure, and consequently of constructing correct to give the idea of correct form of query taking into account structure. On top of that, we strongly believe, that reading of this book will contribute to understanding of the problems, which are outside the scope of this work.

We hope the site will prove useful both for beginners and professionals of SQL programming.