没有合适的资源?快使用搜索试试~ 我知道了~
首页Practical SQL (True PDF)
Practical SQL (True PDF)
需积分: 9 25 下载量 136 浏览量
更新于2023-03-16
评论
收藏 4.5MB PDF 举报
Practical SQL: A Beginner's Guide to Storytelling with Data (True PDF)
资源详情
资源评论
资源推荐
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
PRACTICAL SQL
PRACTICAL
SQL
A Beginner’s Guide to
Storytelling with Data
by Anthony DeBarros
San Francisco
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.
ISBN-10: 1-59327-827-6
ISBN-13: 978-1-59327-827-4
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; info@nostarch.com
www.nostarch.com
Library of Congress Cataloging-in-Publication Data
Names: DeBarros, Anthony, author.
Title: Practical SQL : a beginner's guide to storytelling with data / Anthony
DeBarros.
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) |
DDC 005.75/6--dc23
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
trademark.
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.
剩余387页未读,继续阅读
trismile
- 粉丝: 4
- 资源: 65
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
- MW全能培训汽轮机调节保安系统PPT教学课件.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0