References for Relational Databases and SQL

  • SQL Tutorials

  • SQLite References (we're using SQLite in the class)
    • Official Documentation
    • SQLite SQL Syntax
    • In general, to find out more about a particular SQL construct (e.g, aggregation), use a search engine (e.g., "sqlite aggregation"), and click on a search result that's hosted by www.sqlite.org.

  • Online SQL Course
    • Prof. Widom's online course: Introduction and Relational Databases
      Relevant sections:
      • The Relational Model (video separately on YouTube here)
      • Querying Relational Databases (video separately on YouTube here)

    • Prof. Widom's online course: SQL
      Relevant sections, with YouTube videos linked but don't miss the online exercises in the course:
      • Introduction to SQL (video separately on YouTube here)
      • Basic SELECT Statement (video separately on YouTube here)
      • Table Variables (and Set Operators) (video separately on YouTube here)
      • Subqueries in WHERE Clause (video separately on YouTube here)
      • Aggregation (video separately on YouTube here)
      • Data Modification Statements (video separately on YouTube here)