Course Outline

About

• For a description of the course objectives, and the grading breakdown please see the formal Course Outline found here
• For the late assessment policy per Keyin, please see the document here.
• The “dates” for the QAPs and sprints will remain constant throughout the semester
• Subjects covered and/or the order in which they’re covered may change as the course gets more fleshed out. The review at the end is subject to the time we have left after covering all other materials, and it may be dropped if the time doesn’t allow for it.

Outline/Schedule

• Week 1: Introduction to Databases, CRUD operations
• Week 2: Relational Databases
• Week 3: Database design, Database Normalization
• QAP 1
• Week 4: SQL with PostgreSQL
• Week 5: Managing a database with pgAdmin
• QAP 2
• Week 6: Databases and backend web development
• Week 7: Connecting a Node.js backend to a PostgreSQL database
• Week 8-9: Midterm Sprint
• Week 10: NoSQL databases
• Week 11: MongoDB and management with the MongoDB shell
• QAP 3
• Week 12: Connecting a Node.js backend to a MongoDB database
• Week 13: Review
• Week 14/15: Final Sprint