Skip to content
Sabaqاردو

Complete SQL, Beginner to Advanced (techTFQ)

By techTFQ

Course audio
Course audio: English
Level
Intermediate
Length
15 lessons

What you'll be able to do

  • Write joins, subqueries and CTEs with confidence
  • Rank and compare rows with window functions
  • Use views, recursive queries and stored procedures

About this course

Thoufiq Mohammed of techTFQ teaches SQL with a strong focus on writing real queries. The playlist starts with a roadmap for learning SQL for free, what a database is and installing PostgreSQL, then covers SQL basics with practice queries, joins in depth, correlated subqueries, the WITH clause, window functions such as RANK, DENSE_RANK, LEAD and LAG, frame clauses, views, recursive queries, turning rows into columns, stored procedures and materialised views. It suits learners who want analyst-level SQL and interview practice. Solve his practice problems after each topic.

Before you start: Comfort with spreadsheets or basic data

Syllabus

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

  1. 1How to learn SQL for free | Roadmap to learning SQL
  2. 2Learn What is Database | Types of Database | DBMS
  3. 3How to install PostgreSQL on Mac OS | Install and Uninstall PostgreSQL Database
  4. 4SQL Basics Tutorial for Beginners (Practice SQL Queries)
  5. 5SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1
  6. 6SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2
  7. 7Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorial
  8. 8SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression)
  9. 9SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial
  10. 10SQL Window Function | How to write SQL Query using Frame Clause, CUME_DIST | SQL Queries Tutorial
  11. 11SQL Views Tutorial | VIEWS in SQL Complete Tutorial
  12. 12Recursive SQL Queries Tutorial | Learn to write SQL Queries using Recursion
  13. 13Solving SQL Query | Rows to Column in SQL
  14. 14Procedure Tutorial in SQL | SQL Stored Procedure | Procedure in SQL
  15. 15Materialized View in SQL | Faster SQL Queries using Materialized Views

What to take next

Related courses

Videos by techTFQ, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request