Practical SQL : a beginner's guide to storytelling with data / Anthony DeBarros; forword by Sarah Frostenson
Book | No Starch Press | 2018
Available at Gateway-Racine Campus New Books Display (QA 76.73 S6.7 D4.4 2018)

Additional actions:

see all


Location Call No. Status
Gateway-Racine Campus New Books Display QA 76.73 S6.7 D4.4 2018 Available
Show fewer items

More Details

xxxiii, 351 pages : illustrations ; 24 cm
Includes bibliographical references (pages 333-336) and index.
Chapter 1: Creating Your First Database and Table
Chapter 2: Beginning Data Exploration with SELECT
Chapter 3: Understanding Data Types
Chapter 4: Importing and Exporting Data
Chapter 5: Basic Math and Stats with SQL
Chapter 6: Joining Tables in a Relational Database
Chapter 7: Table Design That Works for You
Chapter 8: Extracting Information by Grouping and Summarizing
Chapter 9: Inspecting and Modifying Data
Chapter 10: Statistical Functions in SQL
Chapter 11: Working with Dates and Times
Chapter 12: Advanced Query Techniques
Chapter 13: Mining Text to Find Meaningful Data
Chapter 14: Analyzing Spatial Data with PostGIS
Chapter 15: Saving Time with Views, Functions, and Triggers
Chapter 16: Using PostgreSQL from the Command Line
Chapter 17: Maintaining Your Database
Chapter 18: Identifying and Telling the Story Behind Your Data
Appendix: Additional PostgreSQL Resources
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 introduction 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 systen 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 perfom 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. Organizing and analyzing data doesn't have to be dry and complicated. Find the story in your data with 'Practical SQL'.
25.00 (10-156-3)
Added Author
Frostenson, Sarah
Browse Results
Other Sources:
View in classic catalog View MARC display
Back to top