• SQL Tutorial
• Home
• Overview About SQL
• RDBMS Concept
• Databases
• SQL Syntax
• SQL Data Types
• SQL Operators
• SQL Expressions
• Handle Database
• How to create database
• Drop Database
• Select Database
• Rename Database
• Show Database
• Backup Database
• Handle Table
• How to create table
• How to show table
• How to rename table
• How to truncate table
• How to clone table
• SQL - Temporary tables
• SQL - Alter Table
• SQL - Drop table
• Constraints
• Handle Queries
• Insert Query
• Select Query
• Select into
• Insert into Select
• Update Query
• Delete Query
• Sorting Results
• Views
• Types of Views
• Update Views
• Drop Views
• Rename Views
• What is Views
• Why Use Views
• Handle Operators and Clause
• Where Clause
• Top Clause
• Distinct Clause
• Order By Clause
• Having Clause
• And and OR
• Boolean Operator
• Like Operator
• Any, All Operators
• Exists Operator
• Case
• NOT Operator
• NOT Equal
• IS NULL
• IS NOT NULL
• BETWEEN Operator
• UNION Operator
• UNION vs UNION ALL
• INTERSECT Operator
• Except Operator
• Aliases
• Handle with JOIN
• Using Join
• Inner Join
• Left Join
• Right Join
• Cross Join
• Full Join
• Self Join
• Delete Join
• Update Join
• Left vs Right Join
• Union vs Join
• Handle with Keys
• Unique Key
• Primary Key
• Foreign Key
• Composite Key
• Alternate Key
• Handle with Indexes
• What is Index
• Create Index
• Drop Index
• Show Index
• Unique Index
• Clustered Index
• Non-Clustered Index
• Handle With JSON
• Introduction SQL JSON
• ISJSON
• JSON_VALUE
• JSON_QUERY
• JSON_MODIFY
• OPENJSON
• FOR JSON