Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You’ll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. You’ll learn how to: - Create databases and related tables using your own data - Define the right data types for your information - Aggregate, sort, and filter data to find patterns - Use basic math and advanced statistical functions - Identify errors in data and clean them up - Import and export data using delimited text files - Write queries for geographic information systems (GIS) - Create advanced queries and automate tasks Learning SQL doesn’t have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.
Details e-book Practical SQL: A Beginner's Guide to Storytelling with Data
🗸 Author(s): Anthony DeBarros
🗸 Title: Practical SQL: A Beginner's Guide to Storytelling with Data
🗸 Rating : 4.7 from 5 stars (249 reviews)
🗸 ISBN-10: 1593278276
🗸 ISBN-13: 9781593278274
🗸 Languange: English
🗸 Format ebook: PDF, EPUB, Kindle, Audio, HTML and MOBI
🗸 Supported Devices: Android, iOS, PC and Amazon Kindle
✓ Read as many eBooks you want!
✓ Secure Scanned. No Virus Detected
✓ Thousands of eBooks to choose from - Hottest new releases
✓ Click it and Read it! - no waiting to read eBooks, it's instant!
✓ Keep reading your favorite eBooks over and over!
✓ It works anywhere in the world!
✓ No late fees or fixed contracts - cancel anytime!
Readers' opinions about Practical SQL: A Beginner's Guide to Storytelling with Data by Anthony DeBarros
Sarah Spencer
Embark on a thrilling adventure with this gripping mystery novel that keeps readers guessing until the very end. Set in a picturesque village plagued by secrets and lies, the story follows a determined detective as he unravels the truth behind a series of baffling crimes. With its clever plot twists and compelling characters, this book is a must-read for fans of the genre.
Rawena Briggs
This captivating memoir offers a deeply personal glimpse into the life of a remarkable individual, whose journey from hardship to triumph serves as an inspiration to us all. From humble beginnings to extraordinary achievements, the author's story is a testament to the power of perseverance and determination. With its raw honesty and heartfelt emotion, this book is a must-read for anyone seeking inspiration and hope.
Blysse Bond
This captivating science fiction novel transports readers to a distant future where humanity has colonized the stars and forged new alliances among the cosmos. Against the backdrop of interstellar conflict, the story follows a group of intrepid explorers as they journey to the far reaches of space in search of a lost civilization. With its gripping plot twists and richly imagined world-building, this book is a thrilling adventure that will leave readers eagerly anticipating the next installment.
