Powerful ideas from top nonfiction
Try Blinkist to get the key ideas from 7,500+ bestselling nonfiction titles and podcasts. Listen or read in just 15 minutes.
Get started for free
Blink 3 of 8 - The 5 AM Club
by Robin Sharma
SQL Queries for Mere Mortals summary
John L. Viescas
Brief summary
SQL Queries for Mere Mortals by John L. Viescas is a comprehensive guide that teaches SQL query language in a clear and understandable way. It covers a wide range of topics, from basic to advanced queries, making it suitable for beginners and experienced professionals alike.
Table of Contents
SQL Queries for Mere Mortals
Summary of key ideas
Understanding SQL from the Ground Up
In SQL Queries for Mere Mortals, John L. Viescas introduces us to the world of SQL, assuming no prior knowledge of databases or SQL. The book begins with the basic concepts of SQL, such as what a database is, what a query is, and how to retrieve data from a database using SELECT statements. It also covers the fundamental concepts of relational databases, such as tables, rows, and columns.
As we progress through the book, Viescas delves into more advanced topics, such as sorting and filtering data using ORDER BY and WHERE clauses. He explains the use of aggregate functions like SUM, COUNT, AVG, and MAX, to perform calculations on data within a table. The author also teaches us how to group data using GROUP BY and HAVING clauses, and how to work with multiple tables using JOIN operations.
Mastering Complex SQL Queries
After establishing a solid foundation, SQL Queries for Mere Mortals moves on to more complex queries. Viescas introduces us to subqueries, which are queries nested within other queries, and explains how they can be used to solve more complex problems. He also covers the use of set operations such as UNION, INTERSECT, and EXCEPT to combine the results of multiple queries.
We then dive into the more advanced features of SQL, including the use of CASE expressions to perform conditional logic in our queries. Viescas also demonstrates how to modify data in a database using INSERT, UPDATE, and DELETE statements. Throughout these discussions, the author provides numerous examples and exercises to reinforce our understanding.
Applying SQL in Real-World Scenarios
As we progress, SQL Queries for Mere Mortals takes a practical turn, guiding us through real-world scenarios and demonstrating how to apply SQL to solve common business problems. Viescas shows us how to handle missing or incorrect data, how to work with date and time data, and how to create reports from our query results.
The final sections of the book focus on improving the performance of our queries. Viescas explains how to use indexes to speed up data retrieval, how to optimize complex queries, and how to monitor and tune our database for better performance. He also discusses the security aspects of SQL, such as user privileges and data encryption.
Practical Exercises and Resources
Throughout the book, Viescas provides numerous exercises and examples, encouraging us to practice and apply what we've learned. He also provides downloadable sample databases, allowing us to follow along with the exercises and experiment with SQL in a real-world context.
In conclusion, SQL Queries for Mere Mortals is an excellent resource for anyone who wants to learn SQL from scratch or deepen their understanding of the language. Viescas' clear and engaging writing style, combined with practical examples and exercises, makes this book an essential guide for mastering SQL and effectively querying relational databases.
How do we create content on this page?
More knowledge in less time
Read or listen
Get the key ideas from nonfiction bestsellers in minutes, not hours.
Find your next read
Get book lists curated by experts and personalized recommendations.
Shortcasts New
We’ve teamed up with podcast creators to bring you key insights from podcasts.
What is SQL Queries for Mere Mortals about?
SQL Queries for Mere Mortals by John L. Viescas is a comprehensive guide for beginners and experienced professionals alike. It provides clear explanations and practical examples to help you master the art of writing SQL queries. Whether you're retrieving data, modifying tables, or creating complex joins, this book will equip you with the knowledge and skills you need to become proficient in SQL.
SQL Queries for Mere Mortals Review
SQL Queries for Mere Mortals (2018) is a comprehensive guide to mastering SQL queries for database management. Here's why this book is a valuable read:
- Explains complex SQL concepts in a way that is easy to understand and apply, making it accessible even for beginners.
- Offers a plethora of real-world examples and exercises to practice and reinforce learning, ensuring hands-on experience.
- Presents SQL querying techniques in a clear, engaging manner that keeps readers interested and motivated throughout the learning process.
Who should read SQL Queries for Mere Mortals?
Individuals who want to learn how to write effective SQL queries
Professionals looking to improve their data analysis and manipulation skills
Students or beginners in the field of database management
Categories with SQL Queries for Mere Mortals
Book summaries like SQL Queries for Mere Mortals
People ❤️ Blinkist
Sven O.
It's highly addictive to get core insights on personally relevant topics without repetition or triviality. Added to that the apps ability to suggest kindred interests opens up a foundation of knowledge.
Thi Viet Quynh N.
Great app. Good selection of book summaries you can read or listen to while commuting. Instead of scrolling through your social media news feed, this is a much better way to spend your spare time in my opinion.
Jonathan A.
Life changing. The concept of being able to grasp a book's main point in such a short time truly opens multiple opportunities to grow every area of your life at a faster rate.
Renee D.
Great app. Addicting. Perfect for wait times, morning coffee, evening before bed. Extremely well written, thorough, easy to use.
People also liked these summaries
4.8 Stars
Average ratings on iOS and Google Play
43 Million
Downloads on all platforms
10+ years
Experience igniting personal growth
SQL Queries for Mere Mortals FAQs
What is the main message of SQL Queries for Mere Mortals?
The main message of SQL Queries for Mere Mortals is to demystify SQL language and empower non-experts to master database queries.
How long does it take to read SQL Queries for Mere Mortals?
To read SQL Queries for Mere Mortals fully takes time. For a quick overview, consider reading the Blinkist summary.
Is SQL Queries for Mere Mortals a good book? Is it worth reading?
SQL Queries for Mere Mortals is a must-read for anyone diving into SQL. Its clear explanations make mastering SQL accessible and rewarding.
Who is the author of SQL Queries for Mere Mortals?
The author of SQL Queries for Mere Mortals is John L. Viescas.
What to read after SQL Queries for Mere Mortals?
If you're wondering what to read next after SQL Queries for Mere Mortals, here are some recommendations we suggest:
- Big Data by Viktor Mayer-Schönberger and Kenneth Cukier
- Physics of the Future by Michio Kaku
- On Intelligence by Jeff Hawkins and Sandra Blakeslee
- Brave New War by John Robb
- Abundance# by Peter H. Diamandis and Steven Kotler
- The Signal and the Noise by Nate Silver
- You Are Not a Gadget by Jaron Lanier
- The Future of the Mind by Michio Kaku
- The Second Machine Age by Erik Brynjolfsson and Andrew McAfee
- Out of Control by Kevin Kelly
Featured Titles
- The Cybersecurity Dilemma
- The Field Guide to Understanding 'human Error'
- The Hacked World Order
- The Hacker and the State
- The Hundred-Page Machine Learning Book
- The Science of Self-Learning
- The Ultimate Unofficial Encyclopedia for Minecrafters
- Training from the Back of the Room!
- Understanding Machine Learning
- We Are Anonymous