Athens University of Economics and Business (AUEB)
A Coding Factory @ AUEB SQL Project. Final Project
- Use of Microsoft SQL Server
- Campings Database Managment CAMPDW.
- Read the pre-project requirements for implementation here.
- Read my complete final project here.
- database-bulk.insert.sql
- creation of database
- creation of table campData
- Bulk insertion data from campData.txt given database file
- normalization-database.creation.sql
- Normalization (3d Normal Form)
- creation of relational database
- insert-data-into-tables.sql
- Selection of Data from campData and insertion into tables
- select-queries-and-optimization.sql
- Several Select Queries testing
- Index creation for queries optimization
- fact-table-creation-StarSchema.sql
- Fact Table creation (Star Schema)
- Data insertion into Fact Table
- fact-table-queries.sql
- Several Queries execution
- Rollup Report creation
- CUBE Report creation
- PowerBi report (included in complete final project link)
- Transition of this database from Microsoft SQL server to MySQL Server for the needs of campings-backend repository.
- Alterations for MySQL Server and full creation query can be found here : camping-database-MySQL.sql
