Databases: Advanced Topics in SQL – Free Course by Stanford on edX

Databases: Advanced Topics in SQL is one of five self-paced courses on databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. Now available on edx.org, this course is broad and practical, covering indexes, transactions, constraints, triggers, views, and authorization, all within the context of relational database systems and the SQL language. Building on concepts introduced in Databases: Relational Databases and SQL, this course is recommended for learners seeking to advance their understanding and use of relational databases.

Course Sections:

1. Indexes and Transactions: Learn about indexing for increased performance and transactions for concurrency control and failure recovery.
2. Constraints and Triggers: Understand key, referential integrity, and "check" constraints, followed by comprehensive coverage of database triggers.
3. Views and Authorization: Gain extensive knowledge on creating, using, and updating database views, and learn standard techniques for authorization in relational databases.