❒ SQL - All in One Concepts (Beginners to Advance)

  •  SQL (Foundations) 

○ SQL - Overview
○ SQL - RDBMS Concepts
○ SQL - Database
○ SQL - Syntax
○ SQL - Data Type
○ SQL - Operators
○ SQL - Expressions

  •  SQL (Queries) 

○ SQL - Insert Queries
○ SQL - Select Queries
○ SQL - Update Queries
○ SQL - Delete Queries
○ SQL - Select Into 
○ SQL - Insert Into Select 
○ SQL - Sorting Results 

  •  SQL (Operator & Clauses) 

○ SQL - Where Clause
○ SQL - Distinct Clause
○ SQL - Order by Clause
○ SQL - Group be Clause
○ SQL - Having Clause
○ SQL - LIKE Operator
○ SQL - IN Operator
○ SQL - EXIST Operator
○ SQL - BETWEEN Operator
○ SQL - UNION VS UNION ALL
○ SQL - Aliases

  •  SQL (Joins) 

○ SQL - Joins Overview
○ SQL - Inner Join
○ SQL - Left Join
○ SQL - Right Join
○ SQL - Full Join
○ SQL - Cross Join
○ SQL - Self Join
○ SQL - Left vs Right Join
○ SQL - Union vs Join

  •  SQL (Keys) 

○ SQL - Primary Key
○ SQL - Foreign Key
○ SQL - Unique Key
○ SQL - Composite Key

  •  SQL (Indexes) 

○ SQL - Indexes Overview
○ SQL - Clustered Index
○ SQL - Unique Index
○ SQL - Non-Clustered Index

  •  SQL (Advanced & Real-World Use) 

○ SQL - Injection
○ SQL - Stored Procedures
○ SQL - Transactions
○ SQL - Sub Queries
○ SQL - Common Table Expressions (CTEs)
○ SQL - Auto Increment
○ SQL - Database Tuning

  •  SQL (Functions) 

○ SQL - Date Functions
○ SQL - String Functions
○ SQL - Aggregate Functions
○ SQL - Numeric Functions
○ SQL - Conversion Functions
○ SQL - JSON Functions
○ SQL - Database Tuning