Stocker: A Stock Tracking and Related News Website based on a MySQL database, as well as using some NoSQL techniques.

This repository contains labsheets from the Database Systems (IT3020) module, focused on relational and non-relational databases, object-relational features, XML and NoSQL models, indexing, query optimization, and transaction management. Developed for academic learning and practice.

This project focuses on scalable data processing and query performance optimisation. It uses Snowflake for data warehousing, GCP Cloud Functions for serverless compute, and Apache Kafka for real-time data streaming. It leverages the serverless capabilities of the systems for scalability and performance.

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

SQL projects for train booking & retail analytics

Contains implementations of various algorithms for database query optimization. The algorithms cover multiple problem variants (e.g., traditional and multi-objective query optimization) and offer different tradeoffs between optimality guarantees and optimization time (e.g., fast randomized algorithms, approximation schemes, exhaustive algorithms…

A collection of real-world SQL practice questions with solutions, designed to strengthen query skills for data analysis and business insights. Includes scenarios for aggregation, joins, filtering, and advanced SQL techniques.

Spring Boot demo comparing JPA lazy loading (N+1 problem) vs EntityGraph optimization. Shows performance difference between 11 queries vs 1 query for Books-Authors many-to-many relationship. Includes query counting, tests, and metrics.

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

The main task of this plugin is to increase the security of the site and improve the performance of the site by disabling completely unnecessary hooks and also optimizing SQL queries

Test different algorithms at ordering selection operators under conditions of uncertainity

CMU-DB's Cascades optimizer framework

Query Optimiser built for SJDB

Conducted a comprehensive analysis of Blinkit's sales performance, customer satisfaction, and inventory distribution to identify key insights and opportunities for optimization using various KPIs.

🗃️ MySQL-based relational database project focused on Ethiopian Airlines' booking system. Features include student discount logic and optimized queries.

Project on MapReduce for the Μ111 - Big Data Management course, NKUA, Spring 2023.

A collection of projects focused on demonstrating expertise in SQL, database design, and data analysis.

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.

twitcher

Repositório com exercícios do curso “.NET: avance na persistência com EF Core” da Alura. Aborda consultas avançadas, modelo rico, uso de transações, boas práticas com padrões arquiteturais e interceptação de comandos SQL com o Entity Framework Core.