Learning SQL: Generate, Manipulate, and Retrieve Data

by Alan Beaulieu

Overview

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

Product Details

ISBN-13:	9781492057611
Publisher:	O'Reilly Media, Incorporated
Publication date:	03/31/2020
Edition description:	3rd ed.
Pages:	377
Sales rank:	434,352
Product dimensions:	9.10(w) x 7.00(h) x 0.90(d)

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 UniversitySchool of Engineering. He lives in Massachusetts with his wife and two daughters.

Table of Contents

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. 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 and can be reached at [e-mail].

Editorial Reviews

The Barnes & Noble Review
Don’t just skim SQL’s surface: Gain a real understanding of what it can do -- in less than 300 pages.

Alan Beaulieu’s Learning SQL starts with all the background you need: No SQL or database experience is required. In the first few chapters, you’ll walk through creating and populating your first database. (Download MySQL and follow along.) You’ll write basic queries, filter data, query multiple tables, work with sets, use built-in functions. Gradually, you’ll move to more complex tasks: grouping, aggregates, and subqueries; even joins, transactions, and indexes.

Beaulieu’s examples are tested with MySQL, Oracle, and SQL Server (and should work fine with most recent databases). The result: a book that’ll work in any environment, whether you’re building applications, working as an admin, or just trying to coax a database into coughing up the right information. Bill Camarda, from the November 2005 Read Only

bn.com