SQL in 10 Minutes a Day, Sams Teach Yourself by Ben Forta

 Its a good SQL book for beginners. I primarily was focusing on query commands. And skipped chapters dealing with mutating tables and advanced topics.

Sample query:
SELECT col1, col2, count(*) FROM table_name WHERE <conditions> GROUP BY <col> HAVING <conditions> ORDER BY <col>;
SELECT col1, col2 FROM table_name_1 t1 JOIN table_name_2 t2 ON t1.eniid = t2.eniid WHERE t1.id=‘ID’;

Chapters include Retrieving data, Sorting Retrieved Data, Filtering Data, Advanced Data Filtering, Using Wildcard Filtering, Creating Calculated Fields, Using Data Manipulation Functions, Summarizing Data, Grouping Data, Working with Subqueries, Joining Tables, Creating Advanced Joins, Combining Queries, more changes which deal with create, update and delete and other advance Topics.