CS50 SQL

• Course
• Gradebook

Index

Week 0 - Querying

• SELECT
• LIMIT
• WHERE
  • =, >, <, >=, <=, != <>, NOT
  • AND
  • OR
  • ()
  • IS NULL, IS NOT NULL
  • LIKE, %, _
  • BETWEEN ... AND ...
• ORDER BY ... ASC / DESC
• Aggregate functions:
  • COUNT
  • AVG
  • MIN
  • MAX
  • SUM
• DISTINCT

Week 1 - Relating

• Relationships:
  • One to one.
  • One to many.
  • Many to many.
• Subqueries.
• Joins.
  • INNER, LEFT, RIGHT, FULL
  • NATURAL JOIN
• Sets.
  • UNION
  • INTERESCT
  • EXCEPT
• Groups.
  • GROUP BY
  • HAVING