Buy New
-
To see product details, add this item to your cart.
Ships from: Amazon.com Sold by: Amazon.com
Save with Used - Very Good
-
To see product details, add this item to your cart.
Ships from: Vivé Liber Books LLC Sold by: Vivé Liber Books LLC
Sorry, there was a problem.
There was an error retrieving your Wish Lists. Please try again.Sorry, there was a problem.
List unavailable.
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
Learning SQL: Generate, Manipulate, and Retrieve Data 3rd Edition
Purchase options and add-ons
As data floods into your company, you need to put it to work right away―and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You’ll find new chapters on SQL and big data, analytic functions, and working with very large databases.
Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you’ll quickly discover how to put the power and flexibility of this language to work.
- Move quickly through SQL basics and several advanced features
- Use SQL data statements to generate, manipulate, and retrieve data
- Create database objects, such as tables, indexes, and constraints with SQL schema statements
- Learn how datasets interact with queries; understand the importance of subqueries
- Convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements
- ISBN-101492057614
- ISBN-13978-1492057611
- Edition3rd
- PublisherO'Reilly Media
- Publication dateApril 21, 2020
- LanguageEnglish
- Dimensions7 x 1 x 9.25 inches
- Print length377 pages
Frequently bought together

Customers who viewed this item also viewed
Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with DataPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Wednesday, Jun 10
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)PaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Wednesday, Jun 10
SQL for Data Analysis: Advanced Techniques for Transforming Data into InsightsPaperbackFREE Shipping by AmazonGet it as soon as Wednesday, Jun 10
SQL Pocket Guide: A Guide to SQL UsagePaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Wednesday, Jun 10Only 18 left in stock (more on the way).
SQL Programming: a QuickStudy Laminated Reference GuideRobin NixonPamphletFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Wednesday, Jun 10
SQL Cookbook: Query Solutions and Techniques for All SQL UsersPaperbackFREE Shipping by AmazonGet it as soon as Wednesday, Jun 10
Customers also bought or read
- SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Paperback$36.49$36.49FREE delivery Wed, Jun 10 - SQL Cookbook: Query Solutions and Techniques for All SQL Users
Paperback$41.99$41.99FREE delivery Wed, Jun 10 - Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter
Paperback$43.99$43.99FREE delivery Wed, Jun 10 - SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach
Paperback$19.24$19.24Delivery Wed, Jun 10 - Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data#1 Best SellerSQL
Paperback$19.99$19.99Delivery Wed, Jun 10 - SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)
Paperback$21.26$21.26Delivery Wed, Jun 10 - Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Paperback$43.99$43.99FREE delivery Wed, Jun 10 - Database Design for Mere Mortals: 25th Anniversary Edition#1 Best SellerMicrosoft SQL Server
Paperback$36.43$36.43FREE delivery Wed, Jun 10 - SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Paperback$50.02$50.02FREE delivery Wed, Jun 10 - PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database
Paperback$39.54$39.54FREE delivery Wed, Jun 10 - Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Paperback$45.25$45.25FREE delivery Wed, Jun 10 - Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Probability, and Statistics
Paperback$37.10$37.10FREE delivery Wed, Jun 10 - Fluent Python: Clear, Concise, and Effective Programming
Paperback$43.99$43.99FREE delivery Wed, Jun 10 - Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Wed, Jun 10 - Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming#1 Best SellerIntroductory & Beginning Programming
Paperback$27.53$27.53Delivery Wed, Jun 10 - R for Data Science: Import, Tidy, Transform, Visualize, and Model Data#1 Best SellerMathematical & Statistical Software
Paperback$44.99$44.99FREE delivery Wed, Jun 10 - Introducing Python: Modern Computing in Simple Packages
Paperback$50.72$50.72FREE delivery Wed, Jun 10 - Eloquent JavaScript, 4th Edition#1 Best SellerJavaScript Programming
Paperback$27.70$27.70Delivery Wed, Jun 10 - SQL Performance Explained Everything Developers Need to Know about SQL Performance
Paperback$49.99$49.99FREE delivery Wed, Jun 10 - Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow: Concepts, Tools, and Techniques to Build Intelligent Systems
Paperback$49.50$49.50FREE delivery Wed, Jun 10 - Simple SQL: Beginner’s Guide To Master SQL And Boost Career (Zero To Hero)
Paperback$14.99$14.99$3.99 delivery Jun 12 - 29 - Python Data Science Handbook: Essential Tools for Working with Data
Paperback$44.18$44.18FREE delivery Wed, Jun 10 - Learning Git: A Hands-On and Visual Guide to the Basics of Git
Paperback$34.92$34.92Delivery Wed, Jun 10
From the brand
-
Explore our collection
-
More From O'Reilly
-
Sharing the knowledge of experts
O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.
Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.
From the Publisher
From the Preface
Programming languages come and go constantly, and very few languages in use today have roots going back more than a decade or so. Some examples are COBOL, which is still used quite heavily in mainframe environments; Java, which was born in the mid-1990s and has become one of the most popular programming languages; and C, which is still quite popular for operating systems and server development and for embedded systems. In the database arena, we have SQL, whose roots go all the way back to the 1970s.
SQL was initially created to be the language for generating, manipulating, and retrieving data from relational databases, which have been around for more than 40 years. Over the past decade or so, however, other data platforms such as Hadoop, Spark, and NoSQL have gained a great deal of traction, eating away at the relational database market.
As will be discussed in the last few chapters of this book, however, the SQL language has been evolving to facilitate the retrieval of data from various platforms, regardless of whether the data is stored in tables, documents, or flat files.
Why Learn SQL?
Whether you will be using a relational database or not, if you are working in data science, business intelligence, or some other facet of data analysis, you will likely need to know SQL, along with other languages/platforms such as Python & R. Data is everywhere, in huge quantities, and arriving at a rapid pace, & people who can extract meaningful information from all this data are in big demand.
Why Use This Book to Do It?
There are plenty of books out there that treat you like an idiot, or some other flavor of simpleton, but these books tend to just skim the surface. At the other end of the spectrum are reference guides that detail every permutation of every statement in a language, which can be useful if you already have a good idea of what you want to do but just need the syntax. This book strives to find the middle ground, starting with some background of the SQL language, moving through the basics, and then progressing into some of the more advanced features that will allow you to really shine. Additionally, this book ends with a chapter showing how to query data in nonrelational databases, which is a topic rarely covered in introductory books.
Editorial Reviews
About the Author
Product details
- Publisher : O'Reilly Media
- Publication date : April 21, 2020
- Edition : 3rd
- Language : English
- Print length : 377 pages
- ISBN-10 : 1492057614
- ISBN-13 : 978-1492057611
- Item Weight : 1.35 pounds
- Dimensions : 7 x 1 x 9.25 inches
- Best Sellers Rank: #55,411 in Books (See Top 100 in Books)
- #4 in Data Warehousing (Books)
- #4 in SQL
- #13 in Data Mining (Books)
- Customer Reviews:
About the authors

