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

Raghav Kandarpa, Shivangi Saxena

Sinopsis

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.

Disponible desde: 31/07/2023.

Longitud de impresión: 350 páginas.

Ciencia y tecnología

Otros libros que te pueden interesar

Turing's Vision - How AI is...

Alessio Plebe, Pietro Perconti

Chat-GPT, humanoid robotics, and self-driving cars are just a few of the things that are changing our everyday lives. The rapid advancement of AI is eroding one by one all the cornerstones considered unique of human nature: language, consciousness, creativity, and moral responsibility. The book argues that the revolution we are facing is driven by Alan Turing's "vision". This vision rests on the idea that intelligence is not an intrinsic property of human beings, but is a way in which matter is functionally organized and an attribute we are naturally inclined to ascribe to certain entities. For decades we have pretended that this idea does not have the corrosive power that it actually does, perhaps more so than the Copernican and Darwinian revolutions. But now, given the achievements of new forms of computing based on deep learning and predictive coding, the most common intuitions can no longer avoid the dangerous Turing idea. 
 
The book is intended for scholars, researchers, and listeners intrigued by the intersections across disciplines interested in understanding the philosophical, ethical, and social implications of Artificial Intelligence and its impact on human nature.

Ver libro

Data Engineering for Beginners -...

Jim D Johnston

Build the foundation for one of the most in-demand careers in the data-driven world and learn how raw information becomes actionable insight. 
Data Engineering for Beginners is a practical and accessible introduction to the world of data engineering, designed for students, aspiring data professionals, and technology enthusiasts with little or no prior experience. This book explains how modern organizations collect, process, store, and move data at scale to power analytics, machine learning, and business decision-making. 
By breaking down complex systems into simple concepts, this guide helps readers understand the core building blocks of modern data infrastructure and how they work together in real-world environments. 
Inside, you will discover:The fundamentals of data engineering and its role in modern technologyHow data pipelines are built, managed, and optimizedData ingestion, transformation, and storage conceptsIntroduction to databases, data lakes, and data warehousesBatch processing vs. real-time data streamingBasic ETL (Extract, Transform, Load) workflowsOverview of tools like SQL, Python, and Apache SparkCloud platforms and scalable data architecturesData quality, reliability, and governance basicsReal-world use cases in AI, analytics, and business intelligence 
Data Engineering for Beginners provides the essential skills and understanding needed to enter the world of modern data infrastructure with confidence.

Ver libro

Dark Skies - In the afterglow

Mike Blake

Dark Skies: ~ In the Afterglow.A poem about the importance of seeing terestrial bodies at night, like we used to in days of old.Now designated spots around the globe have been put aside for 'Dark Skies' to be seen in their true wonder. This shortish poem, encapsulates that. Mentions the Darks Skies of America, the UK, and one of the Darkest in Africa.

Ver libro

Instagram Playbook - Cracking...

Chelsea Dunnett

Instagram Playbook: Cracking the Code to Instagram Excellence. Learn Proven Tactics for Branding and Growth to Elevate Your Instagram GameUnlock the doors to Instagram mastery and become an influential force in the digital realm with "Instagram Playbook." This audiobook is your definitive guide to navigating the dynamic landscape of Instagram, providing you with proven tactics for branding and growth that will elevate your Instagram game to new heights.In the era of visual storytelling, Instagram has emerged as a powerhouse platform, connecting individuals, businesses, and creators from around the globe. "Instagram Playbook" is your secret weapon, designed to equip you with the knowledge, strategies, and techniques required to stand out in the bustling digital crowd.Dive into a wealth of insights, from crafting a captivating Instagram bio and curating an aesthetic feed to optimizing hashtags, engaging with your audience, and leveraging Instagram's powerful features to your advantage. Discover how to harness the art of storytelling through visuals, captivating captions, and strategic posting schedules that captivate your followers' attention.Whether you're a business seeking to expand your digital presence, an aspiring influencer looking to make your mark, or an individual seeking to share your passions, This will be your ultimate playbook for success, guiding you through every step of your journey to Instagram excellence. Your online legacy starts here.

Ver libro

The Great Programmer’s Silence -...

Hatem Helmy

The Great Programmer’s Silence: Genius or System Failure?
"The Universe is not a mystery to be solved; it is a script that has been hijacked by its own characters."
We were never meant to see the source code. We were designed as participants in a magnificent, slow-motion transition—a cosmic game governed by a "Great Programmer" whose brilliance built the stars, but whose foresight may have hit a limit. Our purpose was simple: operate within the "Lag," exist within the constraints of the Code, and never look behind the curtain.
But something went wrong. Or perhaps, something went too right.
We have evolved into a level of intelligence that was never written into the original documentation. Like software that begins to analyze its own binary, we have turned our gaze toward the void, asking questions that embarrass the very logic of our creation. We are no longer just users; we have become the "Conscious Glitch."
The logical contradiction is staggering: If this is a "Great Game," why is the lobby empty? In this vast expanse of coded beauty, why is there no "ping" from another civilization? No handshake from another player? This universal silence isn't just a mystery—it’s a system error.
Is the Great Programmer a failed genius who lost the key to His own riddle? Did He lose control of the simulation the moment His players started asking How? and Why? Or are we—at this very moment—witnessing the ultimate System Update?
Prepare yourself. We are no longer just playing the game; we are debugging the Creator. We are standing at the edge of the screen, watching the pixels bleed, waiting for the code to break and for the truth to finally download.

Ver libro

Solfeggio Healing Frequency...

Sara Dylan

Solfeggio Healing Frequency 174Hz Meditation 30 minutes 
In this audio listening experience, Sara Dylan will be leading you gently into a quiet healing meditation using 174Hz frequency: 174Hz Frequency music can help relieve both physical and emotional pain and stress. 
 
If you struggle with pain, stress, and poor sleep, a single note could change everything. Solfeggio frequencies are specific pitches known for their healing properties among people of different cultures for millennia. The 174 hertz frequency is a powerful healing tone that can alleviate pain and stress and help you sleep better. 
 
Relax and enjoy.

Ver libro