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 Pocket Guide summary
Jonathan Gennick
Brief summary
SQL Pocket Guide by Jonathan Gennick is a handy reference for SQL syntax, functions, and usage. It provides clear explanations and examples, making it a valuable resource for both beginners and experienced SQL users.
Table of Contents
SQL Pocket Guide
Summary of key ideas
Understanding SQL Basics
In SQL Pocket Guide by Jonathan Gennick, we delve into the fundamentals of SQL, the standard programming language for working with relational databases. The book begins by introducing the basic structure of SQL, the syntax and semantics of SQL statements, and the various data types used in SQL. We also explore how to create, modify, and delete tables, and how to insert, update, and delete data in these tables.
Jonathan then walks us through the process of querying data from tables using the SELECT statement. He explains how to filter and sort data, use aggregate functions to summarize data, and employ various SQL clauses such as GROUP BY, HAVING, and ORDER BY to manipulate query results. Additionally, we learn about the difference between inner and outer joins, and how to perform set operations on query results.
Manipulating Data with SQL
Building on our foundational knowledge, SQL Pocket Guide delves deeper into data manipulation operations in SQL. We explore the concept of subqueries and derived tables, and how to use them to solve complex data retrieval problems. We also learn about SQL's ability to create and manage views, which are virtual tables based on the result of a SELECT statement.
Jonathan then introduces us to the concept of database transactions and the use of SQL's Data Control Language (DCL) statements to manage transactional operations such as committing, rolling back, and saving points in transactions. We also discuss SQL's security features, including user account management and the granting and revoking of privileges.
Advanced SQL Concepts and Database Management
Moving on to more advanced topics, SQL Pocket Guide explores SQL's ability to create and manage stored procedures, functions, and triggers. We learn how to define these database objects, and how to use them to automate common tasks, enforce data integrity, and improve database performance.
Jonathan then provides an overview of SQL's support for working with large objects, such as images and audio files, and its ability to handle complex data types such as arrays and user-defined types. He also discusses SQL's support for working with XML data, including querying, updating, and indexing XML documents stored in a database.
Database-Specific SQL Features
In the latter part of the book, SQL Pocket Guide delves into the specific SQL features and extensions provided by some of the major relational database management systems (RDBMS). We explore the differences between SQL implementations in database systems such as Oracle, MySQL, Microsoft SQL Server, and PostgreSQL.
Jonathan explains how these systems implement SQL syntax for querying, managing transactions, and making changes to data. He also covers the unique features and extensions each system provides, such as Oracle's support for the recursive WITH syntax, MySQL's TIMESTAMP type, and PostgreSQL's support of recursive WITH and window functions.
Conclusion: A Comprehensive SQL Reference
In conclusion, SQL Pocket Guide by Jonathan Gennick serves as a comprehensive reference for SQL programmers and database administrators. It covers the entire spectrum of SQL, from basic querying and data manipulation to advanced database management and system-specific features. Whether you're new to SQL or an experienced practitioner, this book provides a valuable resource for understanding and leveraging the power of SQL in your database-related tasks.
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 Pocket Guide about?
SQL Pocket Guide is a concise reference book that provides a comprehensive overview of SQL syntax, functions, and usage. It covers various database systems including MySQL, PostgreSQL, SQL Server, and Oracle. Whether you're a beginner or an experienced SQL user, this book offers quick and easy access to essential information for writing and executing SQL queries.
SQL Pocket Guide Review
SQL Pocket Guide (2018) by Jonathan Gennick is a concise reference providing essential information on SQL commands and syntax. Here's why this guide is a valuable resource for SQL enthusiasts:
- Offers clear explanations on key SQL concepts, simplifying complex queries and enhancing understanding.
- Provides a quick reference format, enabling users to find information swiftly and apply it effectively in programming tasks.
- Includes practical examples that demonstrate the application of SQL commands in real-world scenarios, keeping the content engaging and relatable.
Who should read SQL Pocket Guide?
Programmers and developers who need a quick reference for SQL syntax and commands
Database administrators who want a handy guide for managing and querying databases
Students and professionals studying or working with SQL who need a compact and comprehensive resource
Categories with SQL Pocket Guide
Book summaries like SQL Pocket Guide
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 Pocket Guide FAQs
What is the main message of SQL Pocket Guide?
The main message of SQL Pocket Guide is to provide a concise reference for SQL syntax and usage.
How long does it take to read SQL Pocket Guide?
Reading SQL Pocket Guide takes a few hours. The Blinkist summary can be finished in 15 minutes.
Is SQL Pocket Guide a good book? Is it worth reading?
SQL Pocket Guide is a valuable resource for SQL beginners and professionals alike, offering quick and practical insights.
Who is the author of SQL Pocket Guide?
Jonathan Gennick is the author of SQL Pocket Guide.
What to read after SQL Pocket Guide?
If you're wondering what to read next after SQL Pocket Guide, 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