Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL by Kandarpa, Raghav
Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL by Kandarpa, Raghav

Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL

Become a data wrangling expert and make well-informed decisions by effectively utilizing and analyzing raw unstructured data...
$99.34 SGD
$99.34 SGD
SKU: 9781837630028
Product Type: Books
Please hurry! Only 396 left in stock
Author: Raghav Kandarpa
Format: Paperback
Language: English
Subtotal: $99.34
10 customers are viewing this product
Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL by Kandarpa, Raghav

Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL

$99.34
Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL by Kandarpa, Raghav

Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL

$99.34
Author: Raghav Kandarpa
Format: Paperback
Language: English
Description

Become a data wrangling expert and make well-informed decisions by effectively utilizing and analyzing raw unstructured data in a systematic manner

Purchase of the print or Kindle book includes a free PDF eBook


Key Features:

  • Implement query optimization during data wrangling using the SQL language with practical use cases
  • Master data cleaning, handle the date function and null value, and write subqueries and window functions
  • Practice self-assessment questions for SQL-based interviews and real-world case study rounds


Book Description:

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.


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


Who this book is for:

This book is for data analysts looking for effective hands-on methods to manage and analyze large volumes of data using SQL. The book will also benefit data scientists, product managers, and basically any role wherein you are expected to gather data insights and develop business strategies using SQL as a language. If you are new to or have basic knowledge of SQL and databases and an understanding of data cleaning practices, this book will give you further insights into how you can apply SQL concepts to build clean, standardized data models for accurate analysis.

Author: Raghav Kandarpa, Shivangi Saxena
Publisher: Packt Publishing
Published: 07/31/2023
Pages: 350
Binding Type: Paperback
Weight: 1.33lbs
Size: 9.25h x 7.50w x 0.73d
ISBN: 9781837630028

This title is not returnable

Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review

Related Products

Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD
Example product title
$99.34 SGD
$99.34 SGD

Recently Viewed Products