Practical SQL : a beginner's guide to storytelling with data

Book Cover
Average Rating
Author
DeBarros, Anthony,
Published
San Francisco : No Starch Press, [2022].
Appears on list
SQL
Status
Available Online

Description

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.

More Details

Format
Edition
2nd edition.
Language
English
ISBN
9781718501072, 1718501072
UPC
9781098129866

Notes

General Note
Includes index.
Bibliography
Includes index.
Description
"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. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently"-- Provided by publisher.
Issuing Body
Made available through: Safari, an O'Reilly Media Company.
Local note
O'Reilly O'Reilly Online Learning: Academic/Public Library Edition

Discover More

Also in this Series

Checking series information...

More Like This

  • Practical Oracle SQL: mastering the full power of Oracle database Cover
  • PROC SQL, 3rd Edition Cover
  • Data management at scale Cover
  • Programming Ecto: build database apps in Elixir for scalability and performance Cover
  • High-performance data architectures: how to maximize your business with a cloud-based database Cover
  • Entity Framework Core in Action Cover
  • Entity Framework Core in action Cover
  • Beginning database design solutions: understanding and implementing database design concepts for the cloud and beyond Cover
  • PRACTICAL DATA QUALITY: learn practical, real-world strategies to transform the quality of data in your organization Cover
  • Database Design and Modeling with PostgreSQL and MySQL: Build Efficient and Scalable Databases for Modern Applications Using Open Source Databases Cover
  • Designing Cloud Data Platforms Cover
  • Database design using entity-relationship diagrams Cover
  • PHP & MySQL: novice to ninja Cover
  • Hands-on big data modeling: effective database design techniques for data architects and business intelligence professionals Cover
  • Defining data-driven software development: developing on a multi-model database management system Cover
  • Information modeling and relational databases Cover
  • Building custom tasks for SQL server integration services: the power of .NET for ETL for SQL Server 2019 and beyond Cover
  • Database Design and Modeling with Google Cloud: Learn Database Design and Development to Take Your Data to Applications, Analytics, and AI Cover
  • Data modeling for Azure Data Services: implement professional data design and structures in Azure Cover
  • Data engineers vs. data scientists: how misconceptions of data roles can hurt teams and compromise productivity Cover
  • PRACTICAL FAIRNESS: achieving fair and secure data models Cover
  • Android database best practices Cover
  • Practical fraud prevention: fraud and AML analytics for Fintech and eCommerce, using SQL and Python Cover
  • SQL all-in-one Cover
  • SQL in easy steps Cover

Published Reviews

Choice Review

Data analysis often employs R, Python, and Excel. SQL is seldom mentioned in the media blitz surrounding data analysis, but SQL has been in use since 1979 and is an expedient tool for accomplishing data analysis. DeBarros explains why he recommends using SQL and presents an introductory guide to using the programming language with the open source PostgreSQL database to expose stories gleanable from data. With 25 years' experience as a data journalist, DeBarros teaches the SQL language in a sensible and accessible manner using pertinent and thought-provoking examples. Topics include creating databases and tables, data importing and exporting, data exploration, statistical functions, grouping and summarizing, table joining, inspecting and modifying data, querying and text mining, spatial data analysis, working with dates and times, creating views, functions and triggers, using the command line, maintaining a database, and finally advice on how to identify stories behind data. All code and datasets are downloadable through GitHub, making it easy for readers to follow the examples. Clear instructions for installing PostgreSQL and PostGIS on Mac or Windows is provided. Links to relevant documentation and to data sources offer further learning opportunities. Summing Up: Recommended. Lower academic and public levels/collections. --Mark Mounts, Dartmouth College

Copyright American Library Association, used with permission.
Powered by Syndetics

Reviews from GoodReads

Loading GoodReads Reviews.

Citations

APA Citation, 7th Edition (style guide)

DeBarros, A. (2022). Practical SQL: a beginner's guide to storytelling with data (2nd edition.). No Starch Press.

Chicago / Turabian - Author Date Citation, 17th Edition (style guide)

DeBarros, Anthony. 2022. Practical SQL: A Beginner's Guide to Storytelling With Data. San Francisco: No Starch Press.

Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)

DeBarros, Anthony. Practical SQL: A Beginner's Guide to Storytelling With Data San Francisco: No Starch Press, 2022.

Harvard Citation (style guide)

DeBarros, A. (2022). Practical SQL: a beginner's guide to storytelling with data. 2nd edn. San Francisco: No Starch Press.

