Important Info
- Syllabus
- Fontenot Office Hours
- Mon & Wed 12 – 1pm (after class) in Meserve 353
- If those times don’t work for you, feel free to send me a Slack message and we can find some alternatives that work better.
Lecture Notes
- Note Set 01 – Getting Started
- Note Set 02 – The Relational Model and Relational Algebra
Exam Prep
Coming Soon!
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
- HW 01 – Getting Started and Relational Algebra
- EC Due Date: Sunday, July 5, 2026 @ 11:59 pm EST, uploaded to GradeScope
- Regular Due Date: Monday, July 6, 2026 @ 11:59 pm EST, uploaded to GradeScope
- HW 02 –
- EC Due Date:
- Regular Due Date:
- HW03 –
- HW04 –
- EC Due Date:
- Regular Due Date:
- HW05 –
- EC Due Date:
- Regular Due Date:
- HW06 –
- EC Due Date:
- Regular Due Date:
Project Info
More Info Coming Soon
- Streamlit Tutorial: Go to khouryodyssey.org, log in, set up your profile and check out the Groups tab. You should be in a group for this course. In it, there should be a Streamlit Tutorial droplet (a learning module).
- Sample Streamlit Apps Repository
The Project Template Repository
Project Development Tips, Tutorials, and Documentation
- Fontenot’s Video Tutorials for Summer 24 Project
- Low Fidelity Wireframing Guide/Examples
- I made this during the recent Dialogue in Belgium, and forgot I had it. Hopefully, this is helpful to you all.
- Git and GitHub – Setting up SSH Keys
- If you want to use
gitfrom the command line to interact with GitHub, you need to set up an SSH key pair (the pair consists of a private key and a public key), and then upload the PUBLIC key to GitHub. - GitHub’s Documentation for generating and setting up an SSH keypair
- Make sure you select the correct platform for your laptop using the tabs near the top of the page.
- YouTube Tutorials:
- From The Common Coder: How to Set Up an SSH Key for GitHub in 2024 (for Mac and Windows)
- From Codemify: How to setup SSH for GitHub repository
- If you want to use
- Python for Beginners
- TheNewBoston’s video: Python Tutorial in 30 Minutes
- If you want a slightly more comprehensive introduction, check out Python Crash Course Playlist from Net Ninja (don’t need to worry about about video #8, for the project at least)
- Flask Framework (for building REST API)
- In Flask, you can write full-featured web apps, but we will only be using the REST API features of the library.
- Dave Gray’s video: Python REST API Tutorial for Beginners
- Tech With Tim’s video: Python REST API Tutorial (you could stop around the 45:00 before he starts talking about databases)
- This video is a little older, but still very relevant!