Head First SQL

Tytuł: Head First SQL
Autor: Lynn Beighley
Wydawnictwo: O’Reilly

Zawartość merytoryczna / związek z tematem: 4/5
Styl / łatwość czytania: 5/5
Przydatność: 4/5
Ocena ogólna: 4/5

Recenzent:: Grzegorz Duda

If you are developer and need to refresh your SQL knowledge or if you want to learn SQL very fast and with some fun – it is book for you. This is not a book for Database Administrators. Second disclaimer – they use examples for MySQL, so if you are using different DB, you need to translate some of them.

I believe I do not need to convince you how good are “Head First” series, so let’s focus on the content.

It starts from explanation what DB is and some easy SELECT queries, so you can read this book without any knowledge in DB world.

Next chapters cover UPDATE, INSERT, DELETE, primary/foreign keys, ALTER, ORDER BY with most common aggregation functions (like MAX, AVG), inner/outer joins and more. There is also place for some theory and DB patterns.

As always, couple of the last chapters contains a bit more complex information like roles and privileges, constraints, unions, intersections and subqueries.

In summary, it is very good book that gives you short introduction to DB world (with some advanced knowledge). I do not know anything that is required in my day to day job that is not in this book.

sponsors & partners