Items related to Data Wrangling with SQL: A hands-on guide to manipulating,...

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

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

Synopsis

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.

Table of Contents

  1. Database Introduction
  2. Data Profiling and Preparation before Data Wrangling
  3. Data Wrangling on String Data Types
  4. Data Wrangling on the DATE Data Type
  5. Handling NULL values
  6. Pivoting Data Using SQL
  7. Subqueries and CTEs
  8. Aggregate Functions
  9. SQL Window Functions
  10. Optimizing Query Performance
  11. Descriptive Statistics with SQL
  12. Time Series with SQL
  13. Outlier Detection

"synopsis" may belong to another edition of this title.

About the Author

Raghav Kandarpa is an experienced Data Scientist in Finance and logistics industry with expertise in SQL, Python, Building Machine Learning Models, Financial Data Modelling, and Statistical Analysis. He holds a Masters’ degree in Business Analytics specializing in Data Science from the University of Texas at Dallas.

Shivangi Saxena is an experienced BI Engineer with proficiency in SQL, Data Visualization, and Statistical Analysis. She holds a master’s degree in Information Technology and Management from the University of Texas at Dallas. She has several years of experience building several BI tools and products using SQL and BI reporting tools which has helped stakeholders to get visibility to the right data points

"About this title" may belong to another edition of this title.

  • PublisherPackt Publishing
  • Publication date2023
  • ISBN 10 183763002X
  • ISBN 13 9781837630028
  • BindingPaperback
  • LanguageEnglish
  • Edition number1
  • Number of pages350

Buy Used

Condition: Very Good
Minor scuffing on cover.
View this item

US$ 3.99 shipping within U.S.A.

Destination, rates & speeds

Search results for Data Wrangling with SQL: A hands-on guide to manipulating,...

Stock Image

Kandarpa, Raghav,Saxena, Shivangi
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
Used paperback

Seller: Books From California, Simi Valley, CA, U.S.A.

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

paperback. Condition: Very Good. Minor scuffing on cover. Seller Inventory # mon0003665556

Contact seller

Buy Used

US$ 30.15
Convert currency
Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Raghav Kandarpa; Shivangi Saxena
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 46207467-n

Contact seller

Buy New

US$ 38.35
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Raghav Kandarpa; Shivangi Saxena
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New Softcover

Seller: California Books, Miami, FL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # I-9781837630028

Contact seller

Buy New

US$ 41.00
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Kandarpa, Raghav
Published by Packt Publishing 7/31/2023, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New Paperback or Softback

Seller: BargainBookStores, Grand Rapids, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback or Softback. Condition: New. Data Wrangling with SQL: A hands-on guide to manipulating, wrangling, and engineering data using SQL 1.33. Book. Seller Inventory # BBS-9781837630028

Contact seller

Buy New

US$ 41.09
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 5 available

Add to basket

Stock Image

Raghav Kandarpa; Shivangi Saxena
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
Used Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 46207467

Contact seller

Buy Used

US$ 43.39
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Raghav Kandarpa
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New PAP
Print on Demand

Seller: PBShop.store US, Wood Dale, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781837630028

Contact seller

Buy New

US$ 50.74
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Raghav Kandarpa
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New PAP
Print on Demand

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781837630028

Contact seller

Buy New

US$ 47.12
Convert currency
Shipping: US$ 6.82
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Raghav Kandarpa; Shivangi Saxena
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New Softcover

Seller: Ria Christie Collections, Uxbridge, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. In. Seller Inventory # ria9781837630028_new

Contact seller

Buy New

US$ 46.35
Convert currency
Shipping: US$ 16.27
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Raghav Kandarpa; Shivangi Saxena
Published by Packt Publishing, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 46207467-n

Contact seller

Buy New

US$ 46.33
Convert currency
Shipping: US$ 20.37
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Raghav Kandarpa
Published by Packt Publishing Limited, 2023
ISBN 10: 183763002X ISBN 13: 9781837630028
New Paperback / softback
Print on Demand

Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 526. Seller Inventory # C9781837630028

Contact seller

Buy New

US$ 52.40
Convert currency
Shipping: US$ 16.31
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

There are 7 more copies of this book

View all search results for this book