Important Info:
- Syllabus
- TA Office Hour Schedule
- TA Office Hours will start officially Jan 16, 2024.
- For more information about the Khoury Office Hours app, see this post.
- Communication and Getting Help
- Join my Slack with your Northeastern Email and then join channel #24s-cs3200 (info on how to join a channel can be found here)
- Join CampusWire – Use your Northeastern Email Address. The access code is pinned in the #24s-cs3200 Channel on Slack.
Lecture Notes:
- Lecture 01 – Getting Started
- Lecture 02 – Introduction to Databases and the Relational Model of Data
- Lecture 03 – Relational Algebra
- Lecture 04 – SQL – DQL I
- Lecture 04b – Setting up Northwind
- Lecture 05 – SQL – DQL II (Joins, Group By, Having)
- Lecture 05 – Challenge Problem Solution
- Lecture 06 – SQL – DQL III (Advanced + Nested Queries)
- Lecture 07 – SQL – DDL
- Lecture 08 – Getting Started with MySQL
- Lecture 09 – DDL with MySQL
- Lecture 10 – Advanced SQL
- Lecture 11 – AutoIncrement, Dates, Indexing
- Lecture 12 – Database Design Part 1
- Lecture 13 – Database Design Part 2
- Lecture 14 – Database Design Part 3 (Fontenot’s Solutions)
- Lecture 15 – ER Diagram -> Relational Model (With Solutions)
- Lecture 16 – Databases in Modern Software Applications
- Lecture 17 – Designing and Implementing a REST API in Flask
Exam 1 Prep:
- Northwind ER Diagram that will be used for Long-form SQL and RA algebra questions on exam.
- Exam 1 Review Slide Deck
- Exam 1 Cheat Sheet Rules
- Sample Exam 1 from Fall 23
- Sample Exam 1 from Fall 22 (with solutions)
Exam 2 Prep:
- Sample Exam 2 from Fall 2023
- Note: As I mentioned in class, there will not be a large ER modeling problem as there is on this sample exam. There will be more short answer questions and smaller “long answer” questions.
- (Another) Note: Ignore anything related to docker/Python/Flask, etc.
- Exam 2 Review Slide Deck
- Cheat Sheet Rules: Same as Exam 1 (see above)
FonteNotes:
- Relational Algebra Extra Notes
- YouTube Playlist of Relational Algebra Examples from lecture Notes
- These are walk throughs of the examples from Slide Deck 03 on Relational Algebra that I made last year. The examples are the same.
- Relational Algebra Joins Extra Notes
- Using Notion to Write RA Expressions in LaTeX
Homework Assignments:
Unless otherwise noted in the handout, all homework assignments will be submitted via Gradescope.
- Homework 01
- Submitted to GradeScope
- Early EC Deadline: Jan 14 @ 11:59pm
- Regular Deadline: Jan 16 @ 11:59pm
- Homework 02 – Relational Algebra
- Submitted to GradeScope
- Early EC Deadline: Jan 28 @ 11:59pm
- Regular Deadline: Jan 30 @ 11:59pm
- Using Notion to write your Relational Algebra Expressions in LaTeX
- Solutions
- Homework 03 – SQL – I
- Submitted to GradeScope
- Early EC Deadline: Feb 11 @ 11:59pm
- Regular Deadline: Feb 13 @ 11:59pm
- Homework 04
- Submitted to GradeScope
- Early EC Deadline: Feb 25 @ 11:59pm
- Regular Deadline: Feb 27 @ 11;59pm
- Homework 05 – ER Modeling
- Submitted to GradeScope
- Early EC Deadline: March 17 @ 11:59pm
- Regular Deadline: March 21 @ 11:59pm (extended)
- Homework 06 – Appsmith
- Submitted to GradeScope
- Early EC Deadline: April 7 @ 11:59
- Regular Deadline: April 9 @11:59
- Homework 07 – Review Crossword Puzzle
- Submitted to GradeScope
- Early EC Deadline: April 14 @ 11:59pm
- Regular Deadline: April 16 @ 11:59pm
Course Project:
NOTE: You may NOT use your 2 day extensions on submissions for the course project!
- Project Overview and Phase 1 Requirements
- Due: March 26, 2024 @ 11:59pm.
- Handout
- Submission Template
- Phase 2 Requirements
- Due April 2, 2024 @ 11:59 pm
- Handout
- Submission Template
- Phase 3 Requirements
- Due April 17, 2024 @ 11:59 pm
- Handout
- Submission Template