TOPICS COVERED
- SQL – Overview
- RDBMS Concepts
- Databases Architecture
- CRUD operations
- Data Types
- Operators
- Expressions
- Create Database
- Drop Database
- Select Database
- Create Table
- Drop Table
- Update Tables
- Insert Data into Tables
- Select Query
- Where Clause
- AND & OR Clauses
- Update Query
- Delete Query
- Like Clause
- Order By
- Group By
- Distinct Keyword
- Sorting Results
- Constraints
- Using Joins
- Unions Clause
- NULL Values
- Indexes
- Alter Command
- Using Views and Advance Views
- Having By Clause
- String and Date Functions
- Sub Queries
- Aggregate Functions
- Character Functions
- Numeric Functions
- All Types of Joins
