LearnFrenzy
Sign in Take a free test

Tutorial · 30 lessons

SQL Tutorial

Learn SQL step by step with MySQL: SELECT, WHERE, JOINs, GROUP BY, subqueries, window functions, CTEs, indexes and transactions, with real query results.

Start with lesson 1 View curriculum
  • Free
  • 10 chapters
  • 2h 57m of reading
Chapters
10
Lessons
30
Reading time
2h 57m
Level
All levels

Curriculum

What's inside this course

Read the chapters in order, or open any lesson. Completed lessons are ticked.

  1. 01 Introduction to SQL3 lessons · 17m
    1. What Is SQL? Databases, Tables and Keys 5 min
    2. Install MySQL and Run Your First Query 4 min
    3. The SQL Practice Database for This Course 8 min
  2. 02 Querying Data: SELECT and WHERE3 lessons · 18m
    1. SQL SELECT Statement 5 min
    2. SQL WHERE Clause: Filtering Rows 7 min
    3. SQL ORDER BY and LIMIT: Sorting and Paging 6 min
  3. 03 SQL Functions3 lessons · 19m
    1. SQL String Functions 6 min
    2. SQL Numeric and Date Functions 7 min
    3. SQL CASE WHEN and NULL Functions 6 min
  4. 04 Aggregation: GROUP BY and HAVING3 lessons · 16m
    1. SQL Aggregate Functions: COUNT, SUM, AVG 6 min
    2. SQL GROUP BY Clause 5 min
    3. SQL HAVING Clause and ROLLUP 5 min
  5. 05 SQL Joins3 lessons · 18m
    1. SQL INNER JOIN 6 min
    2. SQL LEFT JOIN, RIGHT JOIN and FULL JOIN 6 min
    3. SQL Self Join, Cross Join and Multi-Table Joins 6 min
  6. 06 Subqueries and Set Operations3 lessons · 17m
    1. SQL Subqueries 6 min
    2. Correlated Subqueries and EXISTS 6 min
    3. SQL UNION, INTERSECT and EXCEPT 5 min
  7. 07 CTEs and Window Functions3 lessons · 21m
    1. SQL CTE: WITH Clause and Recursive CTEs 6 min
    2. SQL Window Functions: ROW_NUMBER, RANK, DENSE_RANK 7 min
    3. SQL LAG, LEAD, Running Totals and Moving Averages 8 min
  8. 08 Creating Tables and Changing Data3 lessons · 18m
    1. SQL CREATE TABLE, Data Types and Constraints 7 min
    2. SQL INSERT, UPDATE and DELETE 6 min
    3. SQL ALTER TABLE, TRUNCATE and DROP 5 min
  9. 09 Database Design and Indexes3 lessons · 16m
    1. Database Normalization: 1NF, 2NF and 3NF 6 min
    2. SQL Indexes and EXPLAIN: Query Optimization 5 min
    3. SQL Views 5 min
  10. 10 Transactions, Procedures and Interviews3 lessons · 17m
    1. SQL Transactions, ACID and Isolation Levels 5 min
    2. Stored Procedures, Functions and Triggers 5 min
    3. Top SQL Interview Questions with Answers 7 min

Preparing with friends?

Share this page with your study group or placement batch.

Popular

Cookie settings

Choose which cookies LearnFrenzy may use. You can change this at any time from “Cookie settings” in the footer.