DMIT 1508

Looking for the class examples GitHub repo?

Course Resources

• Glossary: terms used in DMIT 1508
• Quick reference cheatsheet: all the SQL we’ve used

Topics

• Normalization
• DDL
  • Creating tables
  • Constraints
  • The LIKE operator
  • Altering tables
  • Indexes
• Queries
  • WHERE
  • Search Criteria operators
  • UNION
  • Aggregate functions
  • HAVING
  • ORDER BY
  • String functions
  • Datetime functions
  • JOINs
  • Subqueries
  • ANY, SOME, and ALL operators
• Views
• DML
  • INSERT
  • UPDATE
  • DELETE
• Stored Procedures
  • Variables
  • Flow control
  • Parameters
  • Raising errors
  • Global variables
  • Transactions
  • SP checklist: everything you need to write an SP
• Triggers
  • Temporary tables