Important Info
- Syllabus
- TA Office Hour Schedule Coming Soon
- Fontenot Office Hours
- Tuesday & Thursday 8:45 – 9:45 (before class) in classroom (Mugar 201)
- 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 – Welcome
- Note Set 02 – The Relational Model of Data & Relational Algebra
- Note Set 03 – SQL Part 1
- 03b – Setting up Northwind DB
- Note Set 04 – SQL Part 2
- Note Set 05 – SQL Part 3
- Note Set 06 – HuskyGram Queries — Sample Solutions
- Note Set 07 – SQL Part 4 (SELECT Wrap Up) END OF MATERIAL FOR EXAM 1!
- Note Set 08 – SQL DDL Part 1
- Note Set 09 – SQL DDL Part 2
Exam Prep
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 SQL questions used the Northwind Data Model.
- Material coverage might be slightly different.
- Use this as a sample for types of questions, structure, etc.
- Exam 1 SQL Queries will use the Chinook Data Model
Exam 2
- 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 6 @ 11:59 pm
- Regular Due Date: Monday July 7 @ 11:59 pm
- HW 01 – Solutions
- HW 02 – Relational Algebra & SQL
- EC Due Date: July 13 @ 11:59 pm
- Regular Due Date: July 14 @ 11:59 pm
- HW03 – Exam Cheat Sheet
- Submitted with Exam
- HW04 – SQL DDL
- EC Due Date: July 27 @ 11:59pm to GradeScope
- Regular Due Date: July 29 @ 11:59pm to GradeScope
- HW05 – ER Modeling
- EC Due Date:
- Regular Due Date:
- HW06 – The Hardest Homework Assignment Ever
- EC Due Date:
- Regular Due Date:
Project Info
- Project Overview and Phase 1 Handout
- Phase 1 Submission Template
- Phase 2 Handout – Design the Database
- Phase 2 Submission Template
- Phase 3 Handout – Building the App
- Phase 3 Submission Template
Project Development Tips, Tutorials, and Documentation
- Fontenot’s Video Tutorials for Summer 24 Project
- 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!