Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL
Raghav Kandarpa | Shivangi SaxenaThe book starts by introducing you to the basics of SQL, focusing on the core principles and techniques of data wrangling. You’ll then explore advanced SQL concepts like aggregate functions, window functions, CTEs, and subqueries that are very popular in the business world. The next set of chapters will walk you through different functions within SQL query that cause delays in data transformation and help you figure out the difference between a good query and bad one. You’ll also learn how data wrangling and data science go hand in hand. The book is filled with datasets and practical examples to help you understand the concepts thoroughly, along with best practices to guide you at every stage of data wrangling.
By the end of this book, you’ll be equipped with essential techniques and best practices for data wrangling, and will predominantly learn how to use clean and standardized data models to make informed decisions, helping businesses avoid costly mistakes.
What you will learn
Build time series models using data wrangling
Discover data wrangling best practices as well as tips and tricks
Find out how to use subqueries, window functions, CTEs, and aggregate functions
Handle missing data, data types, date formats, and redundant data
Build clean and efficient data models using data wrangling techniques
Remove outliers and calculate standard deviation to gauge the skewness of data