Code: USD75OFF
This is the code repository for Data Wrangling with SQL, published by Packt.
A hands-on guide to manipulating, wrangling, and engineering data using SQL.
This book covers the following exciting features: 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
If you feel this book is for you, get your copy today!
All of the code is organized into folders. For example, Chapter01.
The code will look like the following:
{
Customer_ID int,
Name varchar(255),
Address varchar(255),Email varchar(255),
Phone varchar(255)
)
Following is what you need for this book: This book is for SQL developers, data analysts, report writers, data scientists, and other data gatherers looking to expand their skills for complex querying as well as for building more efficient and performant queries. For those new to SQL, this book can help you accelerate your learning and keep you from making common mistakes.
With the following software and hardware list you can run all code files present in the book (Chapter 1-13).
| Chapter | Software required | OS required |
|---|---|---|
| 1-13 | SQL database | Windows or macOS |
| 1-13 | MySQL | Windows or macOS |
| 1-13 | SQL Server (for some examples) | Windows or macOS |
Raghav Kandarpa, is a skilled author and data analyst passionate about extracting insights from complex datasets. Originally from India, he pursued his academic and professional goals in data analysis in the United States. With a master’s degree in business analysis, specializing in business intelligence and analytics, he possesses expertise in data-driven decision-making and advanced analytical techniques. Currently a lead data science analyst at a top Fortune 500 finance company, Raghav leverages data to drive strategic initiatives, delivering actionable recommendations and optimizing business operations. Alongside his professional achievements, he is dedicated to empowering aspiring data analysts through practical writing that bridges the gap between theory and practice. Raghav’s commitment to innovation, data-driven decision-making, and knowledge sharing continues to shape the future of data analysis in finance and beyond.
Shivangi Saxena, a highly accomplished data analyst and Business Intelligence Engineer with over six years of experience, relocated from India to the United States to pursue a master’s degree in information technology and management, specializing in business intelligence and analytics. She quickly became a valuable asset in the industry, leveraging data to drive strategic business decisions with her strong analytical mindset and passion for technology. Currently working with a top Fortune 500 company, Shivangi excels in data analysis, visualization, and business intelligence, making her a trusted advisor. Her ability to derive meaningful insights from complex datasets and translate them into actionable strategies sets her apart. Committed to empowering others, Shivangi has written this book to help aspiring data analysts enhance their skills. Her writing combines theory and practical application to offer valuable guidance. Additionally, Shivangi actively mentors aspiring data professionals, particularly women, encouraging them to pursue their dreams in the field. Her journey reflects her resilience, determination, and passion for data analysis, as she continues to inspire others and shape the future of the industry with her expertise and thought leadership.