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:

close
see all

Items

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

More Details

Description
xxxiii, 351 pages : illustrations ; 24 cm
Bibliography
Includes bibliographical references (pages 333-336) and index.
Contents
Introduction
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
Summary
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)
Subject
Added Author
Frostenson, Sarah
Browse Results
Other Sources:
View in classic catalog View MARC display
Back to top