ChatWhole Learn works best with JavaScript enabled. Please enable JavaScript in your browser settings.

🎉 75% of content is free forever — Unlock Premium from $10/mo →

💼 Services ℹ️ About ✉️ Contact View Pricing Plansfrom $10

Get started free →Sign in

sql

120 tutorials found

Advertisement

Related Topics

data analysis database query sql advanced sql fundamentals advanced sql dml performance sql joins sql aggregation etl optimization sql database objects window functions bigquery

SQL(70)

SQL Introduction

SQL Fundamentals

Database Concepts

SQL Fundamentals

SQL Data Types

SQL Fundamentals

CREATE TABLE Statement

SQL Fundamentals

INSERT INTO Statement

SQL Fundamentals

SELECT Statement

SQL Fundamentals

WHERE Clause

SQL Fundamentals

SELECT DISTINCT

SQL Fundamentals

ORDER BY Clause

SQL Fundamentals

LIMIT and OFFSET

SQL Fundamentals

Aliases (AS)

SQL Fundamentals

UPDATE Statement

SQL Fundamentals

DELETE Statement

SQL Fundamentals

AND, OR, NOT Operators

SQL Fundamentals

IN and BETWEEN Operators

SQL Fundamentals

LIKE Wildcards for Pattern Matching

Handling NULL Values with IS NULL

INNER JOIN for Combining Tables

LEFT JOIN for Left Outer Queries

RIGHT JOIN for Right Outer Queries

FULL OUTER JOIN

CROSS JOIN

Self JOIN

UNION, INTERSECT, EXCEPT

GROUP BY Clause

SQL Aggregation

HAVING Clause

SQL Aggregation

Aggregate Functions Overview

SQL Aggregation

COUNT, SUM, AVG

SQL Aggregation

MIN and MAX

SQL Aggregation

String Functions

SQL Aggregation

Date and Time Functions

Numeric Functions

Subqueries

Correlated Subqueries

CASE Expression

COALESCE and NULLIF

SQL Database Objects

SQL Views

SQL Database Objects

SQL Indexes

SQL Database Objects

SQL Constraints

SQL Database Objects

ALTER TABLE Statement

SQL Database Objects

DROP TABLE and TRUNCATE

Transactions (COMMIT, ROLLBACK)

Stored Procedures

User-Defined Functions

Database Triggers

Introduction to Window Functions

Window Functions

ROW_NUMBER, RANK, and DENSE_RANK

Window Functions

LEAD and LAG Functions

Window Functions

Introduction to Common Table Expressions

Common Table Expressions

Recursive CTEs

Common Table Expressions

Database Normalization

SQL Performance

Entity-Relationship Diagrams

SQL Performance

Query Performance

SQL Performance

EXPLAIN and ANALYZE

SQL Best Practices

SQL Joins Masterclass

Practicing SQL

SQL Glossary

SQL Cheatsheet

Advanced Window Functions

Window Functions

PIVOT and UNPIVOT

Working with JSON in SQL

Full-Text Search

PostgreSQL vs MySQL

SQL for Data Analysis

CTE Deep Dive

Table Partitioning

SQL ETL Pipelines

SQL Security

SQL A to Z

sql-advanced-premium(19)

Advanced Window Functions — Frame Clauses, Nested Windows & Analytics

Advanced SQLPremium

Recursive CTEs — Hierarchical Data, Graph Traversal & Tree Algorithms

Advanced SQLPremium

PIVOT & UNPIVOT — Matrix Reporting, Dynamic Columns & Data Reshaping

Advanced SQLPremium

LATERAL JOIN & CROSS APPLY — Correlated Joins, Row-by-Row Processing

Advanced SQLPremium

Temporal Queries & SCD — Time Travel, Gap Filling, Sessionization

Advanced SQLPremium

JSON Processing in SQL — Extraction, Transformation, Indexing & Aggregation

Advanced SQLPremium

Analytical SQL: Pivoting, Unpivoting, Grouping Sets, Cube

Advanced SQLPremium

Array & Nested Data Types — PostgreSQL Arrays, BigQuery ARRAYS, Collection Processing

Advanced SQLPremium

Advanced Analytic Functions — Regression, Statistics, Percentiles & Outlier Detection

Advanced SQLPremium

JSON in SQL: JSON_TABLE, Path Queries, Indexing JSONB

Advanced SQLPremium

Gap & Island Problems — Consecutive Sequences, Missing Data Detection

Advanced SQLPremium

Running Totals & Cumulative — Window Frames, Moving Averages, Cumulative Distribution

Advanced SQLPremium

Query Optimization Deep Dive — Execution Plans, Index Strategy & Performance Tuning

Advanced SQLPremium

Graph Queries in SQL: MATCH, Path Functions, Shortest Path

Advanced SQLPremium

Advanced Indexing Strategies — B-Tree, GIN, GiST, Partial & Covering Indexes

Advanced SQLPremium

Partition Pruning & Elimination — Range, Hash, List & BigQuery Partitioning

Advanced SQLPremium

Query Statistics & Execution Plans — EXPLAIN, pg_stat_statements, Performance Monitoring

Advanced SQLPremium

Dynamic SQL & Metadata Queries

Advanced SQLPremium

SQL Interview Problem Patterns

Advanced SQLPremium

sql-interview-premium(12)

Topic: SQL Window Functions Mastery for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Indexing Strategies for FAANG Interviews

SQL AdvancedPremium

Topic: Advanced SQL JOINs for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Data Modeling for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Pivoting and Unpivoting for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Table Partitioning for FAANG Interviews

SQL AdvancedPremium

Topic: JSON and XML Operations in SQL for FAANG Interviews

SQL AdvancedPremium

Topic: Finding and Removing Duplicates in SQL for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Performance Tuning for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Concurrency and Locking for FAANG Interviews

SQL AdvancedPremium

Topic: Regex and Text Processing in SQL for FAANG Interviews

SQL AdvancedPremium

Topic: SQL Security and Injection Prevention for FAANG Interviews

SQL AdvancedPremium

AI Agents(2)

Data Analysis Agent with Pandas and Visualization

Text-to-SQL Database Agent

Airflow(2)

BigQuery Integration in Apache Airflow

Snowflake Integration in Apache Airflow

azure-data-engineering(2)

Databricks Workflows, Jobs & SQL Analytics

Azure Data EngineeringPremium

Databricks SQL: Serverless, Alerts & SQL Warehouses

Azure Data EngineeringPremium

Data Engineering(2)

SQL Fundamentals for Data Engineers

Data Engineering Foundations

Advanced SQL for Data Engineers

Data Engineering Foundations

System Design(2)

SQL Deep Dive

NewSQL and Distributed SQL

Data Science(1)

SQL for Data Scientists

Module 5: Data Collection and SQL

data-scientist-interview-premium(1)

SQL Live Coding: Complex Queries, Optimization, Real-time Problem

Data Scientist Role InterviewPremium

dbt(1)

Jinja Templating in dbt

ds-interview-premium(1)

SQL: Window Functions, CTEs, Joins, Optimization

Data Science Interview PremiumPremium

gcp-data-engineering(1)

BigQuery Deep Dive - Architecture, SQL, Partitioning, and Clustering

PySpark(1)

Advanced Aggregations in PySpark

pyspark-interview-premium(1)

Topic: Spark SQL and Temporary Views

PySpark AdvancedPremium

Snowflake(1)

Snowflake Notebooks

spark-interview-premium(1)

Spark SQL: Predicate Pushdown, Column Pruning, Join Reorder

Apache SparkPremium