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

Database modeling and SQL studies focused on relational architecture, data integrity, performance optimization, and scalable system design using MySQL, PostgreSQL, and SQL Server.

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.

This project is a clean, production-ready database built for pharmaceutical factories. It uses PostgreSQL to automatically track raw materials, handle expiry risks, and manage safe product recalls. With smart automation built right in, it keeps data accurate and ensures strict quality standards without messy manual updates.

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.

📚 RDBMS Glossary is a comprehensive, interactive reference for relational database management systems — covering 147+ terms across SQL syntax, RDBMS concepts, data modeling, database architecture, and tools. Each entry includes a clear definition, importance rating, code example with syntax highlighting, related terms with clickable navigation.

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.

Análisis ACID vs BASE y selección RDBMS/NoSQL para multinacional alimenticia latinoamericana. Ciclo de vida de ingeniería de datos. Módulo ESC420, Maestría Arquitectura de Software, Politécnico Grancolombiano.

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

Distributed multi-region fleet IoT database architecture using CockroachDB, Docker, Python, and SQL. Simulates geo-partitioned vehicle telemetry, trip tracking, maintenance records, distributed joins, replication, and regional data placement across US East, US Central, and US West clusters.

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

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.

Cinematic, high-performance HTML5 Canvas engine that visualizes database systems under load. Demonstrates failure, scaling, replication, caching, and optimization through real-time animation. Zero dependencies, production-grade rendering, and system architecture storytelling in a single-page app.

This project demonstrates database sharding using PostgreSQL with multiple shards

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.

🏥🗄️ Enterprise-grade Oracle PL/SQL database schema powering the HelloMed digital health platform. Built with 24 relational tables, automated trigger/sequence lifecycles, and modular PL/SQL packages integrated with Laravel 11 via an OCI8 bridge.

Database Architectures - Practical Assignment #2 - XML Extension