Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
- 7h 29m 25s
- Alan Beaulieu
- Gildan Media
- 2023
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
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.
In this Audiobook
-
Chapter 1 - “A Little Background”
-
Chapter 2 - “Creating and Populating a Database”
-
Chapter 3 - “Query Primer”
-
Chapter 4 - “Filtering”
-
Chapter 5 - “Querying Multiple Tables”
-
Chapter 6 - “Working with Sets”
-
Chapter 7 - “Data Generation, Manipulation, and Conversion”
-
Chapter 8 - “Grouping and Aggregates”
-
Chapter 9 - “Subqueries”
-
Chapter 10 - “Joins Revisited”
-
Chapter 11 - “Conditional Logic”
-
Chapter 12 - “Transactions”
-
Chapter 13 - “Indexes and Constraints”
-
Chapter 14 - “Views”
-
Chapter 15 - “Metadata”
-
Chapter 16 - “Analytic Functions”
-
Chapter 17 - “Working with Large Databases”
-
Chapter 18 - “SQL and Big Data”
