Hands-on SQL lab work covering relational database design, table creation, data manipulation, and query optimization using MySQL Workbench. All work completed in a real MySQL environment applying industry-standard practices.
- Database design skills directly applicable to Electronic Health Records (EHR) systems
- SQL querying used in clinical data reporting and patient record management
- Data integrity techniques align with HIPAA compliance requirements
- CRUD operations mirror real-world hospital database administration tasks
- Listed and navigated databases using SHOW DATABASES and SHOW TABLES
- Retrieved records using SELECT with filtering and ordering
- Applied WHERE clauses to filter specific data
- Created new tables with primary keys and constraints
- Created a full relational database from scratch using CREATE DATABASE
- Designed and built tables with primary keys and AUTO_INCREMENT
- Inserted multiple records using INSERT INTO
- Updated existing records using UPDATE
- Deleted records using DELETE
- Verified all operations using SELECT queries
- MySQL 8.0
- MySQL Workbench
- SQL DDL and DML
- Relational Database Design
- Data Modeling and Schema Design
- Database creation and schema design
- Table design with primary keys and constraints
- Full CRUD operations (Create, Read, Update, Delete)
- Data filtering, sorting, and retrieval
- Data integrity validation
- SQL query writing and optimization
- Course: Database Essentials
- Program: Computer Programming
- Institution: Niagara College Toronto