SQL coursework

My EHU/ESDE coursework for SQL (Relational Databases + SQL and Data Processing).

Tools and technologies used:

• PosgreSQL
• PowerBI
• Mockaroo
• Java + Spring Batch

Workflow:

1. Developing ER diagram
2. Creating DB using PosgreSQL - OLTP solution
3. Creating datasets: 2 .csv files containing data according to DB entities: file1 and file2
4. Writing a rerunable ETL script to load data from .csv files to our DB using Spring Batch
5. Building a snowflake DWH based on our initial DB (OLAP solution)
6. Writing a second ETL script to move data from OLTP DB to the OLAP one using Spring Batch
7. Creating a PowerBI report with visualisation
8. Writing detailed report on the project and steps performed

Project description

As a product owner, I'm eager to provide my projects with sustainable solutions, so the topic I've chosen refers to my educational project - @repet.hub. My application provides educational services (design, materials creating, video editing, curators' services) for teachers and online schools.

My DB refers to such entities as:

• Customer
• Performer
• Experience Level
• Subject
• Exam
• Country
• City
• Order

And provides a business solution for the DB layer of my application. It allows the customer to place an order, subscribe to our newsletter or simply receive a consultation from our customer support specialists.

Detailed documentation can be found here