What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

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

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.

Who is this book 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.

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

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

Exploratory Data Analysis with Python Cookbook

Can$65.99

SQL Query Design Patterns and Best Practices

Can$46.99

Can$49.99

Total Can$ 162.97

Paras Madan Oct 26, 2023

This book is a must buy for everyone who is in tech, whether you are starting up or already in the field, this book is an essential. The author starts from basic and takes it to a level which is the standard across all top Tech Companies. You should buy this book before having a second thought 💯

Amazon Verified review

robnmel Dec 24, 2023

This is a great book for everyone getting started or wanted to up-skill in SQL. These real world examples can help you learn SQL in practical ways. Raghav & Shivangi share the best tips and tricks from their great personal studies & work experience. Get your data journey going with this book. 🙌☕️

Amazon Verified review

Anirudh R Aug 06, 2024

Data Wrangling with SQL: A Hands-On Guide to Manipulating, Wrangling, and Engineering Data Using SQL" is an invaluable resource for both budding and seasoned data professionals. The book excels in its clarity and practical approach, making complex SQL techniques accessible to readers at various skill levels.The hands-on exercises are well-designed, allowing readers to apply concepts in real-world scenarios, which reinforces learning and builds confidence. The book covers a comprehensive range of topics, from fundamental data manipulation to advanced data engineering, all while maintaining a clear and structured narrative.What sets this guide apart is its balance between theory and practice. It not only explains the 'how' but also delves into the 'why,' providing readers with a deeper understanding of SQL's capabilities. The examples are relevant and diverse, reflecting actual industry challenges and use cases.Overall, "Data Wrangling with SQL" is a practical and engaging guide that equips readers with essential skills for effective data management and manipulation. It’s a must-have for anyone looking to enhance their SQL proficiency and tackle data-driven problems with confidence.

Amazon Verified review

Om S Aug 11, 2023

"Data Wrangling with SQL" is a practical guide that equips data analysts and professionals with essential tools for navigating the complexities of data wrangling. The book strikes a balance between theory and real-world application, making it a valuable resource for both beginners and experienced users of SQL.The book starts with a solid introduction to SQL fundamentals, laying a strong foundation for data wrangling techniques. Advanced topics like aggregate functions, window functions, CTEs, and subqueries are explored in depth, providing readers with the expertise to manipulate data effectively.One standout feature is the emphasis on query optimization, often overlooked in data transformation. Through practical examples, readers learn to streamline queries, enhancing the efficiency of the data transformation process. The inclusion of self-assessment questions adds a practical dimension, aiding readers in preparing for SQL-based interviews.Real-world datasets and examples enrich the learning experience, bridging the gap between theory and practice. The book covers a range of aspects, from data profiling and null value handling to outlier detection and time series modeling, ensuring a well-rounded skill set."Data Wrangling with SQL" caters to a diverse audience, including data analysts, scientists, and professionals involved in data-driven decision-making. It provides actionable insights, enabling efficient data handling and informed strategic choices.

Amazon Verified review

Abhishek Bhalerao Oct 11, 2023

I recently had the opportunity to read this book and I must say, it truly lives up to its title. This book is an absolute gem for anyone looking to dive into the world of SQL.From the very first chapter, the author does an excellent job of explaining SQL concepts in a clear and concise manner, making it easy for beginners to grasp the fundamentals. The book is well-structured, with each chapter building upon the previous one, ensuring a smooth learning curve throughout.One thing I particularly appreciated about this book is the practical approach it takes. This hands-on approach really helped solidify my knowledge and gave me the confidence to tackle SQL projects on my own.Another highlight of this book is its comprehensive coverage of SQL topics. It covers everything from basic querying to more advanced topics like joins, subqueries, and database management. Whether you're a complete beginner or already have some SQL knowledge, this book has something to offer for everyone.Overall, I highly recommend to anyone who wants to learn SQL or strengthen their existing knowledge. It's an invaluable resource that will equip you with the skills needed to effectively work with databases.

Amazon Verified review

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

What do you get with eBook?