Learning SQL: Generate, Manipulate, and Retrieve Data
Original price was: $65.99.$32.83Current price is: $32.83.
Related Products
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
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.
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: #78,637 in Books (See Top 100 in Books) #3 in Data Warehousing (Books) #4 in SQL #20 in Data Mining (Books)
Customer Reviews: 4.6 4.6 out of 5 stars (555) var dpAcrHasRegisteredArcLinkClickAction; P.when(‘A’, ‘ready’).execute(function(A) { if (dpAcrHasRegisteredArcLinkClickAction !== true) { dpAcrHasRegisteredArcLinkClickAction = true; A.declarative( ‘acrLink-click-metrics’, ‘click’, { “allowLinkDefault”: true }, function (event) { if (window.ue) { ue.count(“acrLinkClickCount”, (ue.count(“acrLinkClickCount”) || 0) + 1); } } ); } }); P.when(‘A’, ‘cf’).execute(function(A) { A.declarative(‘acrStarsLink-click-metrics’, ‘click’, { “allowLinkDefault” : true }, function(event){ if(window.ue) { ue.count(“acrStarsLinkWithPopoverClickCount”, (ue.count(“acrStarsLinkWithPopoverClickCount”) || 0) + 1); } }); });
13 reviews for Learning SQL: Generate, Manipulate, and Retrieve Data
Add a review
Original price was: $65.99.$32.83Current price is: $32.83.
Mexicano Afortunado –
Learn to be a SQL Expert!
Comprehensive 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.
Peter George –
Excellent Book as a SQL noob; might struggle if complete SW noob
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.
Gordon Ewasiuk –
So good that I wore out the print version
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.
CajunCoder –
Exactly what you woud expect.
Like most O’Reilly products, clear concise and accurate.
Kindle Customer –
Very good for an introduction
It is a really nice book for anyone who wants to begin in the SQL world and its nuances. Totally recommend!
Antonio J. Ruiz –
Excellent
Very useful for beginners.
Giorgi –
Great
Great but it needs more basics
Pen Name –
Abstract and Concrete Enough
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.
Arturo Mata –
Book starts at page 53
Fulgen –
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.
this book contains the base of knowledge and it explains clearly all the concepts of mysql, 10/10 –
this book is awesome for those whom are looking for the correct information to start learning mysql from basics
MUKUL LATIYAN –
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.
David Leonardo Galasso –
Gives a complete overview of the language, to know the texture of the setup ambience.