Learning outcomes:
* Explain the difference between a database and a database manager.
* Write SQL to select, filter, sort, group, and aggregate data.
* Define tables and insert, update, and delete records.
* Describe different types of join and write queries that use them to combine data.
* Use windowing functions to operate on adjacent rows.
* Explain what transactions are and write queries that roll back when constraints are violated.
* Explain what triggers are and write SQL to create them.
* Manipulate JSON data using SQL.
* Interact with a database using Python directly, from a Jupyter notebook, and via an ORM.
* Explain the difference between a database and a database manager.
* Write SQL to select, filter, sort, group, and aggregate data.
* Define tables and insert, update, and delete records.
* Describe different types of join and write queries that use them to combine data.
* Use windowing functions to operate on adjacent rows.
* Explain what transactions are and write queries that roll back when constraints are violated.
* Explain what triggers are and write SQL to create them.
* Manipulate JSON data using SQL.
* Interact with a database using Python directly, from a Jupyter notebook, and via an ORM.