Focuses in-depth instruction in the handling of critical tasks of planning and implementing large databases. Includes an introduction to concepts of advanced data warehousing and database configuration.
This is a 3 credit course which will combine class discussion with hands-on projects.
Course Information
Resources
- PostgreSQL Tutorial
- PostgreSQL Cheat Sheet
- Postgres Guide
- SQL Style Guide by Simon Holywell
- Conceptual Modeling using the Entity-Relationship Model
- What is an Entity Relationship Diagram
- Entity-relationship modelling
- Entity Relationship Diagram
- WWW SQL Designer
- Learn SQL Interactive
- Additional Resources Page