SQL Tutorial

Welcome to the SQL learning hub.

SQL (Structured Query Language) is the language used to communicate with relational databases. From small business applications to enterprise-scale platforms, SQL plays a critical role in storing, retrieving, updating, and analyzing data efficiently.

This tutorial is designed to provide a structured learning experience for students, software developers, backend engineers, database administrators, and data analysts. Every lesson focuses on practical understanding rather than memorizing syntax.

By the end of this tutorial, you will be able to create databases, design tables, write complex queries, optimize performance, and work confidently with modern database systems.

SQL Learning Path

<div className="not-prose my-6 overflow-x-auto"> <table className="min-w-[680px] border-collapse text-left text-sm"> <thead> <tr> <th className="border border-slate-200 bg-slate-50 px-4 py-2 font-semibold text-slate-800">Stage</th> <th className="border border-slate-200 bg-slate-50 px-4 py-2 font-semibold text-slate-800">Focus Area</th> <th className="border border-slate-200 bg-slate-50 px-4 py-2 font-semibold text-slate-800">Key Topics</th> </tr> </thead> <tbody> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">1. Foundation</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Introduction to SQL</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction/what-is-sql">What is SQL</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction/history-of-sql">History</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction/features-of-sql">Features</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction/advantages-and-disadvantages">Advantages &amp; Disadvantages</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction/sql-vs-nosql">SQL vs NoSQL</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">2. Setup</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Database Setup</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/setup/install-mysql">MySQL</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/setup/install-postgresql">PostgreSQL</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/setup/install-sqlite">SQLite</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/setup/sql-online-compilers">Online Editors</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/setup/create-first-database">First Database</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">3. Core</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">SQL Fundamentals</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/basics/sql-syntax">Syntax</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/basics/sql-comments">Comments</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/basics/sql-data-types">Data Types</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/basics/sql-operators">Operators</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/basics/sql-keywords">Keywords</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">4. Tables</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Working with Tables</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/table-operations/create-table">Create Table</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/table-operations/alter-table">Alter Table</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/table-operations/rename-table">Rename</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/table-operations/truncate-table">Truncate</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/table-operations/drop-table">Drop</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/table-operations/temporary-table">Temporary Tables</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">5. CRUD</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">CRUD Operations</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/crud/insert-data">INSERT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/crud/select-data">SELECT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/crud/update-data">UPDATE</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/crud/delete-data">DELETE</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/crud/sql-aliases">Aliases</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">6. Filter</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Filtering and Sorting Data</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/where-clause">WHERE</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/order-by">ORDER BY</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/group-by">GROUP BY</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/having-clause">HAVING</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/distinct-keyword">DISTINCT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/limit-clause">LIMIT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/top-clause">TOP</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/between-operator">BETWEEN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/in-operator">IN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/like-operator">LIKE</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/filtering/wildcard-characters">Wildcards</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">7. Functions</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">SQL Functions</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/functions/aggregate-functions">Aggregate</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/functions/string-functions">String</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/functions/date-functions">Date</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/functions/conversion-functions">Conversion</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/functions/numeric-functions">Numeric</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">8. Joins</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">SQL Joins</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/joins/inner-join">INNER JOIN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/joins/left-join">LEFT JOIN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/joins/right-join">RIGHT JOIN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/joins/full-outer-join">FULL OUTER JOIN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/joins/self-join">SELF JOIN</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/joins/cross-join">CROSS JOIN</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">9. Subqueries</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Subqueries &amp; Set Operations</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/subqueries/subquery-introduction">Introduction</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/subqueries/nested-subqueries">Nested</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/subqueries/correlated-subquery">Correlated</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/subqueries/exists-operator">EXISTS</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/set-operators/union">UNION</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/set-operators/intersect">INTERSECT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/set-operators/except">EXCEPT</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">10. Integrity</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Constraints and Relationships</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/constraints/primary-key">PRIMARY KEY</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/constraints/foreign-key">FOREIGN KEY</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/constraints/unique-key">UNIQUE</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/constraints/not-null">NOT NULL</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/constraints/default-constraint">DEFAULT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/constraints/check-constraint">CHECK</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">11. Performance</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Indexing</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/indexing/sql-indexes">SQL Indexes</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/indexing/clustered-index">Clustered</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/indexing/non-clustered-index">Non-Clustered</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/indexing/unique-index">Unique</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/indexing/index-performance">Performance</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">12. Views</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Views</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/views/create-view">Create View</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/views/update-view">Update View</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/views/drop-view">Drop View</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/views/materialized-view">Materialized View</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">13. Automation</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Stored Procedures &amp; Triggers</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/stored-procedures/create-procedure">Procedures</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/stored-procedures/parameters-in-procedure">Parameters</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/triggers/before-trigger">BEFORE Trigger</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/triggers/after-trigger">AFTER Trigger</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">14. Transactions</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Transactions</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/transactions/acid-properties">ACID</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/transactions/commit">COMMIT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/transactions/rollback">ROLLBACK</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/transactions/savepoint">SAVEPOINT</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/transactions/isolation-levels">Isolation Levels</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">15. Design</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Database Normalization</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/normalization/database-normalization">Normalization</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/normalization/first-normal-form">1NF</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/normalization/second-normal-form">2NF</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/normalization/third-normal-form">3NF</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/normalization/bcnf">BCNF</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/normalization/denormalization">Denormalization</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">16. Advanced</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Advanced SQL</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/advanced-sql/window-functions">Window Functions</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/advanced-sql/common-table-expressions">CTEs</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/advanced-sql/dynamic-sql">Dynamic SQL</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/advanced-sql/pivot-unpivot">PIVOT/UNPIVOT</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">17. Optimize</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">SQL Optimization</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/optimization/query-optimization">Query Optimization</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/optimization/explain-plan">Explain Plans</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/optimization/indexing-strategies">Indexing Strategies</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/optimization/partitioning">Partitioning</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">18. Interview</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Interview Preparation</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/interview-questions/sql-interview-beginner">Beginner</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/interview-questions/sql-interview-intermediate">Intermediate</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/interview-questions/sql-interview-advanced">Advanced</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/interview-questions/sql-scenario-questions">Scenario</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/interview-questions/sql-output-based-questions">Output-Based</a> </td> </tr> <tr> <td className="border border-slate-200 px-4 py-2 font-semibold text-slate-800">19. Practice</td> <td className="border border-slate-200 px-4 py-2 text-slate-700">Practice and Projects</td> <td className="border border-slate-200 px-4 py-2 text-slate-700"> <a className="text-sky-700 underline" href="/coding/sql-complete-guide/practice/sql-exercises-beginner">Beginner Exercises</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/practice/sql-exercises-intermediate">Intermediate</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/practice/sql-exercises-advanced">Advanced</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/practice/sql-projects">Projects</a>, <a className="text-sky-700 underline" href="/coding/sql-complete-guide/practice/sql-challenges">Challenges</a> </td> </tr> </tbody> </table> </div>

Who Should Learn SQL?

This tutorial is suitable for:

• Computer Science Students
• Software Developers
• Backend Engineers
• Data Analysts
• Data Scientists
• Database Administrators
• Technical Interview Candidates

Start Learning

The best way to learn SQL is through practice.

Begin with the <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction">Introduction</a> section, complete each lesson in order, experiment with queries, and build real projects along the way.

Let's start by understanding <a className="text-sky-700 underline" href="/coding/sql-complete-guide/introduction/what-is-sql">What SQL is</a> and why it remains one of the most important technologies in modern software development.