Loading...
Ebook details
Log in if you are interested in the contents of the item.
SQL for Data Analytics. Analyze data effectively, uncover insights and master advanced SQL for real-world applications - Fourth Edition
Jun Shan, Haibin Li, Matt Goldwasser, Upom Malik, Benjamin Johnston
Loading...
EBOOK
Loading...
SQL remains one of the most essential tools for modern data analysis and mastering it can set you apart in a competitive data landscape. This book helps you go beyond basic query writing to develop a deep, practical understanding of how SQL powers real-world decision-making.
SQL for Data Analytics, Fourth Edition, is for anyone who wants to go beyond basic SQL syntax and confidently analyze real-world data. Whether you're trying to make sense of production data for the first time or upgrading your analytics toolkit, this book gives you the skills to turn data into actionable outcomes.
You'll start by creating and managing structured databases before advancing to data retrieval, transformation, and summarization. From there, you’ll take on more complex tasks such as window functions, statistical operations, and analyzing geospatial, time-series, and text data. With hands-on exercises, case studies, and detailed guidance throughout, this book prepares you to apply SQL in everyday business contexts, whether you're cleaning data, building dashboards, or presenting findings to stakeholders. By the end, you'll have a powerful SQL toolkit that translates directly to the work analysts do every day.
*Email sign-up and proof of purchase required
SQL for Data Analytics, Fourth Edition, is for anyone who wants to go beyond basic SQL syntax and confidently analyze real-world data. Whether you're trying to make sense of production data for the first time or upgrading your analytics toolkit, this book gives you the skills to turn data into actionable outcomes.
You'll start by creating and managing structured databases before advancing to data retrieval, transformation, and summarization. From there, you’ll take on more complex tasks such as window functions, statistical operations, and analyzing geospatial, time-series, and text data. With hands-on exercises, case studies, and detailed guidance throughout, this book prepares you to apply SQL in everyday business contexts, whether you're cleaning data, building dashboards, or presenting findings to stakeholders. By the end, you'll have a powerful SQL toolkit that translates directly to the work analysts do every day.
*Email sign-up and proof of purchase required
- 1. Introduction to Data Management Systems
- 2. Creating Tables with Solid Structures
- 3. Exchanging Data Using COPY
- 4. Manipulating Data with Python
- 5. Presenting Data with SELECT
- 6. Transforming and Updating Data
- 7. Defining Datasets from Existing Datasets
- 8. Aggregating Data with GROUP BY
- 9. Inter-Row Operation with Window Functions
- 10. Performant SQL
- 11. Processing JSON and Arrays
- 12. Advanced Data Types: Date, Text, and Geospatial
- 13. Inferential Statistics Using SQL
- 14. A Case Study for Analytics Using SQL
- Title:SQL for Data Analytics. Analyze data effectively, uncover insights and master advanced SQL for real-world applications - Fourth Edition
- Author:Jun Shan, Haibin Li, Matt Goldwasser, Upom Malik, Benjamin Johnston
- Original title:SQL for Data Analytics. Analyze data effectively, uncover insights and master advanced SQL for real-world applications - Fourth Edition
- ISBN:9781836646242, 9781836646242
- Date of issue:2025-11-21
- Format:Ebook
- Item ID: e_4inp
- Publisher: Packt Publishing
Loading...
Loading...