Design and implementation of a relational database with SQL: data modeling, schema creation, data loading, and querying. Data Engineer program project
Project from the Data Engineer program - OpenClassrooms
This project focuses on practicing SQL and building a relational database from scratch. It aims to strengthen skills in database design, data modeling, SQL querying, and data extraction — essential competencies for any Data Engineer role.
- Design and model a relational database
- Create database schemas using UML and relational models
- Implement the database structure using SQL
- Load and verify data integrity
- Write SQL queries to extract and analyze data
- SQL (PostgreSQL / MySQL / SQLite)
- UML Class Diagrams
- DBMS (Database Management System)
- SQL Client (DBeaver, pgAdmin, MySQL Workbench, etc.)
- Data Modeling & Relational Design
- SQL DDL (Data Definition Language)
- SQL DML (Data Manipulation Language)
- Complex SQL Queries (SELECT, JOIN, GROUP BY, Subqueries, etc.)
- Data Integrity and Constraints
- Program: Data Engineer (OpenClassrooms)
- Duration: ~30 hours
- Type: Training & Practical Exercises
/diagrams/- Database diagrams & models/sql/- SQL scripts for database creation, insertion & queries/documentation/- Additional explanations and design choices