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

Raghav Kandarpa, Shivangi Saxena

Beschreibung

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.

Verfügbar seit: 31.07.2023.

Drucklänge: 350 Seiten.

Wissenschaft & Technologie

Weitere Bücher, die Sie mögen werden

Backend Dev | Java Docker and...

Et Tu Code

Unlock the full potential of backend engineering with "Java, Docker and AWS," a comprehensive guide designed to equip you with the knowledge and skills to thrive in the world of modern software development. From mastering Java programming fundamentals to leveraging Docker containers for seamless deployment, and harnessing the power of Amazon Web Services for scalable solutions, this book covers it all. 
Whether you're a seasoned developer looking to expand your skill set or a beginner eager to dive into the backend world, this book provides clear explanations, practical examples, and hands-on tutorials to guide you every step of the way. Explore essential Java concepts, learn to containerize applications with Docker, and discover how AWS services can revolutionize your development workflow. 
With detailed chapters covering topics such as object-oriented programming, RESTful web services, container orchestration, cloud deployment strategies, and more, "Java, Docker and AWS" serves as your ultimate companion in mastering backend engineering. Whether you're building microservices, deploying distributed systems, or optimizing performance, this book equips you with the tools and knowledge to succeed in today's dynamic software landscape. 
Embark on your journey to backend mastery and unlock endless possibilities with "Java, Docker and AWS" as your guide. Dive in and revolutionize your development journey today!

Zum Buch

Your Data Their Wealth - The...

James Felton Keith

AI did not appear from nowhere. It was built from human language, human behavior, human culture, human correction, and human life made legible to machines. 
In Your Data, Their Wealth, James Felton Keith argues that the modern economy has been fundamentally misdescribed. We still talk as though value comes mainly from labor, capital, and innovation in their familiar forms. But the age of AI has exposed something larger: ordinary people are generating economically useful informational value every day, and firms are capturing that value under ownership terms that leave the public with little claim on the upside. 
This is not just a book about privacy or technology. It is a book about political economy. It asks what happens when human beings become part of the productive base of intelligent systems while remaining structurally excluded from ownership of the gains. It challenges the language of the “user,” traces how law and economics helped normalize this arrangement, and argues for a new framework of claim, bargaining, and stakeholdership in the AI economy. 
Provocative, timely, and structurally ambitious, this book insists on a simple truth: if the machine is built from us, the future cannot belong only to those who own the machine.

Zum Buch

The Sacred Disease

Hippocrates

The Sacred Disease is a text written by Hippocrates that explores the topic of epilepsy. In this text, Hippocrates attempts to dispel the belief that epilepsy is a sacred disease caused by supernatural forces. Instead, he argues that epilepsy is a natural disease that should be treated like any other illness. This text is significant because it represents one of the earliest attempts to provide a rational explanation for a medical condition. Read in English, unabridged.

Zum Buch

The Product Momentum Gap -...

Dave Martin, Andrea Saez

Elevate Your Business Strategy with “The Product Momentum Gap”
Are your product, marketing, and sales teams struggling to sing the same tune? “The Product Momentum Gap” is the handbook for leaders who aspire to create a symphony of success. In its pages, you’ll uncover the transformative power of the Product VCP (Value Creation Plan), a comprehensive blueprint for aligning your teams in creating genuine value for the customer. Expect to:Reorient your teams around a value-driven ethosSeamlessly communicate across departments for greater efficiencyAchieve measurable growth by delivering what your customers truly desire
Ready to take your business to the next level? Get your hands on “The Product Momentum Gap” and set a course for extraordinary success.
"If you're stuck in a Momentum Gap, Andrea and Dave have an approach that will get you back to the basics for what matters. The Product Value Creation Plan is a guiding light for your way out of the gap. It will focus your team on your product vision and step you through a process to prioritize relevant goals leading to your desired outcomes. This book is packed with actionable steps and proven examples to get momentum headed in the right direction."
C. Todd Lombardo
Co-Author, Product Roadmaps Relaunched
“The Product Momentum Gap is something that every organisation needs to watch out for! It's going to bust your momentum, slow your sales, and drain your focus. To beat the gap, Andrea and Dave offer a pragmatic set of tools that directly connects product development to customer value. For businesses seeking to enhance their product development processes and maintain a competitive edge, this is a must read."
Kate Leto, Executive Coach for Product Leaders

Zum Buch

How To Start Green Home Computing

HowExpert

If you want to know how to be environmental friendly while using computers at home, then check this How to Start Green Home Computing guide. 
In this step-by-step guide you will reap the following benefits:Green tips for home personal computers.Techniques to do home green computing.Eco-Friendly tips for home computing.Green tools for building home green computing.Simple tactics for doing home green computing.Best techniques for making your PC green.Simple guidelines to do home green computing.Ultimate tools for building green computers.Tactics to do green computing at home.Simple green maintenance techniques for home computing.And much more. 
HowExpert publishes quick 'how to' guides on all topics from A to Z by everyday experts.

Zum Buch

Lectures on Tropical Diseases

Patrick Manson

This short volume consists of the ten lectures which Sir Patrick Manson, medical adviser to the Colonial Office, delivered in San Francisco in 1905. Valuable to this day are his clinical descriptions: the three foot Guinea worm, still treated by slowly winding it on a stick when its tail emerges from the patient's leg, filarial elephantiasis, malaria, sleeping sickness, the wasting sickness kala-azar, plus sound advice on how to diagnose puzzling tropical fevers. The book is also an inadvertent chronicle of British imperialism. - Summary by Pamela Nagami, M.D.

Zum Buch