0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

SQL for Data Analytics

You're reading from SQL for Data Analytics Perform fast and efficient data analysis with the power of SQL

Product type Paperback

Published in Aug 2019

Publisher Packt

ISBN-13 9781789807356

Length 386 pages

Edition 1st Edition

Languages

SQL

Tools

PostgreSQL

Concepts

Data Analysis

Authors (3):

Benjamin Johnston

Matt Goldwasser

Upom Malik

View More author details

Table of Contents (11) Chapters

Preface

About the Book

1. Understanding and Describing Data

2. The Basics of SQL for Analytics FREE CHAPTER

3. SQL for Data Preparation

4. Aggregate Functions for Data Analysis

5. Window Functions for Data Analysis

6. Importing and Exporting Data

7. Analytics Using Complex Data Types

8. Performant SQL

9. Using SQL to Uncover the Truth – a Case Study

Appendix

5. Window Functions for Data Analysis

Learning Objectives

By the end of this chapter, you will be able to:

Explain what a window function is
Write basic window functions
Use common window functions to calculate statistics
Analyze sales data using window functions and a window frame

In this chapter, we will cover window functions, functions similar to an aggregate function but that allow a new range of capabilities and insights.

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (3)

Upom Malik

Upom Malik

Upom Malik is a data science and analytics leader who has worked in the technology industry for over 8 years. He has a master's degree in chemical engineering from Cornell University and a bachelor's degree in biochemistry from Duke University. As a data scientist, Upom has overseen efforts across machine learning, experimentation, and analytics at various companies across the United States. He uses SQL and other tools to solve interesting challenges in finance, energy, and consumer technology. Outside of work, he likes to read, hike the trails of the Northeastern United States, and savor ramen bowls from around the world.

See other products by Upom Malik

Matt Goldwasser

Matt Goldwasser

Matt Goldwasser is the Head of Applied Data Science at the T. Rowe Price NYC Technology Development Center. Prior to his current role, Matt was a data science manager at OnDeck, and prior to that, he was an analyst at Millennium Management. Matt holds a bachelor of science in mechanical and aerospace engineering from Cornell University.

See other products by Matt Goldwasser

Benjamin Johnston

Benjamin Johnston

Benjamin Johnston is a senior data scientist for one of the world's leading data-driven MedTech companies and is involved in the development of innovative digital solutions throughout the entire product development pathway, from problem definition to solution research and development, through to final deployment. He is currently completing his Ph.D. in machine learning, specializing in image processing and deep convolutional neural networks. He has more than 10 years of experience in medical device design and development, working in a variety of technical roles, and holds first-class honors bachelor's degrees in both engineering and medical science from the University of Sydney, Australia.

See other products by Benjamin Johnston

Other recommended products

Related to this chapter

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it’s importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Jul 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it’s importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Jul 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it’s importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Jul 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it's importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Feb 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it's importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Feb 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it's importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Feb 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it's importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Feb 2020 16h 8m

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop

The Applied SQL Data Analytics Workshop is the ideal companion on your journey to extracting information from raw business data. Whether it's importing data, analyzing complex data types, or optimizing your queries, this book equips you with the skills you need to build your knowledge in data analysis with SQL.

Feb 2020 16h 8m

The SQL Workshop

The SQL Workshop

Filled with practical examples and realistic exercises, The SQL Workshop will get you up to speed with the fundamentals of SQL. You'll learn how to use SQL queries and functions to create and manage relational databases, and apply your new skills to creatively solve real-world problems.

Dec 2019 9h 36m

The SQL Workshop

The SQL Workshop

Filled with practical examples and realistic exercises, The SQL Workshop will get you up to speed with the fundamentals of SQL. You'll learn how to use SQL queries and functions to create and manage relational databases, and apply your new skills to creatively solve real-world problems.

Dec 2019 9h 36m

The SQL Workshop

The SQL Workshop

Filled with practical examples and realistic exercises, The SQL Workshop will get you up to speed with the fundamentals of SQL. You'll learn how to use SQL queries and functions to create and manage relational databases, and apply your new skills to creatively solve real-world problems.

Dec 2019 9h 36m

The SQL Workshop

The SQL Workshop

Filled with practical examples and realistic exercises, The SQL Workshop will get you up to speed with the fundamentals of SQL. You'll learn how to use SQL queries and functions to create and manage relational databases, and apply your new skills to creatively solve real-world problems.

Dec 2019 9h 36m

Personalised recommendations for you

Based on your interests and search pattern

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m