Click here to return to the schedule
Video Lecture (required)
This video is a quick introduction to relational operations and SQL using
SQLite Manager for Firefox. Be sure to follow along with the examples from
Section 9.2 of the textbook. I also illustrate what it's like working with
real data sets and why you would want to use a database system instead of
spreadsheet software. Here is a
pdf version of the slides.
Note: SQLite Manager no longer works with recent versions of Firefox. We will use DB Browser for SQLite instead, which is already installed in the CS 101 virtual machine.
Questions & Exercises
Some of these questions will be on the next quiz. Remember the answers are in the back of the book.
- Sec 9.1 : 1, 3
- Sec 9.2 : 1, 4, 5
- Sec 9.6 : 2
Additional Clips (recommended)
Guru99 has a ton of free video tutorials on many programming topics. Check out their "What is Database? What is SQL?" tutorial, which is part of the "SQL Tutorial for Beginners" series. Or just watch the video below (does anyone read these paragraphs?).