Database Design & Management with MySQL and RDBMS Concepts

Home
Courses
Database Design & Management with MySQL and RDBMS Concepts

Modules and Content

1. Database Fundamentals & ER Modeling

RDBMS principles, schemas
Entity Relationship (ER) diagrams

2. SQL Essentials – CRUD & Joins

Select, Insert, Update, Delete
Multi-table joins, nested queries

3. Constraints, Normalization & Keys

Primary/Foreign keys, UNIQUE, CHECK
Normal forms (1NF to 3NF)

4. Advanced SQL Functions & Stored Procedures

Triggers, Views, Transactions
Group functions, subqueries

5. Mini Project: Inventory or Student Management System

Schema design, relationships, advanced queries

Reference

“Piping Handbook” by Mohinder L. Nayyar ,
“Process Piping: The Complete Guide to ASME B31.3” by Charles Becht IV,
“Pipe Stress Engineering” by Liang-Chuan Peng and Tsen-Loong Peng
“Piping Design Handbook” by John J. McKetta Jr.
“The Planning Guide to Piping Design” by Richard Beale and David R. Sherwood