- Shopping Bag ( 0 items )
From Barnes & NobleOur Review
If your mom didn't raise you to write SQL queries but you've got to do it anyway, we've got your book. SQL Queries for Mere Mortals explains SQL so anyone can understand it -- and write queries that actually deliver the answers they're looking for.
The authors focus entirely on the art of writing end-user queries with SQL, avoiding the "serious" database programming topics that most SQL books focus on. And they use generic SQL that should work on virtually any contemporary database, from Access to Oracle.
You'll start by learning what SQL does and how it interacts with relational databases. Next, you'll start writing simple SELECT statements, learn how to refine them, and master techniques for returning more than simple columns and for using WHERE to filter your data.
Since you'll typically have to draw data from multiple tables, SQL Queries for Mere Mortals explains how to do so, simply and clearly. Hernandez and Viescas thoroughly demystify unions, inner and outer joins, and subqueries and offer practical techniques for grouping, totaling, and summarizing data. Every chapter contains plenty of examples and ends with practice exercises.
Simply put, this book is a life raft for anyone who must ferret accurate data out of an SQL database without formal training.