PL/SQL Course Syllabus For Beginners And Experienced
PL/SQL Course Syllabus For Beginners And Experienced
SQL Syllabus
Create Daatabase
Syntax
Create table
Insert Into
Comments
Select
Distinct
AND & OR
Order BY
Update
Injection
Like
IN
Between
Alias
Joins
Innser Join
Left Join
Right Join
Full Join
Self Join
Union
Union All
Insert Into Select
Key Constraints
Not Null
Unique
Primary Keyt
Check
Default
Unique
Create Index
Drop
Alter
Auto Increment
Views
Dates
Null Values
Data Types
Sql Functions
Avg Function
Count Function
First Function
Last Function
Max Function
Min Function
Sum Function
Group by Function
Having Function
Ucase Function
Lcase Function
Mid Function
Len Function
Now Function
Round Function
PLSQL Syllabus
Introduction to pl_sql
Environment Setup
Basic Syntax
Data Types
Variables
Constants And Literals
Operators
Conditions
Loops
Strings
Arrays
Procedures
Functions
Cursors
Exceptions
Triggers
Packages
Collections
Transactions
Date and Time
DBMS Output
Object Oriented