Introduction
- Introduction about database
- The Sample Database
- Creating the Sample Table, Data
- Viewing Sample Table, Data
Data Definition Language
- Categories of SQL Statements
- The CREATE Statement
- The DROP Command
- The ALTER Command
Data Manipulation Language
- DML Statements
- The SELECT Statement
- The INSERT Statement
- The DELETE Statement
- The UPDATE Statement
Transaction Control Language
- Transactions
- Command Classification
- The SET TRANSACTION Command
SQL Data Types
- Different types of SQL data types and its uses.
SQL Constraints and Operators
- Constraints
- Comparison Operators
- IN and NOT IN Operators
- BETWEEN Operator
- The LIKE Operator
- Logical Operators
- IS NULL and IS NOT NULL
- ANY
- ALL
SQL Functions
- Introduction
- The DISTINCT Keyword
- Aliases
- Aggregate Functions
- Mathematical Functions
- String Functions
- Date Functions
- Conversion Functions
Joining Tables
- Joins
- Inner Joins
- Outer Joins
- Cross Join
Set Operators
- Introduction
- Selection Criteria
- Union
- Union All
- Intersect
- Minus
SQL Sub queries & Correlated Queries
- Introduction
- Typical Sub queries
- Correlated Sub queries
- CTE
Groups
- SQL Statements
- GROUP BY Clause
- HAVING Clause
- Order of a SELECT Statement
Stored Procedure
- Create a stored procedure
- Alter a stored procedure
- Drop a stored procedure
- Parameter declaration
- Uses
View
- Create a view
- Alter a view
- Drop a view
- Uses
User Defined Functions
- Create functions
- Alter Functions
- Drop Functions
- Uses
| 