Book Image

Data Wrangling with SQL

By : Raghav Kandarpa, Shivangi Saxena
Book Image

Data Wrangling with SQL

By: Raghav Kandarpa, Shivangi Saxena

Overview of this book

The amount of data generated continues to grow rapidly, making it increasingly important for businesses to be able to wrangle this data and understand it quickly and efficiently. Although data wrangling can be challenging, with the right tools and techniques you can efficiently handle enormous amounts of unstructured data. The 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.
Table of Contents (21 chapters)
1
Part 1:Data Wrangling Introduction
4
Part 2:Data Wrangling Techniques Using SQL
9
Part 3:SQL Subqueries, Aggregate And Window Functions
13
Part 4:Optimizing Query Performance
15
Part 5:Data Science And Wrangling

1

About the GCP Professional Cloud Security Engineer Exam

The rate of migration to the cloud is growing exponentially. The cloud is something of a Masai Mara right now, and we don’t expect that this will slow down. New projects are often now born in the cloud and end up staying there.

Note

The Masai Mara is an iconic African savanna landscape characterized by an annual wildebeest and zebra migration of over 1.5 million animals.

This growing trend has created new opportunities, specifically for cloud security. There is now soaring demand for cloud security professionals. It is not news to those in the field of cybersecurity that cloud security skills are not only in demand but scarce. Cybersecurity professionals with cloud security skills are now very sought after. Security used to be the number one obstacle to organizations moving to the cloud. Now, security is the top reason that organizations want to move to the cloud. This only increases the demand for cloud security...