SQL Queries 2012 Joes 2 Pros Volume 2 – The SQL Query Techniques Tutorial for SQL Server 2012
You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference.
Why Buy this Book
The beta of this book actually existed for a year and was tested and used in my classroom. Its purpose back then was to help the students do the steps individually that led to the skills where they could all pass the Microsoft test. It worked and then many went out for their SQL interview. They did good enough to get the job but they told me about one or two questions they were not able to answer. A year of collecting this data and turning them into lessons doubled the size of this book from 300 pages to 600 pages. This book is designed to make the query question and query skills in the professional work seem must easier.
Each lesson and chapter builds sequentially. The labs have been created and delivered by me over several years of teaching SQL. If a lab offered one of my classrooms an exciting “ah-ha” experience with students leaning forward on every word and demo, it’s a keeper. However, when a lab caused more of a trance or tilted squint, it was discarded or revised with a better approach. The labs in this book are the end result, and each one consistently elicits “ah-ha” moments in my classes.
This book follows what students told me worked for them and launched their careers. This curriculum has helped many people achieve their career goals. If you would like to gain the confidence that comes with really knowing how to get things done, this book is your ticket.
Chapter 1. Data, Information and Tables
Chapter 2. Query Options
Chapter 3. NULL, Expression and Identity Fields
Chapter 4. Aggregating Data
Chapter 5. Aggregation Strategies
Chapter 6. TOP(n) Record Queries
Chapter 7. Ranking Functions
Chapter 8. Predicating and Tiling Ranked Data
Chapter 9. Set Operators
Chapter 10. Temporary Named Result Sets
Chapter 11. Data Recursion
Chapter 12. Using Subqueries
Chapter 13. Advanced Subqueries
Chapter 14. The MERGE Statement
Chapter 15. The OUTPUT Clause
Chapter 16. Next Steps for Aspiring SQL Pros