SQL / PLSQL COURSE CONTENTS

SQl DML COMMANDS
Basic Select Statement
Restricting & Sorting Data
Single Row Functions
Joins
Group & Having Clause
Sub-query
Insert, Update, Delete
Commit, Rollback
DDL COMMANDS
Creating & Managing Tables
Various Constraints / Keys
Views and Other Objects
DCL COMMANDS
Controlling User Access
ADVANCE SQL CONCEPTS
PL / SQL
PL / SQL Environments
Declaring Variables
Block Structures
Block Types
%TYPE Attribute
Executable Statements
Cursor
Procedures & Functions
Packages
Triggers