Deliver toUnited Arab Emirates
Learning SQL: Generate, Manipulate, and Retrieve Data

Description:

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


Editorial Reviews

About the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 25 years. He is the author of Learning SQL and Mastering Oracle SQL (O’Reilly), and has written an online course on SQL for the University of California. He currently runs his own consulting company that specializes in database design and development in the fields of Financial Services and Telecommunications. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

Reviews:

5.0 out of 5 stars Excellent Book as a SQL noob; might struggle if complete SW noob

P.G. · March 24, 2022

I'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.

5.0 out of 5 stars So good that I wore out the print version

G.E. · January 5, 2024

Oreilly 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 DatabaseQuery PrimerFilteringQuerying Multiple TablesWorking with SetsData Generation, Manipulation, and ConversionGrouping and AggregatesSubqueriesJoins RevisitedConditional LogicTransactionsIndexes and ConstraintsViewsMetadataAnalytic FunctionsWorking with Large DatabasesSQL and Big DataFor a book that is only 376 pages, it covers a TON of stuff. I highly recommend for anybody who touches MySQL or MariaDB databases.

5.0 out of 5 stars Exactly what you woud expect.

C. · July 3, 2025

Like most O'Reilly products, clear concise and accurate.

5.0 out of 5 stars Very good for an introduction

K.C. · August 17, 2024

It is a really nice book for anyone who wants to begin in the SQL world and its nuances. Totally recommend!

5.0 out of 5 stars Excellent

A.J.R. · November 10, 2024

Very useful for beginners.

5.0 out of 5 stars Great

G. · July 30, 2023

Great but it needs more basics

5.0 out of 5 stars Abstract and Concrete Enough

P.N. · June 11, 2020

Used for work to expand my SQL knowledge. The book uses MySQL as its practice, but provides concepts of what can be done in MS or Oracle as well. It sticks with concepts and includes practice. Learners like myself need both.

5.0 out of 5 stars Just learn SQL...

B.O. · March 16, 2021

As 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...

Incomplete

A.M. · April 6, 2024

Book starts at page 53

No es serio

F. · July 9, 2021

Muy 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.

info clear

t.b.c.t.b.o.k.a.i.e.c.a.t.c.o.m.1. · February 25, 2025

this book is awesome for those whom are looking for the correct information to start learning mysql from basics

Perfect(Almost).

M.L. · August 2, 2025

Having been in the industry for almost 8 years now, this book is such a nice refreshment, which takes things from the ground up to the most commonly faced issues or strategies to follow when it comes to MySQL. A must read, I must say.

Nice

D.L.G. · April 13, 2021

Gives a complete overview of the language, to know the texture of the setup ambience.

Learning SQL: Generate, Manipulate, and Retrieve Data

Product ID: U1492057614
Condition: New

4.6

AED27497

Price includes VAT & Import Duties
Type: Paperback
Availability: In Stock

Quantity:

|

Order today to get by 7-14 business days

This item qualifies for free delivery

Returns & Warranty policies

Imported From: United States

At BOLO, we work hard to ensure the products you receive are new, genuine, and sourced from reputable suppliers.

BOLO is not an authorized or official retailer for most brands, nor are we affiliated with manufacturers unless specifically stated on a product page. Instead, we source verified sellers, authorized distributors or directly from the manufacturer.

Each product undergoes thorough inspection and verification at our consolidation and fulfilment centers to ensure it meets our strict authenticity and quality standards before being shipped and delivered to you.

If you ever have concerns regarding the authenticity of a product purchased from us, please contact Bolo Support. We will review your inquiry promptly and, if necessary, provide documentation verifying authenticity or offer a suitable resolution.

Your trust is our top priority, and we are committed to maintaining transparency and integrity in every transaction.

All product information, images, descriptions, and reviews originate from the manufacturer or from trusted sellers overseas. BOLO is not affiliated with, endorsed by, or an authorized retailer for most brands listed on our website unless stated otherwise.

While we strive to display accurate information, variations in packaging, labeling, instructions, or formulation may occasionally occur due to regional differences or supplier updates. For detailed or manufacturer-specific information, please contact the brand directly or reach out to BOLO Support for assistance.

Unless otherwise stated, all prices displayed on the product page include applicable taxes and import duties.

BOLO operates in accordance with the laws and regulations of United Arab Emirates. Any items found to be restricted or prohibited for sale within the UAE will be cancelled prior to shipment. We take proactive measures to ensure that only products permitted for sale in United Arab Emirates are listed on our website.

All items are shipped by air, and any products classified as “Dangerous Goods (DG)” under IATA regulations will be removed from the order and cancelled.

All orders are processed manually, and we make every effort to process them promptly once confirmed. Products cancelled due to the above reasons will be permanently removed from listings across the website.

Similar suggestions by Bolo

More from this brand

Similar items from “Data Modeling & Design”

