DEMO S.Q.L : PROJECT ONE.

"I Built an Employee DB in PostgreSQL — Here's How"
From schema design to constraint testing, this is a complete walkthrough of a PostgreSQL employee database project. Five tables, eight employees, four cities, and enough constraint violations to make any DBA proud. Watch to see how relational design, foreign keys, and views come together in a real project.

Tutorial/Educational Tone
"Building an Employee Database from Scratch with PostgreSQL | Full SQL Project"
In this video, I walk you through designing and building a fully normalized employee database using PostgreSQL. We cover everything from creating lookup tables for departments, roles, and salaries, to linking them together with foreign keys in a central Employees table. You'll learn how to enforce data integrity using PRIMARY KEY, UNIQUE, CHECK, and NOT NULL constraints — and then deliberately break them to see exactly what errors PostgreSQL throws. We also build a clean detail view using LEFT JOINs so you can query all employee information in one place. Perfect for beginners learning relational database design or anyone studying for SQL assessments.
What you'll learn:

Relational database design and normalization
Creating tables with constraints in PostgreSQL
Foreign key relationships and referential integrity
How ON DELETE SET NULL behaves in practice
Writing views with multi-table LEFT JOINs
Constraint violation testing and error handling.

"PostgreSQL Employee Database | SQL Portfolio Project"
This video showcases a PostgreSQL database project I built as part of my data/software portfolio. The database manages employee records across four South African city offices, storing department, role, salary, and overtime data in separate normalized tables linked to a central Employees table. I demonstrate the full build — schema design, sample data insertion, constraint violation testing, and a summary view — and explain the design decisions behind each step.

🗄️ Building an Employee Database from Scratch with PostgreSQL

In this video, I design and build a fully normalized Employee Database
using PostgreSQL — from schema design all the way to constraint testing
and views. This is a complete, real-world SQL project covering
relational database design, data integrity, and query optimization.

─────────────────────────────────────
🔧 WHAT'S COVERED IN THIS PROJECT
─────────────────────────────────────
✅ Designing a normalized relational schema (5 tables)
✅ Creating lookup tables: Department, Roles, Salaries & Overtime
✅ Building a central Employees table with foreign key relationships
✅ Enforcing data integrity with PRIMARY KEY, UNIQUE, CHECK & NOT NULL
✅ Testing constraint violations and understanding PostgreSQL errors
✅ ON DELETE SET NULL referential integrity behaviour in action
✅ Writing a multi-table LEFT JOIN view for clean employee reporting
✅ Performance indexing on foreign key and name columns

─────────────────────────────────────
🛠️ TOOLS & TECHNOLOGIES
─────────────────────────────────────
- PostgreSQL
- pgAdmin 4
- SQL (DDL, DML, Views, Indexes, Constraints)

─────────────────────────────────────
📁 PROJECT STRUCTURE
─────────────────────────────────────
Database : project_1_analysis
Tables : Department | Roles | Salaries | Overtime_Hours | Employees
View : vw_employee_detail
Cities : Durban | Cape Town | Johannesburg | Pretoria

─────────────────────────────────────
📌 CHAPTERS
─────────────────────────────────────
0:00 - Introduction & Project Overview
- Database & Schema Design Explained
- Creating the Department Table
- Creating the Roles Table
- Creating the Salaries Table
- Creating the Overtime_Hours Table
- Creating the Employees Table & Foreign Keys
- Adding Indexes for Performance
- Inserting Sample Data
- Constraint Violation Testing
- ON DELETE SET NULL Demo
- Building the Employee Detail View
- Final Query & Results Walkthrough
13:19 - Wrap Up & Next Steps

─────────────────────────────────────
🔗 CONNECT WITH ME
─────────────────────────────────────
GitHub : https://github.com/kabeloxabendlini
Get
Portfolio : https://kabeloxabendlini.github.io/Kabelo_Xabendlini_Repository_Portfolio_For_My_Online_Profile/

─────────────────────────────────────
#PostgreSQL #SQL #DatabaseDesign #TechPortfolio #developer

"If you found this project helpful, give it a like and subscribe
for more SQL and database projects. The next video covers
[your next topic] — check it out right here. See you there!"

Видео DEMO S.Q.L : PROJECT ONE. канала Kabelo Xabendlini