• LOGIN
  • No products in the cart.

COURSE SYLLABUS

Lesson 1: Introduction to SQL
Lesson 2: Retrieving Data
Lesson 3: Updating Data
Lesson 4: Inserting Data
Lesson 5: Deleting Data
Lesson 6: Sorting and Filtering Data
Lesson 7: Advanced Filtering
Lesson 8: Summarizing Data
Lesson 9: Grouping Data
Lesson 10: Using Subqueries
Lesson 11: Joining Tables
Lesson 12: Managing Tables
Lesson 13: Using Views
Lesson 14: Stored Procedures
Lesson 15: Using Cursors
Lesson 16: Using Transactions

PL SQL Course Content

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

Interested in learning SQL/PLSQL?

0 responses on "SQL/PLSQL"

Leave a Message

Your email address will not be published. Required fields are marked *

Course Reviews

4

4
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

© 2018 Schoolfortraining.Powered By Embtelsolutions.com
Note: School for Training is a vocational school. We promise quality education. We do not promise a job.
WhatsApp