Important Info
- Syllabus
- Fontenot Office Hours
- Mon & Wed 11:30 – 12:30 pm (after class) in Classroom
- 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 (slides with example solutions)
- Note Set 02b – Relational Algebra Practice – Northwind (Solutions given in class)
- Note Set 02c – Relational Algebra Practice – Classic Models (Solutions)
- Note Set 03 – Introduction to SQL and the SELECT statement (slides with example solutions)
- Note Set 04 – SQL SELECT Part 2 (slides with example solutions)
- Note Set 05 – SQL SELECT Part 3
- SELECT Practice: HuskyGram Queries
- Note Set 06 – Intro to DDL
- Note Set 07 – DDL/DML Part 2
- Note Set 08 – Database Design Part 1
Exam Prep
Prep Materials for Exam 1
- Cheat Sheet Guidelines
- Exam 1 Material will cover up through the end of SELECT statements.
- SAMPLE EXAM: Spring 2024 Exam 1. (Solutions to Sample Exam)
- The sample exam is NOT intended to represent the range of content for Exam 1!
- Use this as a sample for question types, structure, etc.
- Extra Relational Algebra Examples
FonteNotes
- Relational Algebra Extra Notes
- YouTube Playlist of Relational Algebra Examples from lecture notes
- These are walkthroughs 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 01 Solutions
- HW 02 – RA and SQL SELECTs
- EC Due Date: Saturday, July 11, 2026 @ 11:59 pm EST, uploaded to GradeScope
- Regular Due Date: Monday, July 13, 2026 @ 11:59 pm EST, uploaded to GradeScope
- HW03 – Study for Exam 1 & Make a Cheat Sheet – Submit with Exam! 😇
- Due when you take the exam 🙂
- 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!