This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.

Data-diff solution for dbt-ers with Snowflake ❄️ 🚀

Collection of useful functions, stored procedures and SQL scripts to facilitate your job!

TSQL Stored Procedure which gets a ClientID and a CreditCardNo passed by parameters, encrypts this last one with a random key and it insert or update in a table, depending wheter already exists or not.

Microsoft SQL Server project which utilizes a stored procedure to extract and generate mac(s)

Formats a SQL result set in a JSON format. Built and tested for MySQL and MemSQL