SQL Basics: Learn SQL the easy way
| Author | : | |
| Rating | : | 4.91 (978 Votes) |
| Asin | : | 1521749787 |
| Format Type | : | paperback |
| Number of Pages | : | 70 Pages |
| Publish Date | : | 2017-08-02 |
| Language | : | English |
DESCRIPTION:
With this book you’ll learn all the necessary basics: Database theoryCreate and alter database structuresInsert, edit and delete dataCreate easy queries (calculations, filter, sorting, functions)Query multiple tables (Cross product, Inner joins, Outer joins)Grouping and aggregationSub-queries & Set operationsetc. In the appendix you find „translation tables“ for DB2, MySQL and MS SQL. This book is based on an Oracle database. Besides he’s offering trainings on different database topics (SQL, Cognos, MDX, etc.).. About the author Fabian Gaußling studied information management in Kiel, Germany. But it’s possible to use it easily with other relational databases like Microsoft SQL Server, DB2 or MySQL. Lot’s of practical exerciss Each chapter contains a lot of execises in order to deepen the new knowledge and to apply it. After that he worked several years for different companies in the area of database developement and data warehousing. Where it is necessary the differences between the databases are pointed out. Since 2013 he has worked as an freelancer in the field of databases. The
lindsey geest said Best SQL book for beginners. I purchased this book with the intention of writing simple SQL queries in the oracle sql developer environment. This book is exactly what I was looking for! It has excellent code samples that you can quickly implement in the environment of your choice. The author does an excellent job of clarifying the variations in different SQL implementations.The book starts with some database theory. If you are already familiar with database basics you can skip that part. Then the SQL language itself is explained starting with some basic stuff like how to select columns, how to filter rows, how to do calculations, etc. After that, joins are ex