Relational Database Design and Implementation 2026

Explore file based systems and their historical use, define what a database is, and identify the different types of databases and emerging technologies.

Explore how file-based data management evolved into modern databases, reducing data redundancy, inconsistency, and isolation, while enabling secure, concurrent access via database management software.

Explore how file system databases function and their modern usefulness, preview emerging technologies, and introduce the upcoming topic of entity relationship diagrams.

Explore the fundamentals of erd diagrams, including conceptual modeling, entities, attributes, relationships, cardinality, and participation, to design robust databases.

Choose the relational data model from four options and master converting an ERD to relational notation, understand relational keys, integrity rules, and how to convert relationships.

Explore first normal form by examining atomic values, single data types, and primary-key dependencies; convert unnormalized tables by separating multi-valued columns into separate rows and entities, such as emails.

Learn how second normal form eliminates partial dependencies and relates to first normal form, shown with an inventory example.

Learn how to achieve third normal form by eliminating transitive dependencies and ensuring no non-key attribute determines another, splitting tables into separate entities with primary and foreign keys.

Discover SQL essentials for designing and implementing a database, learn the different SQL statement types, and identify data types.

Discover SQL, a declarative language for interacting with relational databases. Write queries to retrieve, insert, update, and delete data, and create or modify tables, views, and constraints.

Explore the three core SQL statement categories: DDL, DML, and DCL. Learn how commands create, alter, drop, insert, update, delete, select, grant, and revoke shape database structure, data, and permissions.

Understand how column data types define allowable values, including integer, decimal, varchar, char, and date, and why first normalization may store different types in the same column.

Set up cloud and local laptop environments to follow along with MySQL, Postgres, or Oracle, and install SQL Server Management Tools, MySQL Workbench, and SQL Developer to connect via SQL.

Install SQL Server Management Studio and Azure Data Studio from Microsoft to manage SQL Server and Azure databases, and use Azure Data Studio for Postgres and Oracle on Mac.

Download and install pgadmin for Windows, selecting version 7.4, run the executable, accept terms, and launch pgadmin from the Start menu.

Download and install SQL Developer for Oracle from Oracle.com, selecting Windows 64-bit JDK 11 and accepting the license. Open the extracted app and prepare a database connection with plus icon.

Create an AWS free tier account and set up an Amazon RDS relational database, choosing MySQL, PostgreSQL, MariaDB, or SQL Server, enable public access, and configure security group rules.

Learn to set up a free AWS account and create a Microsoft SQL Server database with RDS, including configuring public access, security groups, and connecting via Azure Data Studio.

Connect Azure Data Studio to your local SQL server. Install extensions for Oracle, MySQL, and Postgres, customize the workspace, and prep for building your database and ERD.

This lecture moves from theory to practice by implementing a simple ERD, creating a car rental database in Azure Data Studio, and switching databases with the use statement.

Learn to use the create table statement to build tables with primary keys (including composite keys), not null constraints, and foreign keys that enforce referential integrity.

Explore the drop statement in SQL, learn how to drop tables and databases, and handle dependencies and foreign key constraints when deleting objects in a sample car rental database.

Master insert statements by exploring full and partial inserts, handling not null constraints, and inserting records. Learn to insert from one table to another and create backups with select into.

Explore the select statement syntax, including selecting all or specific columns, filtering with where, sorting with order by, and creating views as a security mechanism.

Learn to create generated columns by calculating age from date of birth with date functions and aliasing as age, and format sales price using cast and convert.

Explore aggregations using sum, average, count, min, and max on the car table. Learn how to alias results, group data by make, and apply having to filter aggregates.

Learn how to use join statements to query multiple tables with inner joins, including syntax, joining on common fields, aliases, and filtering with where clauses.

Learn how to use the update statement to modify existing data, apply where clauses to target records, and update single or multiple columns, including by primary key.

Learn how to use the delete statement to remove rows by primary key or criteria, or to delete all records, with examples of single and bulk deletions.