SQL

Tackle data engineering challenges for the Drupal Community projects.

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.

Database schemas in Go, made simple

Talkify provides a robust web app template built on a Flask backend, with a responsive and familiar frontend powered by Bootstrap CSS. It is designed to serve as a foundational boilerplate for developers looking to scale their Flask projects and explore the implementation of essential, dynamic features. The core focus of this template is to offer a clear example of how to build and integrate a user messaging system, manage user sessions securely and effectively, and extend functionality with other open-source JS and CSS libraries. For enhanced organization and maintainability, the project follows a modular structure where each page is linked to its own dedicated CSS and JavaScript files.

Interactive Grafana dashboards for monitoring recruiting pipelines using BigQuery and SQL.

МДК 01.01 Разработка программных модулей (Спиридонова Т.С.) [Петровский колледж]

IO-sw: IO server generic software prototype

Kurs-Material für einen SQL-Kurs, konzipiert als Kurs und Nachschlagewerk.

Die aktuelle Build-Version ist direkt abrufbar unter:

https://oer-kurse.gitlab.io/datenbanken/

Solution builder. Video: https://youtu.be/JJG15EN-VIU

Simple TODO-list app made in Java.

bioinfo

JSON to SQL query generator

Overview of Database System