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

A containerized distributed data processing system that demonstrates core cloud database concepts through hands-on implementation using Java, Apache Arrow, Iceberg, and Calcite

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

A secure, ACID-compliant banking database system featuring stored procedures for safe money transfers and automated triggers for fraud detection.

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.

Comprehensive AWS multi-database architecture implementing enterprise-grade RDS Multi-AZ, cross-region read replicas, real-time data processing with Kinesis & DynamoDB, and intelligent caching solutions. Demonstrates high-availability database design, automated backup strategies, and performance optimization for nationwide branch operations.

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

Automated data pipeline scraping fuel prices daily, apply transformations and load the data to a PostgreSQL database.

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! 🚀 🛒

A collection of mysql database server working together following master-slave architetucture pattern to provide, persist and manage data, follworing indrustry standards.

Collection of database schema designs for various business domains - E-commerce, Healthcare, Inventory Management

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.

Database Architectures - Practical Assignment #2 - XML Extension

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

A collection of eight production-grade system designs covering MLOps, data engineering, AI security, orbital autonomy, infrastructure architecture, and database architecture. Built to teach how systems behave in production, not just at design time.

This repository contains database schema designs that follow industry best practices. The schemas are designed with scalability, modularity, and maintainability in mind, and they are freely available for developers to use, study, and improve upon.

This project demonstrates database sharding using PostgreSQL with multiple shards

Export PostgreSQL schema to DBML (dbdiagram.io). Standard library only, uses `psql`, stable diffs, handles real-world Postgres edge cases.

🌐 Build a robust AWS multi-database architecture for enterprise solutions, ensuring high availability and efficient data processing across regions.

🔍 Explore FoundationDB's Data Storage Wrapper for seamless integration and efficient data management in distributed systems.

A "Zero Trust" SQL Server architecture that moves security logic from the API layer directly into the database schema using Stored Procedures, RBAC, and Physical Isolation.

🏦 Simulate a secure banking backend with ACID compliance, ensuring data integrity and safe transactions using MySQL stored procedures and triggers.

🗄️ Explore production-ready database schemas that prioritize best practices in design, normalization, and performance optimization.