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

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

Netflix Originals Data Analysis: Exploring Trends and Insights

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

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.

Función básica en SQL Server que retorna el mes en letras, recibe un número (1-12) y retorna el mes en letras

Couple of funtions I wrote long time ago maybe, that you might find useful for your project

Commonly Used SQL Functions

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

Normalizing tables and creating a relational database 🗃️

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

Data Analytics Projects

Projects on SQL & Python

Console applications for connection to the MySQL, 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.

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

Conteúdo para estudo de funções em linguagem sql, escrita com postgresql

user custom mysql functions

Proyecto SQL de gestión de equipamiento y enlaces a Internet para la empresa de logística "Mundo Trade". Implementa técnicas avanzadas de SQL para garantizar la integridad y eficiencia del sistema y la correcta administración de datos.

Database - Public Health Center Community Survey