Unisciti a noi in un viaggio nel mondo dei libri!
Aggiungi questo libro allo scaffale
Grey
Scrivi un nuovo commento Default profile 50px
Grey
Iscriviti per leggere l'intero libro o leggi le prime pagine gratuitamente!
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

Casa editrice: Packt Publishing

  • 0
  • 0
  • 0

Sinossi

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.
Disponibile da: 31/07/2023.
Lunghezza di stampa: 350 pagine.

Altri libri che potrebbero interessarti

  • The Superluminal Universe - Redefining Consciousness Time and Space - cover

    The Superluminal Universe -...

    Brigitte Dutheil, Régis Dutheil

    • 0
    • 0
    • 0
    The Superluminal Universe reveals, for the first time in English, the incredible insights of French quantum physicist Professor Régis Dutheil. Thanks to the development of particle accelerators, physicists are now able to propel particles (tachyons) at a speed close to that of light (300,000 km per second). At these extreme speeds, the laws that govern our universe no longer apply. Professor Dutheil's work has shown that the theory of relativity is not incompatible with that of tachyons, provided that we allow for the possibility of a double reality: that alongside our sub-luminous universe, which follows the law of time, is a superluminal universe. This second reality is another universe, complementary to and symmetrical with ours, governed by superluminal space-time in which light moves 300,000 km/s to infinity. 
     
     
     
    In the superluminal universe, everything is instantaneous. It is possible to conceive of a superluminal being capable of moving from one end of space to the other. This parallel universe consists only of information and consciousness: all information (past, present, future) and the consciousness of all humanity. Professor Dutheil's thesis joins the intuitions of ancient philosophers with current quantum physics to blow our current notions of time, of past and present, of the nature of consciousness, of birth and death right out of the water.
    Mostra libro
  • Sunlight and Us - cover

    Sunlight and Us

    John Hawk

    • 0
    • 0
    • 0
    Sunlight and Us by Professor John Hawk offers an enlightening journey into the profound and diverse effects of sunlight on human health and the environment. Drawing from his extensive career in dermatological photobiology, Hawk delves into the origins of sunlight, its vital role in our lives, and its dual nature as both a giver of life and a potential hazard. 
    Through engaging narratives and scientific insights, Hawk navigates the complexities of sunlight’s impact on skin health, the intricacies of Vitamin D synthesis, and the global challenge of climate change. This work not only pays homage to the sun’s omnipresent influence but also underscores the delicate balance humanity must maintain with this powerful star.
    Mostra libro
  • Many Things Under a Rock - The Mysteries of Octopuses - cover

    Many Things Under a Rock - The...

    David Scheel

    • 0
    • 0
    • 0
    Of all the creatures of the deep blue, none is as captivating as the octopus. In Many Things Under a Rock, marine biologist David Scheel investigates four major mysteries about these elusive beings. How can we study an animal with perfect camouflage and secretive habitats? How does a soft and boneless creature defeat sharks and eels, while thriving as a predator of the most heavily armored animals in the sea? How do octopus bodies work? And how does a solitary animal form friendships, entice mates, and outwit rivals? 
     
     
     
    Over the course of his twenty-five years studying octopuses, Scheel has witnessed a sea change in what we know and are able to discover about octopus physiology and behavior—even an octopus's inner life. Here he explores amazing new scientific developments, weaving accounts of his own research, and surprising encounters, with stories and legends of Indigenous peoples that illuminate our relationship with these creatures across centuries. In doing so, he reveals a deep affinity between humans and even the most unusual and unique undersea dwellers. 
     
     
     
    Octopuses are complex, emotional, and cognitive beings. This is the story of what we have learned and what we are still learning about the natural history and wondrous lives of these animals with whom we share our blue planet.
    Mostra libro
  • Data Governance Guide - Navigating the Seas of Information Management - cover

    Data Governance Guide -...

    Brian Paul

    • 0
    • 0
    • 0
    In the ever-expanding digital landscape, the power and potential of data are immense, but so are the challenges of managing, protecting, and harnessing its value. "Data Governance Guide: Navigating the Seas of Information Management" serves as an indispensable compass for individuals and organizations seeking to master the art of effective data governance. 
    This comprehensive guide begins by laying the groundwork, exploring the foundational elements of data and the evolution of data governance. Readers will gain a deep understanding of data stewardship, quality management, metadata, security, and privacy—all crucial components for building a resilient and efficient data governance framework. 
    Moving beyond theory, the book delves into practical implementation strategies. It offers insights into assembling a robust data governance team, developing policies, and creating essential tools such as a comprehensive data dictionary. Chapters on data quality standards and security measures guide readers through the intricacies of ensuring that their data is not only abundant but also accurate, secure, and compliant with privacy regulations. 
    Highlighting best practices, the guide emphasizes the importance of communication, collaboration, and continuous improvement. Readers will discover how to foster a data-driven culture within their organizations, establish key performance indicators, and instill a commitment to ongoing education and training. 
    "Data Governance Guide" offers a clear and concise roadmap for steering through the complexities of data governance. Equip yourself with the knowledge and strategies needed to harness the full potential of your data while safeguarding its integrity and security. This guide is your companion in the journey to mastering the seas of information management. 
     
    Mostra libro
  • Whale Song and the Secret Life of Whales - The Life Story of a Humpback and Sperm Whale from Warm Birth Lagoon to Ocean Elder Told for Grown up Nature Lovers - cover

    Whale Song and the Secret Life...

    Earthside Collective

    • 0
    • 0
    • 0
    You loved the books about trees that share sugar, fungi that trade nutrients and octopuses that solve puzzles, and now you want that same warm, careful wonder for the biggest animals alive. Most whale books are either textbooks or picture books for kids, and neither is what you reach for on a long walk or a quiet evening.
    
    This audiobook follows a humpback and a sperm whale across one whole life, from a warm shallow lagoon through the first migration beside its mother, learning the clan's dialect, the long dark dives, motherhood and old age. Each chapter centers on one documented behavior, such as songs that spread across an ocean like hit records, bubble-net hunting, mourning over a lost calf, or a whale fall feeding the seafloor for decades. Every chapter ends by separating what researchers actually know from what still puzzles them, then brings the story back to your own coast, river or family table.
    
    By the last chapter, the sea outside your window will feel inhabited. Press play and let the whales carry you out.
    Mostra libro
  • The Honey Trap - How the Good Intentions of Urban Beekeepers Risk Ecological Disaster - cover

    The Honey Trap - How the Good...

    Dana L. Church

    • 0
    • 0
    • 0
    The last decade has seen an explosion of urban beekeeping in the US, Canada, and Europe, a well-intentioned response to perceived threats to the global honey bee population. Many thousands of people have taken up this seemingly environmentally friendly hobby, tending backyard and rooftop hives (or paying a company to do so) and encouraging honey bees to make honey and pollinate flowers. What could be wrong with that? 
     
     
     
    Quite a lot, in fact. In The Honey Trap, scientist and author Dana Church demonstrates that despite reports to the contrary, honey bees are nowhere near extinction. Rather, their nurturing by urban beekeepers is having far-reaching and potentially devastating consequences for the 19,999 other species of bees on the planet, with knock-on effects for plants, both cultivated and wild, and our ecosystems more generally. 
     
     
     
    With engaging storytelling and a wealth of knowledge about bees and their ways, Church unravels the complexities of human interactions with our winged friends and demonstrates how dangerously selfish our thinking can be. It's a wake-up call for humanity to embrace sustainable practices and protect these vital pollinators before it's too late.
    Mostra libro