MLA Citation, 9th Edition (style guide)

DeBarros, Anthony. Practical SQL: A Beginner's Guide to Storytelling With Data 2nd edition., No Starch Press, 2022.

Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.

Staff View

Grouped Work ID
020eddf4-e69b-1a1d-5284-872fbe4da9d1-eng
Go To Grouped Work View in Staff Client

Grouping Information

Grouped Work ID020eddf4-e69b-1a1d-5284-872fbe4da9d1-eng
Full titlepractical sql a beginners guide to storytelling with data
Authordebarros anthony
Grouping Categorybook
Last Update2025-04-28 02:40:58AM
Last Indexed2025-05-22 03:00:38AM

Book Cover Information

Image SourcecontentCafe
First LoadedAug 16, 2023
Last UsedJan 25, 2025

Marc Record

First DetectedMar 20, 2023 10:15:08 AM
Last File Modification TimeDec 17, 2024 08:18:35 AM
SuppressedRecord had no items

MARC Record

LEADER04122cam a2200553 i 4500
001on1291870871
003OCoLC
00520241217081720.0
006m     o  d        
007cr cnu||||||||
008040122s2022    caua    o     001 0 eng d
019 |a 1294345854|a 1294430158|a 1294453049|a 1436723904
020 |a 9781718501072|q (electronic bk.)
020 |a 1718501072|q (electronic bk.)
0248 |a 9781098129866
035 |a (OCoLC)1291870871|z (OCoLC)1294345854|z (OCoLC)1294430158|z (OCoLC)1294453049|z (OCoLC)1436723904
037 |a 9781098129866|b O'Reilly Media
040 |a AU@|b eng|e rda|c AU@|d ORMDA|d OCLCO|d OCLCF|d XII|d OCLCQ|d OCLCO|d OCLCL|d YDX|d GUA|d K6U|d OCLCO
049 |a MAIN
050 4|a QA76.73.S67
08204|a 005.75/6|2 23
1001 |a DeBarros, Anthony,|e author.|1 https://id.oclc.org/worldcat/entity/E39PCjtvC4rQrrC3hRCPxjfH4q|9 346984
24510|a Practical SQL :|b a beginner's guide to storytelling with data /|c by Anthony DeBarros.
250 |a 2nd edition.
264 1|a San Francisco :|b No Starch Press,|c [2022]
300 |a 1 online resource :|b illustrations
336 |a text|b txt|2 rdacontent
337 |a computer|b c|2 rdamedia
338 |a online resource|b cr|2 rdacarrier
4900 |a ITpro collection
500 |a Includes index.
504 |a Includes index.
5050 |a Introduction -- Setting up your coding environment -- Creating your first database and table -- Beginning data exploration with SELECT -- Understanding data types -- Importing and exporting data -- Basic math and stats with SQL -- Joining tables in a relational database -- Table design that works for you -- Extracting information by grouping and summarizing -- Inspecting and modifying data -- Statistical functions in SQL -- Working with dates and times -- Advanced query techniques -- Mining text to find meaningful data -- Analyzing spatial data with PostGIS -- Working with JSON data -- Saving time with views, functions, and triggers -- Using PostgreSQL from the command line -- Maintaining your database -- Telling your data's story -- Appendix A. Additional PostgreSQL resources.
520 |a "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. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently"--|c Provided by publisher.
550 |a Made available through: Safari, an O'Reilly Media Company.
588 |a Online resource; Title from title page (viewed March 1, 2022)
590 |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition
650 0|a SQL (Computer program language)|9 62322
650 0|a Database design.|9 64031
655 7|a handbooks.|2 aat
655 7|a Handbooks and manuals|2 fast|9 404624
655 7|a Handbooks and manuals.|2 lcgft|9 404624
655 7|a Guides et manuels.|2 rvmgf
758 |i has work:|a Practical SQL (Text)|1 https://id.oclc.org/worldcat/entity/E39PCH7VwDhchxT97jhppTyQYP|4 https://id.oclc.org/worldcat/ontology/hasWork
77608|c Original|z 9781718501065|z 1718501064|w (DLC) 2022288073|w (OCoLC)1293235107
85640|u https://library.access.arlingtonva.us/login?url=https://learning.oreilly.com/library/view/~/9781098129866/?ar|x O'Reilly|z eBook
938 |a YBP Library Services|b YANK|n 17809010
994 |a 92|b VIA
999 |c 283323|d 283323