CS 101: Database Videos
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.

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?).