Lectures

 

In-Class Activity - SQL Joins Practice with Bend Blockbuster Database

DATA 351: Data Management with SQL

Lecture 00: Course Mechanics

DATA 351: Data Management with SQL

This lecture covers the course mechanics for DATA 351: Data Management with SQL.

Jan 12, 2026
Lucas P. Cordova, Ph.D.

Lecture 01:Introduction to Data Management with SQL

DATA 351: Data Management with SQL

This lecture covers the introduction to data management with SQL.

Jan 12, 2026
Lucas P. Cordova, Ph.D.

Lecture 02: Being Selective with SQL

DATA 351: Data Management with SQL

This lecture covers the SELECT, WHERE, ORDER BY, and LIMIT clauses of SQL.

Jan 14, 2026
Lucas P. Cordova, Ph.D.

Lecture 03: Data Types

DATA 351: Data Management with SQL

This lecture covers the data types.

Jan 26, 2026
Lucas P. Cordova, Ph.D.

Lecture 04: Importing and Exporting Data

DATA 351: Data Management with SQL

This lecture covers the importing and exporting data.

Jan 26, 2026
Lucas P. Cordova, Ph.D.

Lecture 05: Math Operators and Functions

DATA 351: Data Management with SQL

This lecture covers the math operators and functions.

Jan 26, 2026
Lucas P. Cordova, Ph.D.

Lecture 06: SQL Joins

DATA 351: Data Management with SQL

This lecture covers SQL joins using the Blockbuster Bend database. We explore inner joins, outer joins, cross joins, and self joins with real examples from film rental data.

Feb 2, 2026
Lucas P. Cordova, Ph.D.

Lecture 07: Normalization and Data Modeling

DATA 351: Database Design

This lecture covers database normalization and data modeling fundamentals. We explore the normalization process from messy flat files to well-structured relational schemas, practice with the Dunder Mifflin employee dataset, explore database design for the Oregon Turtle Conservation project, and learn to create Entity-Relationship diagrams using draw.io.

Feb 2, 2026
Lucas P. Cordova, Ph.D.
No matching items