This repository contains reusable SQL tools designed for data engineers, analysts and developers. Each module works independently. Use them in any order that fits your project.
- Querying: SELECT, WHERE, JOIN, GROUP BY, ORDER BY, HAVING, subqueries, filtering, aggregation
- Data Manipulation: INSERT, UPDATE, DELETE, MERGE, transactions, bulk operations, data validation
- Schema Design: Primary keys, foreign keys, normalization (1NF, 2NF, 3NF), indexes, constraints, relationships
- Window Functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, SUM OVER, AVG OVER, frame specifications
- CTEs: Non-recursive CTEs, recursive CTEs, multi-step pipelines, hierarchical data
- Stored Procedures: CREATE PROCEDURE, parameters, error handling, control flow, best practices
- Performance Optimization: Execution plans, index strategies, query refactoring, benchmarking
- AWS: RDS patterns, Redshift optimization, cloud-specific SQL, migration strategies
Warning
This repository is under construction.