首页Practical SQL (True PDF)
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
Organizing and analyzing data doesn’t have to be
dry and complicated. Find the story in your data with
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.
THE F INE ST I N G EEK E N TE RTA I N M ENT
$39.95 ($53.95 CDN)
D E BARROS
A Beginner’s Guide to
Storytelling with Data
by Anthony DeBarros
PRACTICAL SQL. Copyright © 2018 by Anthony DeBarros.
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means,
electronic or mechanical, including photocopying, recording, or by any information storage or retrieval
system, without the prior written permission of the copyright owner and the publisher.
Publisher: William Pollock
Production Editor: Janelle Ludowise
Cover Illustration: Josh Ellingson
Interior Design: Octopod Studios
Developmental Editors: Liz Chadwick and Annie Choi
Technical Reviewer: Josh Berkus
Copyeditor: Anne Marie Walker
Compositor: Janelle Ludowise
Proofreader: James Fraleigh
For information on distribution, translations, or bulk sales, please contact No Starch Press, Inc. directly:
No Starch Press, Inc.
245 8th Street, San Francisco, CA 94103
phone: 1.415.863.9900; email@example.com
Library of Congress Cataloging-in-Publication Data
Names: DeBarros, Anthony, author.
Title: Practical SQL : a beginner's guide to storytelling with data / Anthony
Description: San Francisco : No Starch Press, 2018. | Includes index.
Identifiers: LCCN 2018000030 (print) | LCCN 2017043947 (ebook) | ISBN
9781593278458 (epub) | ISBN 1593278454 (epub) | ISBN 9781593278274
(paperback) | ISBN 1593278276 (paperback) | ISBN 9781593278458 (ebook)
Subjects: LCSH: SQL (Computer program language) | Database design. | BISAC:
COMPUTERS / Programming Languages / SQL. | COMPUTERS / Database Management
/ General. | COMPUTERS / Database Management / Data Mining.
Classification: LCC QA76.73.S67 (print) | LCC QA76.73.S67 D44 2018 (ebook) |
LC record available at https://lccn.loc.gov/2018000030
No Starch Press and the No Starch Press logo are registered trademarks of No Starch Press, Inc. Other
product and company names mentioned herein may be the trademarks of their respective owners. Rather
than use a trademark symbol with every occurrence of a trademarked name, we are using the names only
in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the
The information in this book is distributed on an “As Is” basis, without warranty. While every precaution
has been taken in the preparation of this work, neither the author nor No Starch Press, Inc. shall have any
liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or
indirectly by the information contained in it.
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额