1 . Data Base (
Create , Alter , Rename )
2 . Data Types
3 . Table ( create ,insert data ,rename ,Desc ,Select Data
,Update Data ,Delete/Truncate )
4 . Identity ( Auto Number Increment )
5 . Integrity ( Constraints )
6 . Data Retrieving ( Queries , Sub Queries )
7 . Normalization
8 . Structured Query Language
( DDL , DML , TCL
,DCL )
9 . Rule & Default
10 . Joins ( Inner , Outer , Cross , Self )
11 . Views ( Virtual
Tables )
12 . Index
13 . Variables
14 . SQL Programming
15 . Stored Procedure
a) With
Out Arguments
b) With
Arguments ( Max 1024)
c) Default Arguments
d) Output parameter
16 . Temp Stored
Procedure
17 . Functions (System Defined , User Defined )
18 . Triggers ( After Triggers , Instead of Triggers)
19 . Date functions
20 . Cursors
21 . Distinct
22 . Union
Click Here ⇐For Python Classes Demo Videos
Click Here ⇐For Home Page & All Demo Videos
