Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
I want to read the book!
All characters reduced
Data Wrangling with SQL - A hands-on guide to manipulating wrangling and engineering data using SQL - cover

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

Raghav Kandarpa, Shivangi Saxena

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

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.
Available since: 07/31/2023.
Print length: 350 pages.

Other books that might interest you

  • Second-Chance Horses - True Stories of the Horses We Rescue and the Horses Who Rescue Us - cover

    Second-Chance Horses - True...

    Callie Smith Grant

    • 0
    • 0
    • 0 
    From miniature donkeys to enormous draft horses, from regal Arabian stallions to sassy Shetland ponies, horses and other equines bring us delight and comfort whenever we encounter them. Even more so, perhaps, when humans and horses are brought together through a rescue. Whether someone has started a rescue ranch on purpose or circumstances align to match up the right horse with the right person, stories of second chances warm our hearts and restore our hope. 
 
This emotional and inspiring collection of true stories introduces you to a pony who helps a little girl get over her fear of riding, a donkey who discovers his purpose protecting vulnerable lambs, blind horses who teach their human about courage, and even a pony who somehow figures out how to drive a golf cart. By turns humorous and heartwarming, these delightful tales are the perfect companion for those times you long to slow down, take a load off, and enjoy the ride.
    Show book
  • A Compassionate Calling - What It Really Means to Be a Veterinarian - cover

    A Compassionate Calling - What...

    Marie Holowaychuk

    • 0
    • 0
    • 0 
    A Compassionate Calling offers an unflinching and deeply personal look into the realities of the veterinary profession. 
Dr. Marie Holowaychuk, a veterinary specialist with experience in academia, emergency and referral hospitals, and general practice, weaves candid personal stories with evidence-based insights from published research. In 40 concise and thought-provoking chapters, she explores the hidden curriculum of veterinary school, the toll of on-call work, the emotional impact of euthanasia, the challenges of practicing during a pandemic, and many other important topics. Marie also tackles pressing issues like diversity, equity, inclusion, and the evolving dynamics of pet insurance and corporatization in veterinary medicine. 
With its blend of heartfelt storytelling and practical insights, A Compassionate Calling is essential reading for pet owners, aspiring veterinarians, and anyone curious about the veterinary profession. Practicing veterinarians will also find comfort and connection in its honest exploration of the joys and struggles of veterinary life.
    Show book
  • Where the Earth Meets the Sky - A Story of Penguins People and Place in Antarctica - cover

    Where the Earth Meets the Sky -...

    Louise K. Blight

    • 0
    • 0
    • 0 
    Antarctica is a land of extremes. But while its hurricane force winds, tooth-breaking cold, and resident penguins have long been iconic, the perspective of a practicing female scientist is all but absent from modern day Antarctic accounts. Where the Earth Meets the Sky fills that gap.Louise and her campmate David Ainley—one of the greatest Antarctic scientists on the planet—live in a world defined by hostile weather, breathtaking beauty, a continuous parade of avian visitors, and an occasional human visitor. There she explores the lingering grief that has followed the untimely death of her sister, and presents penguins as a window into how climate change and other environmental impacts are altering what has been one of the most untouched corners of the globe.While penguins and the awe-inspiring landscapes they inhabit provide the thread that runs through this story, a central theme is how the world's most unforgiving environment has shaped the psyches of Antarctica’s human visitors, past and present.Experiencing the Antarctic wildernesses has the potential to heal the human psyche and, perhaps, to give us the optimism to reimagine our relationship with the natural world.
    Show book
  • Project Management Basics in 60 Minutes - cover

    Project Management Basics in 60...

    Tom Henricksen

    • 0
    • 0
    • 0 
    You just got a project to manage and you are not the project manager or you would like a quick refresher this is the book for you! We will start with some pitfalls that many project managers should avoid. From start to completion of the project we see the need for skills and how to handle the inevitable change.  
  
This step-by-step guide to project management teaches:   Starting a project   Planning a project   Building a project   Running a project   Completing a project  
  
We also will cover:   Why we need project management   Project Management Skills Handling project change
    Show book
  • Studies In Consciousness - and The Breath Of One - cover

    Studies In Consciousness - and...

    Sharon Ann Meyer

    • 0
    • 0
    • 0 
    This is part of the “Lightworker's Log Book Series” that came into existence in 2008, via soul promptings and after a series of life circumstances designed to awaken the author to humanity's true state. Previous publications consisted of choosing titles, arranging content, and taking vast amounts of time to compile an entire book. These days, books are easily birthed by merely tapping into greater aspects of what may be referred to as the author’s ever-changing consciousness. Publications are now compiled in this way by many more authors than ever before. This book is just one example of material stemming from what may be referred to as a more evolved consciousness experiencing and expressing in a field of decreasing duality. 
As segments of humanity become increasingly chaotic while others experience greater states of consciousness, there comes a time when one asks, “Are we there yet?” STUDIES IN CONSCIOUSNESS and The Breath Of One is designed to explain in, hopefully, easily understood terms the vast separation from Source that humanity chose to experience. It is not meant to create further separations of Consciousness by delving into and examining other planets, galaxies or universes, but to explain how humanity got to the point where it is in the later portion of the twenty-first century, and how it will rise above it. STUDIES IN CONSCIOUSNESS and The Breath Of One began to surface during weeks of daily, multiple deluges of water in September 2025. 
“Water is the wilderness, the calling, the rally of the soul.” 
This book contains what the author refers to as “heavy-duty information,” and as does water contains light codes, which necessitate short bursts of reading material to be assimilated chapter by chapter, allowing time between them for full incorporation. 
The return to Source may not seem instantaneous, but it is already achieved, for separation is impossible in the grand scheme of Source. 
Read this book to see that it rings true and speaks for itself.
    Show book
  • Relativity: The Special and the General Theory - cover

    Relativity: The Special and the...

    Albert Einstein

    • 0
    • 0
    • 0 
    "Relativity: The Special and the General Theory" is a seminal work by Albert Einstein, first published in 1916, designed to explain the groundbreaking theories that reshaped our understanding of the universe. In this accessible text, Einstein introduces readers to the Special Theory of Relativity, which addresses the relationship between space and time, and the General Theory of Relativity, which expands these concepts to include gravity as the curvature of space-time caused by mass and energy. Written for the layperson, Einstein employs clear language and thought experiments to elucidate complex ideas such as time dilation, length contraction, and the equivalence principle, making this book a cornerstone of modern physics and a must-read for anyone interested in the fundamental nature of reality.
    Show book