Discover more of the author’s books, see similar authors, read book recommendations and more.

Discover more of the author’s books, see similar authors, read book recommendations and more.
Customer reviews
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on AmazonCustomers say
Generated from the text of customer reviewsSelect to learn more
Top reviews from the United States
- 5 out of 5 stars
Excellent Book as a SQL noob; might struggle if complete SW noob
Reviewed in the United States on March 24, 2022I'm really enjoying this book. I have zero SQL experience, and have read up to chapter 9 in the book. If I browse StackOverflow for SQL related tags, I can understand a good number of the questions and have even been able to answer a couple (a lot of the questions are people trying to figure out how to write a query to get a specific result).
I think the book is very well written, and there are plenty of examples in each chapter. The book uses MySQL and I elected to use Postgres (you can find a sakila port on github) to intentionally run into errors and struggle. Outside of some MySQL and Oracle specific stuff, you either directly use the code in Postgres or look at the Postgres documentation and figure out the syntax differences.
That being said, my biggest issue with the book is that there are not a lot of exercises. Each chapter only has 3. Also, because I have SW development experience I know how to use the cli. Someone without SW experience will install MySQL, try to follow the cli commands in MySQL shell and get frustrated by it not working. If that is you, you'll have to find the installation location of MySQL (or Postgres), go to the bin folder, which should have multiple exes, and add that location to your PATH environment variable. Then you should be able to run commands like mysql or psql from your command line terminal. I only mention this because I remember seeing a review where someone rated this book as 1 star and said the information was out of date.
34 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
So good that I wore out the print version
Reviewed in the United States on January 5, 2024Oreilly has always been great quality when it comes to technical topics but this book goes above and beyond. It is loaded to the gills with SQL info - everything from design, queries, DB admin, and more. This is the book you want on your bookshelf when dealing with MySQL/MariaDB databases. I find myself referencing this book daily in my job. It is THAT good.
Here is the Table of Contents:
Creating and Populating a Database
Query Primer
Filtering
Querying Multiple Tables
Working with Sets
Data Generation, Manipulation, and Conversion
Grouping and Aggregates
Subqueries
Joins Revisited
Conditional Logic
Transactions
Indexes and Constraints
Views
Metadata
Analytic Functions
Working with Large Databases
SQL and Big Data
For a book that is only 376 pages, it covers a TON of stuff. I highly recommend for anybody who touches MySQL or MariaDB databases.
16 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Learn to be a SQL Expert!
Reviewed in the United States on November 9, 2025Comprehensive and readable. Best audience is anyone who has been in tech for a couple of years but wants to learn SQL in depth or switch careers to DB admin.
2 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Very good for an introduction
Reviewed in the United States on August 17, 2024It is a really nice book for anyone who wants to begin in the SQL world and its nuances. Totally recommend!
Sending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Exactly what you woud expect.
Reviewed in the United States on July 3, 2025Like most O'Reilly products, clear concise and accurate.
One person found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Just learn SQL...
Reviewed in the United States on March 16, 2021As a Data Analyst and coming from a non-CS background, this is just the best SQL book, to begin with. Although, I have amassed some experience programming in a couple of Languages. Overall, loving this book and keep loving it...
29 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Excellent
Reviewed in the United States on November 10, 2024Very useful for beginners.
2 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again - 5 out of 5 stars
Excellent mid level book
Reviewed in the United States on February 16, 2021Excellent. Although this seems to be a book for someone who is slightly experienced with SQL coming into reading rather than a beginner. It is strange that the author does not use alias in his notation.
11 people found this helpfulSending feedback...Sending feedback...HelpfulThank you for your feedback.Sorry, we failed to record your vote. Please try againThanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Top reviews from other countries
Arturo Mata5 out of 5 starsIncomplete
Reviewed in Mexico on April 6, 2024Book starts at page 53

