Book

SQL for Data Analytics

SQL for Data Analytics teaches everything you need to know to progress from basic SQL to identifying trends and creating compelling narratives with data. With this book, you will be able to look at data with the critical eye of an analytics professional and extract meaningful insights that will improve your business.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

12h52m

Language

English

About Book

Who Is This Book For?

If you’re a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.

Book content

chapters 12h52m total length

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

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required