PostgreSQL extension for honeysql

Repository class to run SQL functions available in the PostgreSQL database

This is an example of how to calculate the distance between two GPS coordinates as a function in MySQL.

👩‍💻 Utility scripts, functions and stored procedures for Microsoft Sql Server, in the real life... 👨‍💻

PHP macros for various SQL functions that SQLite doesn't natively support.

Maintenance application for a fictional theme parc

Assignment for UCSC Extension's DBDA X409 (MySQL and Oracle Database for Developers and Designers).

MSSQL exercises

Commonly Used SQL Functions

A debugger to MySQL procedure and functions. RAISE NOTICE '???'

Analysed data to identify top-selling artists, top customers, and top performing genre

Data Analytics Projects

User defined functions for converting UUID values to and from binary.

Obligatorio Base de Datos 2 (Semestre 3 - Agosto 2021) Calificación: 40/40

Console applications for connection to the Microsoft SQL Server, how to update rows, how to read the table and how to call the stored function and the stored procedure. Complete example collection including Docker and SQL init. Code for Java built by the Maven, for Java built by the Gradle, for C# built by the .NET Framework and for PHP.

Testing my SQL skills with challenges 💻

Banco de dados PL/SQL de um Super Mercado ficticio chamado SMO (SuperMarket OMCorp)

Repository with files that I worked upon during the DBS311 (Advanced Database Services) course.

Netflix Originals Data Analysis: Exploring Trends and Insights

This repository contains SQL scripts for transaction analysis and customer insights. It includes scripts for data management, transformation, and optimization within MySQL Workbench. Documentation is provided to ensure clarity and maintainability of SQL queries for analyzing transactional data.