Working with MySQL, MS SQL Server and Oracle in examples. 2nd ed.

Author: Kulikov S.
Year: 2022
Number of pages: 592

This book is dedicated to the practice of using SQL for solving typical problems. It doesn't cover the theory of relational databases (assuming that you are familiar with it or can find the missing information), but presents more than 500 SQL queries: from elementary selections to the use of views, triggers, stored procedures and functions.

All examples are presented as problem statements and their solutions using MySQL, MS SQL Server and Oracle, and are supplied with explanations and analysis of typical errors.

This material will be useful primarily to those who:

• have studied databases before, but have forgotten a lot;
• have experience with one DBMS, but want to switch to another;
• wants to learn how to write typical SQL queries in a very short time.