SQL Basics: Learn SQL the easy way

Author(s): Fabian Gaussling

Publisher: Independently published, Year: 2017

Start directly now and dive into the world of databases and SQL. With this book you’ll learn all the necessary basics:

• Database theory
• Create and alter database structures
• Insert, edit and delete data
• Create easy queries (calculations, filter, sorting, functions)
• Query multiple tables (Cross product, Inner joins, Outer joins)
• Grouping and aggregation
• Sub-queries & Set operations
• etc.

This book is based on an Oracle database. But it’s possible to use it easily with other relational databases like Microsoft SQL Server, DB2 or MySQL. Where it is necessary the differences between the databases are pointed out. In the appendix you find „translation tables“ for DB2, MySQL and MS SQL.