SQL Queries for Mere Mortals – John Viescas
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL is one of the most straightforward books for understanding SQL.
The book is beneficial for individuals who face challenges with SQL queries. My absolute opinion about this essential reading material follows.
Also check: SQL roadmap
The book suits beginners and those who wish to develop their SQL competency. It presents complex matters using basic terminology that everyone can understand, so a lack of technical expertise is not a barrier to understanding these concepts.
The book explains the complete process of SQL query development through practical examples. The book begins with basic SELECT statements before introducing progressive concepts that include joins and subqueries.
The book teaches practical problems solved by SQL queries, which I found most appealing. The information presented in this format applies practical usage over abstract theory.
The instructions provide training on filtering tables, sorting capabilities, grouping operations, and joining multiple tables. The book instructs you to compose queries that are easily read and error-free.
The book discusses advanced topics encompassing CASE statements, window functions, and GROUP BY statements with roll-ups.
Once you finish reading SQL Queries for Mere Mortals, you will gain confidence in SQL and become capable of working with real databases.
GET 100% FREE ACCESS TO THIS BOOK BY SIGNING UP HERE!
How do I get this book for free?
Just SIGN UP & SUBSCRIBE from my LINK and enjoy your FREE copy of SQL Queries for Mere Mortals now!
READ ALSO: SQL Cheat Sheets
Table of Contents
- Introduction to Databases
- SELECT Basics
- Sorting with ORDER BY
- Filtering with WHERE
- Grouping Data
- Joining Tables
- Subqueries
- Modifying Data (INSERT, UPDATE, DELETE)
- Advanced Conditions
- Using CASE
- Window Functions
- GROUP BY with Roll-Ups
Read Time
The total reading duration for the complete printed book amounts to 2–3 weeks when spending one hour each day. Users prefer Kindle since it enables fast searches and note-taking functions.
Check also: SQL Interview Questions
Details
- Publisher : Addison-Wesley Professional; 4th edition (February 9, 2018)
- Language : English
- Paperback : 960 pages
- ISBN-10 : 0134858336
- ISBN-13 : 978-0134858333
- Item Weight : 2.31 pounds
- Dimensions : 2.1 x 7 x 9.1 inches
- Best Sellers Rank: #42,000 in Books
About Author
John Viescas enjoys widespread recognition in the database field. The author successfully published several well-known books about SQL and Access. His books’ straightforward writing logic enables easy comprehension for readers.
CONCLUSION
Among the best books for learning SQL is SQL Queries for Mere Mortals. The book gradually and confidently teaches skills.
Other readers should share this review if they find it helpful. When you return shortly, you will find additional outstanding book reviews.
Read More
If you love learning programming, here is a list of excellent books you should explore.
- Python Programming for Beginners – 3 Books in 1 – Mark Reed
- Python Crash Course – 3rd Edition – Eric Matthes
- Python Programming for Beginners – Philip Robbins
- Learn AI-Assisted Python Programming (With GitHub Copilot and ChatGPT)
- Introducing Python (2nd Edition): Modern Computing in Simple Packages
