Commonly Used SQL Functions
-
Updated
May 6, 2024
Commonly Used SQL Functions
ITI Project — A SQL Server database for a delivery management system featuring stored procedures, views, functions, audit triggers for all tables, order lifecycle automation, VIP customer classification, and full data protection rules.
Pipeline ETL de auditoría médica para detección de fraude financiero. CTEs en PostgreSQL + transformación 100% vectorizada en Pandas/NumPy. Cubierto con pruebas unitarias (pytest).
Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.
To associate your repository with the sql-advanced topic, visit your repo's landing page and select "manage topics."