Lesson 1
1
Introduction to SQL
Lesson 2
1
Retrieving Data
Lesson 3
1
Updating Data
Lesson 4
1
Inserting Data
Lesson 5
1
Deleting Data
Lesson 6
1
Sorting and Filtering Data
Lesson 7
1
Advanced Filtering
Lesson 8
1
Summarizing Data
Lesson 9
1
Grouping Data
Lesson 10
1
Using Subqueries
Lesson 11
1
Joining Tables
Lesson 12
1
Managing Tables
Lesson 13
1
Using Views
Lesson 14
1
Stored Procedures
Lesson 15
1
Using Cursors
Lesson 16
1
Using Transactions
PL SQL COURSE CONTENT
MODULE 1
1
PL-SQL (Procedure Language – SQL)
2
Introduction to Programming Languages
3
Introduction to PL/SQL
4
The Advantages of PL/SQL
5
PL/SQL Architecture
6
PL/SQL Data types
MODULE 2
1
Variable and Constants
2
Using Built_in Functions
3
Conditional and Unconditional Statements
4
Simple if, if… else, nested if..else, if..else Ladder
5
Selection Case, Simple Case, GOTO Label and EXIT
6
Iterations in PL/SQL
7
Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
8
SQL within PL/SQL
9
Composite Data types (Complete)
10
Cursor Management in PL/SQL
11
Implicit Cursors
12
Explicit Cursors
13
Cursor Attributes
14
Cursor with Parameters
15
Cursors with LOOPs Nested Cursors
16
Cursors with Sub Queries
17
Ref. Cursors
18
Record and PL/SQL Table Types
19
Advanced PL/SQL
20
Procedures in PL/SQL
21
STORED PROCEDURES
22
PROCEDURE with Parameters (IN,OUT and IN OUT)
23
POSITIONAL Notation and NAMED Notation
24
Procedure with Cursors
25
Dropping a Procedure
26
Functions in PL/SQL
MODULE 3
1
Difference between Procedures and Functions
2
User Defined Functions
3
Nested Functions
4
Using stored function in SQL statements
5
Packages in PL/SQL
6
Creating PACKAGE Specification and PACKAGE Body
7
Private and Public Objects in PACKAGE
8
EXCEPTIONS in PL/SQL
9
Types of exceptions
10
User Defined Exceptions
11
Pre Defined Exceptions
12
RAISE_APPLICATION_ERROR
13
PRAGMA_AUTONOMOUS_TRANSACTION
14
SQL Error Code Values
15
Database Triggers in PL/SQL
16
Types of Triggers
17
Row Level Triggers
18
Statement Level Triggers
19
DDL Triggers
20
Trigger Auditing
21
File Input/Output
22
PL/SQL file I/O (Input/Output)
23
Using UTL_FILE Package
24
Implementing Object Technology
25
What is Object Technology ?
26
OOPS-Object Instances
MODULE 4
1
Creation of objects
2
Creating User Defined Data Types
3
Creating Object Tables
4
Inserting rows in a table using Objects
5
Retrieving data from Object based Tables
6
Calling a Method
7
Indexing Abstract Data type Attributes
8
Using LOBS
9
Large Objects (LOBS)
10
Creating Tables-LOB
11
Working with LOB values
12
Inserting, Updating
13
Populating Lobis DBMS_LOB Routines
14
Using B-FILE
15
Using Collections
16
Advantages of collection
17
Ref cursor (Dynamic Cursor)
18
Weak ref cursor
19
Strong ref cursor
20
Nested Tables VARRAYS or VARYING arrays
21
Creating tables using nested tables Table records
22
Inserting, updating
23
A nested table in PL/SQL
24
Oracle Database Architecture
25
Introduction to Oracle Database Architecture
MODULE 5
1
Physical structures Logical structures
2
DB Memory Structures Background Process
3
2 Tire, 3 Tire, N-Tier Architecture
4
Advanced Features
5
9i Joines
6
New Date function
7
Rename column
8
Inner Join/Natural Join
9
Left Outer Join/Right Outer Join
10
Full Outer Join
11
Multiple Inserts
12
Insert All Command
13
Merge statement
14
NVL2(), NULLIF(), COALESCE()
15
CASE expression of Select Command
16
Temporary Tables/Global Tables
17
New Function EXTRACT()
18
Autonomous Traction
19
Pragma _ Autonomous_ Transaction()
20
Bulk Collect
21
About Flash Back Queries
22
Dynamic SQL
23
New data types, Flashback Command
24
Purge Command, Recyclebin
25
Regular expressions, DML Error Logging
26
Data Pump, Virtual Columns
MODULE 6
1
Read only tables, Cross tab Views using
2
Pivot/Unpivot operators, Follows Clause
3
Compound triggers, New data types
4
DBA CONCEPTS
5
Database
6
Tablespace
7
Types of tablespaces
8
Data files
Be the first to add a review.
Please, login to leave a review
