0. Class Orientation
Presenter(s): Lingma Acheson
Status: Available
Length: 11 Minutes 4 Seconds
Goals of the class, tools to be used, and password for taking the orientation quiz.

1a. What & Why Database?
Presenter(s): Lingma Acheson
Status: Available
Length: 21 Minutes 17 Seconds
What is a database and why do we need a database tool?

1b . Create an Access Database
Presenter(s): Lingma Acheson
Status: Available
Length: 23 Minutes 36 Seconds
Terms and structures of an Access database. Must know these before you start creating a database!

1b Demo 1. Opening an existing Access Database
Presenter(s): Lingma Acheson
Status: Available
Length: 12 Minutes 2 Seconds
Open an Access Database and get familar with the interface.

1b Demo 2. Create a new Access Database
Presenter(s): Lingma Acheson
Status: Available
Length: 24 Minutes 1 Second
Create a database of your own, define tables and fields, and enter data.

2 . Relational Model
Presenter(s): Lingma Acheson
Status: Available
Length: 32 Minutes 42 Seconds
Explains how data can be stored in relations, concepts and usage of primary keys and foreign keys.

2 Demo. Relational Model
Presenter(s): Lingma Acheson
Status: Available
Length: 15 Minutes 24 Seconds
How to set primary keys and foreign keys, how to define relationships.

3a . SQL - SELECT Statement
Presenter(s): Lingma Acheson
Status: Available
Length: 21 Minutes 8 Seconds
Concept and purpose of the SQL language. Usage and examples of SELECT statements.

3a Demo. SQL - SELECT Statement
Presenter(s): Lingma Acheson
Status: Available
Length: 23 Minutes 37 Seconds
How to create and save a SQL command. SELECT statement examples.

3b . SQL - WHERE Clause
Presenter(s): Lingma Acheson
Status: Available
Length: 16 Minutes 14 Seconds
How to retrieve certain rows from a table.