SQL

Repository housing code files and study material for personal projects related to data engineering, data analytics, machine learning, game design and digital marketing engineering.

korykiai/demo shows how business users' interaction with relational databases for queries and data analysis can be improved using Large Language Models (LLM) and MCP to translate natural language to machine-executable statements.

🐘🕶️ Anonymization & Data Masking for PostgreSQL

https://labs.dalibo.com/postgresql_anonymizer

Diagrama Entidade-Relacionamento, definição de entidades e atributos, implementação no MySQL Workbench.

Portfólio acadêmico do 2º período do curso de ADS – projetos em algoritmos, programação em Python, modelagem de sistemas e integração.

Tackle data engineering challenges for the Drupal Community projects.

Relational database management system that uses YottaDB as the data store

Materials on various sections in Computer Science (CS). 🎓

Open-source project for managing Snowflake permissions and roles through YAML configuration

transqlate transpile SQL snippet from a dialect to another using an AST

Key platform data integrations repo

This project implements a MySQL database schema for managing data related to the SCP Foundation — a fictional organization that secures, contains, and protects anomalous entities and phenomena known as SCPs. The database is designed to store detailed information about SCP objects, containment procedures, personnel, experimentation records, alerts, and site management.

Benchmarked columnar vs row-oriented databases using the Yahoo Cloud Server Benchmark (YCSB). Compared throughput, latency, and error rates under different workloads. Analyzed trade-offs between NoSQL (Cassandra) and relational (PostgreSQL) databases with supporting graphs and configuration files.

Code used in articles

"DentalClinicDB" hosts SQL scripts for creating and managing a dental clinic database in Oracle RDBMS to practice SQL, NoSQL queries, and PL/SQL programming, reinforcing relational database theories and learning to meet user needs effectively.

Development SQLObject repository

Database schemas in Go, made simple

Cheat sheets for several programming languages and IT related tools.