Learning SQL: Generate, Manipulate, and Retrieve Data

Product ID: U1492057614
Condition: New

4.6

Learning SQL: Generate, Manipulate, and Retrieve Data-0
Type: Paperback

AED27497

Price includes VAT & Import Duties
Availability: In Stock

Quantity:

|

Order today to get by 7-14 business days

This item qualifies for free delivery

Returns & Warranty policies

Imported From: United States

At BOLO, we work hard to ensure the products you receive are new, genuine, and sourced from reputable suppliers.

BOLO is not an authorized or official retailer for most brands, nor are we affiliated with manufacturers unless specifically stated on a product page. Instead, we source verified sellers, authorized distributors or directly from the manufacturer.

Each product undergoes thorough inspection and verification at our consolidation and fulfilment centers to ensure it meets our strict authenticity and quality standards before being shipped and delivered to you.

If you ever have concerns regarding the authenticity of a product purchased from us, please contact Bolo Support. We will review your inquiry promptly and, if necessary, provide documentation verifying authenticity or offer a suitable resolution.

Your trust is our top priority, and we are committed to maintaining transparency and integrity in every transaction.

All product information, images, descriptions, and reviews originate from the manufacturer or from trusted sellers overseas. BOLO is not affiliated with, endorsed by, or an authorized retailer for most brands listed on our website unless stated otherwise.

While we strive to display accurate information, variations in packaging, labeling, instructions, or formulation may occasionally occur due to regional differences or supplier updates. For detailed or manufacturer-specific information, please contact the brand directly or reach out to BOLO Support for assistance.

Unless otherwise stated, all prices displayed on the product page include applicable taxes and import duties.

BOLO operates in accordance with the laws and regulations of United Arab Emirates. Any items found to be restricted or prohibited for sale within the UAE will be cancelled prior to shipment. We take proactive measures to ensure that only products permitted for sale in United Arab Emirates are listed on our website.

All items are shipped by air, and any products classified as “Dangerous Goods (DG)” under IATA regulations will be removed from the order and cancelled.

All orders are processed manually, and we make every effort to process them promptly once confirmed. Products cancelled due to the above reasons will be permanently removed from listings across the website.

Description:

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


Editorial Reviews

About the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 25 years. He is the author of Learning SQL and Mastering Oracle SQL (O’Reilly), and has written an online course on SQL for the University of California. He currently runs his own consulting company that specializes in database design and development in the fields of Financial Services and Telecommunications. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

Reviews:

5.0 out of 5 stars Excellent Book as a SQL noob; might struggle if complete SW noob

P.G. · March 24, 2022

I'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.

5.0 out of 5 stars So good that I wore out the print version

G.E. · January 5, 2024

Oreilly 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 DatabaseQuery PrimerFilteringQuerying Multiple TablesWorking with SetsData Generation, Manipulation, and ConversionGrouping and AggregatesSubqueriesJoins RevisitedConditional LogicTransactionsIndexes and ConstraintsViewsMetadataAnalytic FunctionsWorking with Large DatabasesSQL and Big DataFor a book that is only 376 pages, it covers a TON of stuff. I highly recommend for anybody who touches MySQL or MariaDB databases.

5.0 out of 5 stars Exactly what you woud expect.

C. · July 3, 2025

Like most O'Reilly products, clear concise and accurate.

5.0 out of 5 stars Very good for an introduction

K.C. · August 17, 2024

It is a really nice book for anyone who wants to begin in the SQL world and its nuances. Totally recommend!

5.0 out of 5 stars Excellent

A.J.R. · November 10, 2024

Very useful for beginners.

5.0 out of 5 stars Great

G. · July 30, 2023

Great but it needs more basics

5.0 out of 5 stars Abstract and Concrete Enough

P.N. · June 11, 2020

Used for work to expand my SQL knowledge. The book uses MySQL as its practice, but provides concepts of what can be done in MS or Oracle as well. It sticks with concepts and includes practice. Learners like myself need both.

5.0 out of 5 stars Just learn SQL...

B.O. · March 16, 2021

As 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...

Incomplete

A.M. · April 6, 2024

Book starts at page 53

No es serio

F. · July 9, 2021

Muy 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.

info clear

t.b.c.t.b.o.k.a.i.e.c.a.t.c.o.m.1. · February 25, 2025

this book is awesome for those whom are looking for the correct information to start learning mysql from basics

Perfect(Almost).

M.L. · August 2, 2025

Having been in the industry for almost 8 years now, this book is such a nice refreshment, which takes things from the ground up to the most commonly faced issues or strategies to follow when it comes to MySQL. A must read, I must say.

Nice

D.L.G. · April 13, 2021

Gives a complete overview of the language, to know the texture of the setup ambience.

Similar suggestions by Bolo

More from this brand

Similar items from “Data Modeling & Design”