SQL Tutorial Home

SQL Tutorial

CONTENTS

SQL Tutorial Home

SQL SELECT Statement
SQL ORDER BY and SQL LIMIT
Using SQL WHERE Clause With Comparison Operators
Using Logical Operators in WHERE clause
SQL BETWEEN and SQL LIKE in WHERE Clause
SQL IS NULL Operator in WHERE Clause
SQL Data Types
SQL CASE Clause in SQL Queries

SQL GROUP BY Clause in a SELECT Query
Aggregate Functions in SQL
SQL Having Clause
SQL Subqueries: The Super Powerful SQL Feature
SQL DISTINCT Clause
SQL Date and Time Functions and Data Types
SQL String Functions

SQL Correlated Subqueries Increase the Power of SQL
SQL Window Functions
SQL Window Function Examples
Selecting Data From Multiple Tables: SQL JOINS
Visual Representation of SQL JOINS
Query Optimization
SQL Indexes

SQL (Structured Query Language) is a programming language designed for the retrieval and management of data in a relational database.

SQL is the bedrock of business intelligence. This SQL tutorial provides basic and advanced concepts of SQL, designed for beginners and professionals. No prior DB experience is required.

Basic SQL

It's time to dive in and learn some basics of SQL.

SQL SELECT Statement
SQL ORDER BY and SQL LIMIT
Using SQL WHERE Clause With Comparison Operators
Using Logical Operators in WHERE clause
SQL BETWEEN and SQL LIKE in WHERE Clause
SQL IS NULL Operator in WHERE Clause
SQL Data Types
SQL CASE Clause in SQL Queries

Intermediate SQL

Once you have the basics mastered, this section will take your knowledge to the next level.

SQL GROUP BY Clause in a SELECT Query
Aggregate Functions in SQL
SQL Having Clause
SQL Subqueries: The Super Powerful SQL Feature
SQL DISTINCT Clause
SQL Date and Time Functions and Data Types
SQL String Functions

Advanced SQL

This section covers the advanced SQL topics including correlated subqueries, SQL Window Functions and SQL JOINS.

SQL Correlated Subqueries Increase the Power of SQL
SQL Window Functions
SQL Window Function Examples
Selecting Data From Multiple Tables: SQL JOINS
Visual Representation of SQL JOINS
Query Optimization
SQL Indexes

SQL SELECT Statement