Oracle SQL exercices from institute of technological studies of charguia DSI201 2023/2024

Database Analysis and Design for Train Reservation System. Analysis of User Requirments Phase, Design of ERD, Schema, Implementation of Physical Tables, Populating Data, and Queries to Analyze the Data. Views for the security of data and helping analyze the rest of the tables.

This case study not only underscores the strategic and innovative approach that has become Myntra's hallmark but also underscores its unwavering dedication to delivering a personalized, convenient, and comprehensive online shopping experience.

End-to-end process for building an SQL Azure database, performing data analysis with SQL and Python, and visualizing data with Tableau.

As a passionate database architect, I crafted Renter's Den - an innovative fashion rental platform. Seamlessly managing vast garment inventories, I ensured swift product tracking, easy customer sign-ups, and secure payment options. Join me in embracing sustainable fashion choices at #Renter'sDen. Let's revolutionize the way we wear! 🚀 🛒

Repository to store notes and exercises solutions of the PostgreSQL for Everybody specialization given by university of Michigan.

This project contains a database of an invented musical instruments store. Advisory: the data, although invented, should not be used for malicious purposes.

Database Architectures - Practical Assignment #2 - XML Extension

This project sets up a PostgreSQL-based data warehouse following the Medallion Architecture (Bronze → Silver → Gold). It includes scripts to create the main database and structured schemas for organizing raw, cleaned, and business-ready data. Ideal for analytics and ETL workflows.

End-to-end process for building an SQL Azure database, performing data analysis with SQL and Python, and visualizing data with Tableau.