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. PLEASE NOTE we will not be using the SQLite Manager in Firefox, the Manager no longer
works with the new version of Firefox. The main objective of the video is to help introduce SQLite.
Be sure to follow along with the examples from
Section 9.2 of the textbook. We 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: We will use DB Browser for SQLite, which is discussed in your lab.
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?).