Applied Databases

A comprehensive primer on databases, with a focus on data analysis. Connections, creation, retrieval, update and deletion of both structured and unstructured data will be covered for modern database systems and architectures.

1. Create, retrieve, update and delete data in a variety of modern database management systems.

2. Determine the correct data to select from a database in order to perform a given data analysis.

3. Select an appropriate interface to access a database for a given application.

4. Determine the best balance between application and database logic for a given data analysis process.

5. Determine the correct connection details to access a database.

6. Reverse engineer a database structure.