PRACTICAL
SQL
PRACTICAL
SQL
A BEGINNER’S GUIDE TO
STORYTELLING WITH DATA
ANTHONY DE BARROS
SQL (Structured Query Language) is a popular
programming language used to create, manage,
and query databases. Whether you’re a marketing
analyst, a journalist, or a researcher mapping neurons
in the brain of a fruit fly, you’ll benefit from using SQL
to tell the story hidden in your data.
Practical SQL is a fast-paced, plain-English introduc-
tion to programming with SQL. Following a primer on
SQL language basics and database fundamentals,
you’ll learn how to use the pgAdmin interface and
PostgreSQL database system to define, organize, and
analyze real-world data sets, such as crime statistics
and U.S. Census demographics.
Next, you’ll learn how to create databases using
your own data, write queries to perform calculations,
and handle common roadblocks when dealing with
public data. With the help of easy-to-follow exercises
in each chapter, you’ll discover how to build powerful
databases and find meaning in your data sets.
You’ll also learn how to:
• Define the right data types for your information
• Aggregate, sort, and filter data to find patterns
• Identify and clean up any errors in your data
• Search text for meaningful data
• Create advanced queries and automate tedious
tasks
Organizing and analyzing data doesn’t have to be
dry and complicated. Find the story in your data with
Practical SQL.
ABOUT THE AUTHOR
Anthony DeBarros is an award-winning data journalist
whose career spans 30 years at news organizations
including USA TODAY and Gannett’s Poughkeepsie
Journal. He holds a master’s degree in information
systems from Marist College.
This book uses PostgreSQL
but is applicable to MySQL,
Microsoft SQL Server, and
other database systems.
YOUR DATA
STORY IN
FIND THE
YOUR DATA
STORY IN
FIND THE
www.nostarch.com
THE F INE ST I N G EEK E N TE RTA I N M ENT
™
SHELVE IN:
PROGRAMMING LANGUAGES/SQL
$39.95 ($53.95 CDN)
PRACTICAL SQL
PRACTICAL SQL
D E BARROS
剩余387页未读，继续阅读
评论0