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

Practical SQL a beginner's guide to storytelling with data

"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 databa...

Full description

Bibliographic Details
Other Authors: DeBarros, Anthony, author (author)
Format: eBook
Language:Inglés
Published: San Francisco : No Starch Press 2018.
Edition:1st edition
Subjects:
SQL (Computer program language)
Database design.
COMPUTERS / Programming Languages / SQL.
COMPUTERS / Database Management / General.
COMPUTERS / Database Management / Data Mining.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630658606719
Table of Contents:
  • Machine generated contents note: Introduction
  • Chapter 1: Creating your first database & 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
  • Chapter 6: Joining Tables in a Relational Database
  • Chapter 7: Table Design that Works for You
  • Chapter 8: Grouping and Summarizing Data
  • Chapter 9: Cleaning , Modifying, Deleting Data
  • Chapter 10: Ranks, Rates, asnd Stats
  • Chapter 11: Dealing with Dates
  • Chapter 12: Advanced Queries
  • Chapter 13: Full-Text Search
  • Chapter 14: GIS
  • Chapter 15: Views
  • Chapter 16: Working from the command line
  • Chapter 17: Maintenance
  • Appendix A: Alternative software and text editors
  • Appendix B: Solutions.

Similar Items