SQL for Data Analytics

Table of Contents

Understanding and Describing Data
The Basics of SQL for Analytics
SQL for Data Preparation
Aggregate Functions for Data Analysis
Window Functions for Data Analysis
Importing and Exporting Data
Analytics Using Complex Data Types
Performant SQL
Using SQL to Uncover the Truth - A Case Study

Upom Malik is a data scientist who has worked in the technology industry for over 6 years. He has a master’s degree in chemical engineering from Cornell University and a bachelor’s degree in biochemistry from Duke University. He uses SQL and other tools to solve interesting challenges in finance, energy, and consumer technologies. While working on analytical problems, he has lived out of a suitcase and spent the last year as a digital nomad. Outside of work, he likes to read, hike the trails of the Northeastern United States, and savor ramen bowls from around the world. Matt Goldwasser is a lead data scientist at T. Rowe Price. He enjoys demystifying data science for business stakeholders and deploying production machine learning solutions. Matt has been using SQL to perform data analytics in the financial industry for the last 8 years. He has a bachelor’s degree in mechanical and aerospace engineering from Cornell University. In his spare time, he enjoys teaching his infant son data science. 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 PhD in machine learning, specializing in image processing and deep convolutional neural networks. He has more than 10 years’ 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.