SQL Query Projects
20 free SQL Query projects with source code and tutorials.
SQL ETL Pipeline Queries
Build extraction and transformation queries for data warehouse loading pipelines.
SQL Security & Injection Prevention
Prevent SQL injection with parameterized queries, input validation, and least privilege.
SQL Cross-Database Compatibility
Write portable SQL across MySQL, PostgreSQL, and SQL Server with dialect differences.
SQL Query Debugging Techniques
Debug slow queries with profiling, execution plans, and statistics analysis tools.
SQL Constraint & Schema Design
Design robust schemas with CHECK, UNIQUE, FK constraints, and normalization rules.
SQL Dynamic Query Building
Generate dynamic SQL safely with parameterized queries and prepared statements.
SQL Data Aggregation & Reporting
Build complex reports with GROUP BY, ROLLUP, CUBE, and GROUPING SETS.
SQL Full-Text Search Implementation
Build search functionality with full-text indexes, relevance ranking, and stemming.
SQL Transaction & Isolation Levels
Manage ACID transactions with savepoints, isolation levels, and deadlock prevention.
SQL Set Operations & Comparisons
Combine result sets with UNION, INTERSECT, EXCEPT and compare datasets efficiently.
SQL Views & Materialized Views
Create views for data abstraction and materialized views for query performance gains.
SQL Triggers & Event Automation
Implement BEFORE/AFTER triggers for audit logging, validation, and cascading updates.
SQL Stored Procedures & Functions
Create reusable stored procedures with parameters, cursors, and error handling.
SQL JSON Data Querying
Query and manipulate JSON columns with JSON_EXTRACT, JSON_AGG, and path expressions.
SQL Subquery & Correlated Patterns
Master scalar, table, and correlated subqueries for complex data retrieval scenarios.
SQL Date & Time Query Patterns
Handle time zones, date arithmetic, calendar tables, and fiscal year calculations.
SQL Pivot & Unpivot Techniques
Transform rows to columns and back using PIVOT, UNPIVOT, and conditional aggregation.
SQL Recursive CTEs for Hierarchies
Query hierarchical data like org charts and threaded comments using recursive CTEs.
SQL Performance Optimization Guide
Optimize queries with EXPLAIN plans, index strategies, and query rewriting techniques.
SQL Window Functions Masterclass
Master ROW_NUMBER, RANK, LAG, LEAD, and running totals with window functions.