Structured Query Language

The foundation language to work with relational databases, SQL is the core language of data management. It is also a very good book to have whether you are new to databases or you just want to sharpen your data skills because this book is equipped with the necessary knowledge to be able to retrieve, modify and manage data successfully using SQL.

The book starts with theory of the database, detailing the relational databases and the basic syntax of SQL. It then moves to data retrieval and data manipulation operations, with advanced operations, including joins, subqueries and set operators. You will be taught how to manipulate the objects of a database that have indexes, views, and triggers, understand the advanced features of SQL such as window functions and common table expressions (CTEs) and how to create a query that is best optimized. The book goes on to hand you over to practical projects that put into practice all you have learned into real life situations to get you ready to be applied immediately to a practical situation.

At the end of the book, not only will you be familiar with the syntax and commands of SQL but you will be confident with your newfound knowledge by having introduced you to the world of SQL with guided projects that can simulate real job situations. With this book, you will be able to comfortably deal with relational databases and use SQL in your daily duties with numerous tools and platforms.

WHAT YOU WILL LEARN

* Master SQL basics, syntax and database schema.

* Develop effective and clean SQL statements with core commands.

Retrieval, filtering, sorting and aggregating data of relational databases.

* Add, update and delete records and retain data integrity.

* Combine two or more tables to bring out useful, interrelated data information.

* Manipulation and analysis of data by use of functions, operators, and clauses.

* Process data type, conversions and string manipulation methods.