SQL Lessons - TaleyLearn

TaleyLearn

Lessons
Practice
LeyBot
About
Resources
Contact
Login
Sign Up

Filter by Difficulty

All Levels Beginner Intermediate Advanced

Browse by Topic

Data Retrieval 10

What is SQL? - Introduction Beginner Introduction to SELECT Statements Beginner Filtering Data with WHERE Beginner Sorting and Limiting Results Beginner Working with NULL Values Beginner Pattern Matching with LIKE Beginner Basic String Functions Beginner Grouping Data with GROUP BY Intermediate Filtering Groups with HAVING Intermediate Aggregate Functions Intermediate

Table Joins 7

Introduction to Joins Intermediate INNER JOIN Intermediate LEFT and RIGHT JOIN Intermediate OUTER and CROSS JOIN Intermediate SELF JOIN Intermediate Multi-Table Joins Intermediate Aggregations with Joins Intermediate

Advanced Topics 10

Subqueries and Nested Queries Advanced UNION and Set Operations Advanced CASE Expressions - Conditional Logic Advanced Creating and Using Views Advanced Indexes and Query Optimization Advanced Transactions and ACID Properties Advanced Combining SQL Concepts Advanced Date and Time Functions Advanced Mathematical and Conversion Functions Advanced User Management, Privileges, and Roles Advanced

Database Design 4

Introduction to Relational Databases Intermediate Understanding Data Quality & Structure Intermediate Database Normalization Intermediate Designing a Normalized Schema Intermediate

Constraints 4

Primary Keys Constraints Beginner Foreign Keys Constraints Beginner NOT NULL & UNIQUE Constraints Beginner CHECK & DEFAULT Constraints Beginner

Data Definition Language 2

Creating Tables Beginner Altering and Dropping Tables Beginner

Data Manipulation Language 3

Adding Data to Tables Beginner Modifying Data in Tables Beginner Removing Data from Tables Beginner

🔍

Intermediate

Multi-Table Joins

⏱ 50 min 📚 Table Joins

Start Learning

Intermediate

Aggregations with Joins

⏱ 50 min 📚 Table Joins

Start Learning

← Previous 1 2 Next →

Learn

Beginner Track
Intermediate Track
Advanced Track
Practice SQL

Support

Ask LeyBot
About Us
Resources
Contact

Account

Login
Account
Dashboard
Settings

Resources

Login
Privacy
Terms
Refunds

© 2026 TaleyLearn. All rights reserved.