Learning SQL, Alan Beaulieu
Learning SQL, Alan Beaulieu
List: $24.99 | Sale: $17.50
Club: $12.49

Learning SQL
Generate, Manipulate, and Retrieve Data, 3rd Edition

Author: Alan Beaulieu

Narrator: Mike Chamberlain

Unabridged: 7 hr 29 min

Format: Digital Audiobook Download

Publisher: Ascent Audio

Published: 03/21/2023

Includes: Bonus Material Bonus Material Included


Synopsis

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

Reviews

Goodreads review by Stephen on February 26, 2024

An excellent overview/review of key SQL concepts. The text and examples are based on MySQL, though much of the information is based on Standard SQL, and the author calls out MS SQL and Oracle differences. There isn't a lot of mention of PostgresSQL, though what's based on the standard syntax is gene......more

Goodreads review by Tom on July 21, 2013

I already knew SQL and was able to write queries with joins, where clauses, etc. I was also able to read and understand stored procedures and functions, but I wanted a refresher and was curious about what I didn't know/use. I also wanted to bring myself up to speed on improving the formats of my que......more

Goodreads review by Alex on May 09, 2015

For my purposes, this was a fantastic book. I can understand that mileage may vary if you are a DBA or need to get into great depth on a specific database and the intricacies of its syntax, but as a general overview to relational databases and SQL, this is an excellent resource. If you work with sof......more

Goodreads review by Aaron on July 11, 2021

Read the 3rd edition. Had a surface-level understanding of SQL going in and wanted a more structured walkthrough of the language, especially w.r.t. querying. The treatment of querying was quite good. I'd only suggest more on query optimization (there's a couple of other advanced topics I felt could b......more

Goodreads review by Michael on October 07, 2021

Nice SQL refresher......more