Brian Finnegan

4.25K subscribers

35 videos

Videos related to SQL, relational design, MySQL, and other database matters to supplement in-class material for various courses at various institutions.

Latest Videos

Widener MIS358 2025 lecture2

HW5Q7 Bonus Solution

Inner vs. Outer Joins in SQL

SQL Three Table Join Examples

EER to Relational Translation Techniques

SQL WHERE versus HAVING Example

Informal, ERD-centric Introduction to the Fifth Normal Form (5NF)

Fourth Normal Form vs ER Modeling

Normalization The First Normal Form

Referential Integrity in the Relational Model

Enhanced Entity-Relationship Model Part 2 Generalization vs. Specialization and EER Constraints

Update Anomalies

Normalization and the Third Normal Form

RDBMS Normalization Introduction to Second Normal Form

Introducing Functional Dependencies in Relational Design

When to Index an RDBMS

DBMS Indexing The Basic Concept

Introducing Aggregation in SQL

Introduction to Nested Select Statements

Translation Part 2

Translation Part 3A - Mapped Translation Introduction

Translation Part 1

Translation Part 4 - Mapped Translation w- Particpation (total-partial) Consideration

Additional Join Syntax Options

Translation Part 5 - Stable Translation

Translation Part 3B - Mapped Translation Applied

The Participation Constraint in the ER Diagram

Unary or Recursive Relationships in ERDs

Intro to Joins

Translation Part 6 - Multi-Relationship, ERD-wide Translation Example