Database design

• Database Design and Visualization
  • [ ] Database Design
• SQL basics
  • [ ] select
  • [ ] Filtering
    • [ ] ORDER BY
    • [ ] DISTINCT
    • [ ] LIMIT
    • [ ] WHERE Clause
    • [ ] Comparison operators
    • [ ] Logical operators
    • [ ] AND operator
    • [ ] OR operator
  • [ ] Joins
    • [ ] SQL Aliases
    • [ ] INNER JOIN
    • [ ] LEFT OUTER JOIN
    • [ ] FULL OUTER JOIN
    • [ ] SELF JOIN
  • [ ] Aggregate
    • [ ] Aggregate functions
    • [ ] AVG
    • [ ] COUNT
    • [ ] SUM
    • [ ] MAX
    • [ ] MIN
  • [ ] Grouping data
    • [ ] GROUP BY
    • [ ] HAVING
  • [ ] Subqueries
    • [ ] Subquery
    • [ ] Correlated Subquery
• Database concepts - see Designing Data-Intensive Applications book
  • [ ] Reliable, scalable and Maintainable applications chapter 1
  • [ ] Data models and query languages chapter 2