Skip to content

Latest commit

 

History

History
24 lines (20 loc) · 1.14 KB

README.md

File metadata and controls

24 lines (20 loc) · 1.14 KB

MySQL Projects

Overview

A collection of MySQL database projects and assignments demonstrating my skills in relational schema design, query writing, and data analysis.

Contents

  • EXAM 1 – SQL scripts and solutions from a course exam. Includes creating tables, populating data, and writing analytical queries.
  • P3 Submission – Capstone project: designing a normalized schema for an e‑commerce dataset, with stored procedures and triggers.
  • Vehicles homework – Practice with JOINs and subqueries using a vehicle-ownership dataset.
  • flight – Flight-booking schema and sample queries. Includes ERD and CSV seed data.

How to Use

  1. Install MySQL (version 8+).
  2. From the command line, run scripts in each folder: 
    mysql -u youruser -p < flight/flight_mysql_dump.sql
  3. Explore the provided .sql files to understand the schema and queries.

Professional Value

These projects illustrate my ability to:

  • Design normalized schemas and convert requirements into SQL.
  • Write complex queries involving JOINs, aggregation, and subqueries.
  • Use stored procedures and triggers for application logic within the database.