Course Content
Advanced SQL Querying Techniques
0/3
Subqueries and Nested Queries
Complex Joins
Common Table Expressions (CTEs)
Window Functions and Ranking
0/3
Window Functions Overview
Ranking and Row Numbering
Moving Averages and Running Totals
Advanced Filtering and Conditional Logic
0/3
Complex Filtering with CASE WHEN
Advanced Pattern Matching
Date and Time Manipulations
Performance Optimization and Indexing
0/3
Query Optimization Strategies
Indexing for Faster Queries
Partitioning and Sharding
Advanced Aggregations and Statistical Functions
0/2
Advanced Grouping Techniques
Statistical Analysis in SQL
Pivoting and Unpivoting Data
0/2
Pivoting Rows into Columns
Unpivoting Columns into Rows
Recursive Queries and Graph Data Analysis
0/2
Recursive Queries with CTEs
Graph Database Queries in SQL
Transactions and Concurrency Control
0/2
ACID Properties and Transactions
Concurrency Control Mechanisms
NoSQL & JSON Handling in SQL
0/2
Working with JSON Data in SQL
SQL and NoSQL Hybrid Solutions
Case Studies and Real-World Applications
0/3
Performance Tuning in a Real-World System
Fraud Detection and Anomaly Detection with SQL
Customer Segmentation and Retention Analysis
Capstone Project
Advanced SQL Queries
Previous
Next