Book starts at page 53
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Ashweeni Bharde5 out of 5 starsGood product but packaging needs to be upgraded
Reviewed in India on February 9, 2026Good quality product received. The packaging needs to be upgraded, but the overall delivery experience and quality of book is good.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Fulgen1 out of 5 starsNo es serio
Reviewed in Spain on July 9, 2021Muy mal. Para empezar al libro que me entregaron le faltaban 15 páginas, esto no es serio cuando se está vendiendo por más de 40 euros un libro de tapa blanda de unas 350 páginas.
En cuanto al contenido en sí, no está mal PERO para un libro que ya va en su tercera edición y, de nuevo, tiene un precio de más de 40 euros, se espera un mayor cuidado y menos erratas. Por ejemplo en la página 11 (literalmente el primer ejemplo de consulta SQL), el nombre que se utiliza para referirse a una tabla no coincide con el nombre que se le había dado a esa tabla un par de páginas atrás... más erratas de este y otros estilos a lo largo del libro.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
Mari van Zyl5 out of 5 starsWorth every cent!!
Reviewed in Australia on December 28, 2025Excellent read
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again
David Leonardo Galasso5 out of 5 starsNice
Reviewed in Italy on April 13, 2021Gives a complete overview of the language, to know the texture of the setup ambience.
Sending feedback...Thanks, we'll investigate in the next few days.Sorry, We failed to report this review. Please try again














