Important Info:
- Syllabus
- Join my Slack and then join channel #23f-cs3200
- Make sure you have been added to Piazza. DM Dr. Fontenot on Slack if you can’t access it.
- TA Office Hour Schedule
Lecture Notes:
- Lecture 01 Notes
- Lecture 02 Notes – The Relational Model
- Lecture 03 Notes – Relational Algebra
- Lecture 04 Notes – SQL Part 1
- Lecture 05 Notes – SQL Part 2
- Lecture 06 Notes – SQL DDL
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
Homework Assignments:
- Homework 01
- Early EC Deadline: Sunday September 10, 2023 @ 11:59pm
- Regular Deadline: Tuesday September 12, 2023 @ 11:59pm
- Homework 02 – Relational Algebra
- Submit to GradeScope
- Early EC Deadline: September 24, 2023 @ 11:59pm
- Regular Deadline: September 26, 2023 @ 11:59pm
- LaTeX Source for the Assignment is posted on Slack (provided graciously by James Sweeney)
- Note: you may use this as a starting point for composing your solutions. But don’t feel like you need to learn LaTeX for HW02. This is just 1 option.
- Homework 03 – SQL
- Submit to GradeScope (submission availability forthcoming)
- Early EC Deadline: Oct 8 @ 11:59 pm
- Regular Deadline: Oct 10 @ 11:59pm
Course Project:
- More info on the project will be available later in the semester.