SQL-tutorial
SQL-tutorial copied to clipboard
Pankaj-Str
SQL Codes With Pankaj
SQL Database
| Topic Name |
|---|
| SQL - Create Database |
| SQL - Drop Database |
| SQL - Select Database |
| SQL - Rename Database |
| SQL - Show Databases |
| SQL - Backup Database |
SQL Table
| Topic Name |
|---|
| SQL - Create Table |
| SQL - Show Tables |
| SQL - Rename Table |
| SQL - Truncate Table |
| SQL - Clone Tables |
| SQL - Temporary Tables |
| SQL - Alter Tables |
| SQL - Drop Table |
| SQL - Delete Table |
SQL Constraints
| Topic Name |
|---|
| SQL Queries |
| SQL - Insert Query |
| SQL - Select Query |
| SQL - Select Into |
| SQL - Insert Into Select |
| SQL - Update Query |
| SQL - Delete Query |
| SQL - Sorting Results |
SQL Views
| Topic Name |
|---|
| SQL - Create Views |
| SQL - Update Views |
| SQL - Drop Views |
| SQL - Rename Views |
SQL Operators and Clauses
| Topic Name |
|---|
| SQL - Where Clause |
| SQL - Top Clause |
| SQL - Distinct Clause |
| SQL - Order By Clause |
| SQL - Group By Clause |
| SQL - Having Clause |
| SQL - AND & OR |
| SQL - BOOLEAN (BIT) Operator |
| SQL - LIKE Operator |
| SQL - IN Operator |
| SQL - ANY, ALL Operators |
| SQL - EXISTS Operator |
| SQL - CASE |
| SQL - NOT Operator |
| SQL - NOT EQUAL |
| SQL - IS NULL |
| SQL - IS NOT NULL |
| SQL - NOT NULL |
| SQL - BETWEEN Operator |
| SQL - UNION Operator |
| SQL - UNION vs UNION ALL |
| SQL - INTERSECT Operator |
| SQL - EXCEPT Operator |
| SQL - Aliases |
SQL Joins
| Topic Name |
|---|
| SQL - Using Joins |
| SQL - Inner Join |
| SQL - Left Join |
| SQL - Right Join |
| SQL - Cross Join |
| SQL - Full Join |
| SQL - Self Join |
| SQL - Delete Join |
| SQL - Update Join |
| SQL - Left Join vs Right Join |
| SQL - Union vs Join |
SQL Keys
| Topic Name |
|---|
| SQL - Unique Key |
| SQL - Primary Key |
| SQL - Foreign Key |
| SQL - Composite Key |
| SQL - Alternate Key |
SQL Indexes
| Topic Name |
|---|
| SQL - Indexes |
| SQL - Create Index |
| SQL - Drop Index |
| SQL - Show Indexes |
| SQL - Unique Index |
| SQL - Clustered Index |
| SQL - Non-Clustered Index |
SQL Function Reference
| Topic Name |
|---|
| SQL - Date Functions |
| SQL - String Functions |
| SQL - Aggregate Functions |
| SQL - Numeric Functions |
| SQL - Text & Image Functions |
| SQL - Statistical Functions |
| SQL - Logical Functions |
| SQL - Cursor Functions |
| SQL - JSON Functions |
| SQL - Conversion Functions |
| SQL - Datatype Functions |
Pankaj-Str