SQL Learning Path
SQL Tutorial Topics
Learn SQL Step by Step
Explore SQL tutorial topics from beginner to advanced. Learn SQL syntax, queries, filtering, sorting, joins, aggregate functions, subqueries, indexes, transactions, database concepts, and more with practical examples.
SQL Tutorial Topics
What is SQL?
Topic #what-is-sql
History of SQL
Topic #history-of-sql
Features of SQL
Topic #features-of-sql
Why Learn SQL?
Topic #why-learn-sql
SQL vs MySQL
Topic #sql-vs-mysql
SQL vs NoSQL
Topic #sql-vs-nosql
Installing MySQL
Topic #installing-mysql
Installing PostgreSQL
Topic #installing-postgresql
Setting Up SQL Environment
Topic #setting-up-sql-environment
Understanding Databases
Topic #understanding-databases
Relational Database Basics
Topic #relational-database-basics
Tables in SQL
Topic #tables-in-sql
Rows and Columns
Topic #rows-and-columns
Primary Key Explained
Topic #primary-key-explained
Foreign Key Explained
Topic #foreign-key-explained
Constraints in SQL
Topic #constraints-in-sql
SQL Data Types
Topic #sql-data-types
Creating Databases
Topic #creating-databases
Creating Tables
Topic #creating-tables
Altering Tables
Topic #altering-tables
Dropping Tables
Topic #dropping-tables
Inserting Data in SQL
Topic #inserting-data-in-sql
Updating Data
Topic #updating-data
Deleting Data
Topic #deleting-data
Selecting Data
Topic #selecting-data
SELECT Statement
Topic #select-statement
WHERE Clause
Topic #where-clause
ORDER BY Clause
Topic #order-by-clause
LIMIT Clause
Topic #limit-clause
DISTINCT Keyword
Topic #distinct-keyword
LIKE Operator
Topic #like-operator
IN Operator
Topic #in-operator
BETWEEN Operator
Topic #between-operator
AND Operator
Topic #and-operator
OR Operator
Topic #or-operator
NOT Operator
Topic #not-operator
NULL Values in SQL
Topic #null-values-in-sql
IS NULL Operator
Topic #is-null-operator
IS NOT NULL Operator
Topic #is-not-null-operator
Aliases in SQL
Topic #aliases-in-sql
Aggregate Functions
Topic #aggregate-functions
COUNT Function
Topic #count-function
SUM Function
Topic #sum-function
AVG Function
Topic #avg-function
MIN Function
Topic #min-function
MAX Function
Topic #max-function
GROUP BY Clause
Topic #group-by-clause
HAVING Clause
Topic #having-clause
SQL Comments
Topic #sql-comments
SQL Best Practices
Topic #sql-best-practices
Joins in SQL
Topic #joins-in-sql
INNER JOIN
Topic #inner-join
LEFT JOIN
Topic #left-join
RIGHT JOIN
Topic #right-join
FULL OUTER JOIN
Topic #full-outer-join
SELF JOIN
Topic #self-join
CROSS JOIN
Topic #cross-join
UNION Operator
Topic #union-operator
UNION ALL
Topic #union-all
Subqueries in SQL
Topic #subqueries-in-sql
Nested Queries
Topic #nested-queries
Correlated Subqueries
Topic #correlated-subqueries
EXISTS Operator
Topic #exists-operator
ANY and ALL Operators
Topic #any-and-all-operators
CASE Statement
Topic #case-statement
SQL Views
Topic #sql-views
Creating Views
Topic #creating-views
Updating Views
Topic #updating-views
Indexes in SQL
Topic #indexes-in-sql
Unique Indexes
Topic #unique-indexes
Composite Indexes
Topic #composite-indexes
SQL Transactions
Topic #sql-transactions
COMMIT Statement
Topic #commit-statement
ROLLBACK Statement
Topic #rollback-statement
SAVEPOINT in SQL
Topic #savepoint-in-sql
ACID Properties
Topic #acid-properties
SQL Constraints Deep Dive
Topic #sql-constraints-deep-dive
NOT NULL Constraint
Topic #not-null-constraint
UNIQUE Constraint
Topic #unique-constraint
CHECK Constraint
Topic #check-constraint
DEFAULT Constraint
Topic #default-constraint
AUTO_INCREMENT
Topic #auto-increment
Sequences in SQL
Topic #sequences-in-sql
SQL Functions
Topic #sql-functions
String Functions
Topic #string-functions
Numeric Functions
Topic #numeric-functions
Date Functions
Topic #date-functions
Date Formatting
Topic #date-formatting
Working with Time
Topic #working-with-time
SQL Operators Overview
Topic #sql-operators-overview
Data Integrity in SQL
Topic #data-integrity-in-sql
Normalization Basics
Topic #normalization-basics
First Normal Form (1NF)
Topic #first-normal-form-1nf
Second Normal Form (2NF)
Topic #second-normal-form-2nf
Third Normal Form (3NF)
Topic #third-normal-form-3nf
Denormalization
Topic #denormalization
SQL Performance Basics
Topic #sql-performance-basics
Query Optimization
Topic #query-optimization
Understanding Execution Plans
Topic #understanding-execution-plans
Building Mini SQL Projects
Topic #building-mini-sql-projects
Stored Procedures
Topic #stored-procedures
Creating Stored Procedures
Topic #creating-stored-procedures
Calling Stored Procedures
Topic #calling-stored-procedures
Functions in SQL
Topic #functions-in-sql
User-Defined Functions
Topic #user-defined-functions
Triggers in SQL
Topic #triggers-in-sql
BEFORE Trigger
Topic #before-trigger
AFTER Trigger
Topic #after-trigger
Database Events
Topic #database-events
Cursors in SQL
Topic #cursors-in-sql
Window Functions
Topic #window-functions
ROW_NUMBER Function
Topic #row-number-function
RANK Function
Topic #rank-function
DENSE_RANK Function
Topic #dense-rank-function
LEAD and LAG Functions
Topic #lead-and-lag-functions
Common Table Expressions (CTE)
Topic #common-table-expressions-cte
Recursive CTE
Topic #recursive-cte
Temporary Tables
Topic #temporary-tables
Dynamic SQL
Topic #dynamic-sql
Pivot and Unpivot
Topic #pivot-and-unpivot
SQL Security Basics
Topic #sql-security-basics
Database Users and Roles
Topic #database-users-and-roles
GRANT Statement
Topic #grant-statement
REVOKE Statement
Topic #revoke-statement
Backup and Restore
Topic #backup-and-restore
Replication Basics
Topic #replication-basics
Partitioning in SQL
Topic #partitioning-in-sql
Sharding Concepts
Topic #sharding-concepts
SQL Injection Explained
Topic #sql-injection-explained
Preventing SQL Injection
Topic #preventing-sql-injection
Transactions Deep Dive
Topic #transactions-deep-dive
Deadlocks in SQL
Topic #deadlocks-in-sql
Database Locking
Topic #database-locking
Isolation Levels
Topic #isolation-levels
SQL with PHP
Topic #sql-with-php
SQL with Java
Topic #sql-with-java
SQL with Python
Topic #sql-with-python
SQL with Node.js
Topic #sql-with-node-js
SQL with Spring Boot
Topic #sql-with-spring-boot
SQL with Laravel
Topic #sql-with-laravel
ORM Basics
Topic #orm-basics
Hibernate Introduction
Topic #hibernate-introduction
JPA Basics
Topic #jpa-basics
Prisma ORM
Topic #prisma-orm
Sequelize ORM
Topic #sequelize-orm
Database Design Best Practices
Topic #database-design-best-practices
Scalability in Databases
Topic #scalability-in-databases
High Availability Systems
Topic #high-availability-systems
Enterprise Database Architecture
Topic #enterprise-database-architecture
Production Database Optimization
Topic #production-database-optimization
Introduction to MySQL
Topic #introduction-to-mysql
Installing MySQL Workbench
Topic #installing-mysql-workbench
phpMyAdmin Tutorial
Topic #phpmyadmin-tutorial
MySQL CRUD Operations
Topic #mysql-crud-operations
PostgreSQL Introduction
Topic #postgresql-introduction
pgAdmin Tutorial
Topic #pgadmin-tutorial
SQLite Introduction
Topic #sqlite-introduction
MongoDB vs SQL
Topic #mongodb-vs-sql
MariaDB Introduction
Topic #mariadb-introduction
Oracle SQL Basics
Topic #oracle-sql-basics
SQL Server Introduction
Topic #sql-server-introduction
Database Migration
Topic #database-migration
Importing SQL Files
Topic #importing-sql-files
Exporting Databases
Topic #exporting-databases
Connecting Database with Applications
Topic #connecting-database-with-applications
Remote Database Connections
Topic #remote-database-connections
Cloud Databases
Topic #cloud-databases
AWS RDS Basics
Topic #aws-rds-basics
Firebase vs SQL
Topic #firebase-vs-sql
Supabase Database Basics
Topic #supabase-database-basics
Student Management Database
Topic #student-management-database
Employee Management Database
Topic #employee-management-database
HRMS Database Design
Topic #hrms-database-design
Payroll Management Database
Topic #payroll-management-database
Banking Database System
Topic #banking-database-system
Hospital Management Database
Topic #hospital-management-database
E-Commerce Database
Topic #e-commerce-database
Inventory Management Database
Topic #inventory-management-database
Library Management Database
Topic #library-management-database
School Management Database
Topic #school-management-database
Hotel Booking Database
Topic #hotel-booking-database
Food Delivery Database
Topic #food-delivery-database
Ride Booking Database
Topic #ride-booking-database
Chat Application Database
Topic #chat-application-database
Social Media Database
Topic #social-media-database
Job Portal Database
Topic #job-portal-database
Online Examination Database
Topic #online-examination-database
CRM Database
Topic #crm-database
ERP Database Design
Topic #erp-database-design
SaaS Multi-Tenant Database
Topic #saas-multi-tenant-database
SQL Interview Questions
Topic #sql-interview-questions
SQL Coding Challenges
Topic #sql-coding-challenges
SQL Queries for Practice
Topic #sql-queries-for-practice
Common SQL Mistakes
Topic #common-sql-mistakes
Debugging SQL Queries
Topic #debugging-sql-queries
SQL Best Practices (🎯 Interview & Career Preparation)
Topic #sql-best-practices-interview-and-career-preparation
Database Design Interview Questions
Topic #database-design-interview-questions
System Design with SQL
Topic #system-design-with-sql
Freelancing with SQL
Topic #freelancing-with-sql
Remote Jobs for SQL Developers
Topic #remote-jobs-for-sql-developers
SQL Cheat Sheet
Topic #sql-cheat-sheet
SQL Commands List
Topic #sql-commands-list
SQL Mini Projects
Topic #sql-mini-projects
SQL Major Projects
Topic #sql-major-projects
SQL Resume Projects
Topic #sql-resume-projects
SQL Portfolio Ideas
Topic #sql-portfolio-ideas
SQL Certification Guide
Topic #sql-certification-guide
SQL Notes PDF
Topic #sql-notes-pdf
SQL MCQs
Topic #sql-mcqs
SQL Quiz
Topic #sql-quiz
SQL Exercises
Topic #sql-exercises
SQL Online Compiler
Topic #sql-online-compiler
SQL Playground
Topic #sql-playground
Best VS Code Extensions for SQL
Topic #best-vs-code-extensions-for-sql
Database Developer Tools
Topic #database-developer-tools
SQL Roadmap 2026
Topic #sql-roadmap-2026
Future of SQL
Topic #future-of-sql
SQL Ecosystem
Topic #sql-ecosystem
Complete SQL Mastery Roadmap
Topic #complete-sql-mastery-roadmap
Become a Database Developer
Topic #become-a-database-developer
Practice SQL Online
After learning each SQL concept, practice writing queries and experimenting with examples. Build your SQL skills by working through SELECT statements, filtering, joins, grouping, subqueries, and other database operations. Use the ManaCoding SQL tutorials and online coding tools to practice what you learn.