Basic Syntax
Data Definition Language
Data Manipulation Language
Aggregate Queries
Data Constraints
JOIN Queries
SQL Roadmap
BASICS
Database
Types of Database
RDBMS
SQL vs NoSQL
DDL
Data Definition Language
DDL Commands and Syntax
DML
Data Manipulation Language
SQL Clauses
DML vs DDL
DML vs TCL
TRANSACTIONS
Transactions in SQL
AGGREGATE QUERIES
Introduction
Aggregate Functions
SQL Views
Advanced Functions
Subqueries
DATA CONSTRAINTS
SQL Constraints
SQL Transactions
SQL Indexes
ADVANCED FUNCTIONS
Advanced SQL Functions
String Functions
Date and Time Functions
Numeric Functions
SQL SUBQUERIES
Subqueries
Correlated Subqueries
Nested Subqueries
SQL Join vs Subquery
QUERIES
SQL Joins
Cartesian Join and Self Join
Inner Join vs Outer Join
INDEXES
Indexes in SQL
Query Optimization
Best Practices
SQL Basics
SYNTAX
SQL Syntax
SQL Data Types
SQL Operators
VIEWS
Views in SQL
Create View
Update View
Drop View
Advanced SQL
ADVANCED SQL
Integrity Constraints
Stored Procedures
Performance Optimization
Window Functions
Pivot and Unpivot
Common Table Expresssion
Dynamic SQL
Recursive Queries