SQL Tutorials

SQL is a popular language when it comes to manipulating data and when one is working with relational databases.

This is a repository where you can find the detailed tutorials for learning SQL with examples:

​

Basic SQL:

​

• Creating a table in SQL

• INSERTing data into a SQL table

• Constraints in SQL

• Primary Key in SQL

• SELECT statement in SQL (Selecting some of the columns)

• Sorting data using ORDER BY

• Filtering data using WHERE Statement

• Aggregate functions and GROUP BY in SQL

• GROUP BY and HAVING in SQL

• 5 Joins in SQL - Includes detailed explanation for interview questions

• UNION , UNION ALL, INTERSECT and EXCEPT

• Selecting top N rows in SQL

• ALTER TABLE in SQL

• UPDATE - SET in SQL

• TRUNCATE, DROP and DELETE

​

Intermediate SQL:

• Sub-queries in SQL - Includes detailed explanation for interview questions

• CASE WHEN (Proxy of IF-ELSE) in SQL - Detailed explanation for interview questions

• COALESCE in SQL

• String functions in SQL

• CAST in SQL

• Adding quotes to a column in output

​

Window Functions:

• Window Functions  - Everything Explained