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