SQL for Librarians: Reference

Key Points

Introduction to SQL
  • SQL (Structured Query Language) is a query language used to interact with databases

  • Databases contain data organized in tables

  • SQLite is a database management system

Basic queries
  • SQL is ideal for querying databases

Aggregation
  • SQL is ideal for aggregating database records

Joins and aliases
  • SQL is ideal for linking tables

Database design supplement
  • SQL is one of many database management systems