This repository contains a series of exercises and projects from the 62-31 Database Advance Management course at Haute École de Gestion (HEG) It covers multiple database technologies, including PLSQL, JAVA JDBC, MongoDB, Neo4J, and Redis, with practical implementations.
- 📂 Multi-Database Exercises – Hands-on practice with different database management systems.
- 📊 MongoDB – NoSQL document database for scalable applications.
- 🔗 Neo4J – Graph database for relationship-driven data models.
- 📜 PLSQL – Procedural SQL for Oracle databases.
- ⚡ Redis – In-memory key-value store for high-speed data access.
- ☕ Java JDBC – Database connectivity with SQL databases.
- 📝 Query Optimization & Transactions – Exploring indexing, joins, and ACID properties.
The repository is organized into different folders corresponding to each database technology:
- 📁 Documentation → Course slides, theroy materials and references.
- 📁 Examen → Exam-related exercises and projects.
- 📁 Programmes → Database installation files and tools.
- 📁 TP_All → General database exercises covering multiple topics.
- 📁 TP_Java_SQL → Java SQL exercises using JDBC.
- 📁 TP_MongoDB → ands-on exercises and projects using MongoDB queries, operations and aggregation.
- 📁 TP_Neo4J → Relationship modeling, Cypher queries, and graph database design.
- 📁 TP_PLSQL → Oracle PLSQL procedures, triggers, and packages.
- 📁 TP_Redis → Commands and data operations for in-memory data handling and caching strategies.
Before starting, ensure you have installed:
- Java JDK 17 or later: Download here
- MongoDB 7.x: Download here
- Neo4J 5.x: Download here
- Oracle Database with PLSQL: Download here
- PLSQL Developer or Oracle SQL Developer: Download here
- Redis 3.2+: Download here
- JDBC Driver for Java: Download here
- Java JDBC Documentation: https://docs.oracle.com/javase/tutorial/jdbc/
- MongoDB Documentation: https://www.mongodb.com/docs/manual/
- Neo4J Documentation: https://neo4j.com/developer/
- Oracle PLSQL Guide: https://docs.oracle.com/en/database/oracle/oracle-database.html
- Redis Documentation: https://redis.io/documentation
This project is licensed under the Creative Commons Attribution-ShareAlike (CC BY-SA) license.
Project created by Daniel Garcia as part of the 62-31 Database Advance Management course at Haute École de Gestion (HEG) during the Autumn semester of 2023.