PL/SQL

Introduction to SQL

What is database
DBMS
What is SQL
SQL data type & operator
Data Definition Laungauge
Data Manipulation Laungauge
Data Control Laungauge

SQL Commands
SQL SELECT
SQL WHERE
SQL UPDATE
SQL DELETE
SQL INSERT INTO

SQL Advanced
SQL Order By
SQL AND & OR
SQL In
SQL Between
SQL Aliases
SQL Join
SQL Union . SQL Functions
SQL Select Into
SQL Create View
Nested Queries

DATA MANIPULATION
SQL Create table
SQL Delete Table
SQL Create index
SQL Drop index
SQL Alter Table

SQL Function
What is SQL Function?
Aggregate Function
Scalar function
SQL Group By and Having

PL/SQL
Basic structure of PL/SQL
Variables and type
Simple program in PL/SQL
Control flow in PL/SQL
Cursors
Printing variables