Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Oracle PL SQL
Course Duration | 30 hrs | ||
---|---|---|---|
Live Projects | 2 | ||
Next Batch | 17 April, 2021 |
Introduction to Programming Languages
Introduction to PL/SQL
The Advantages of PL/SQL
PL/SQL Architecture
PL/SQL Data types
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 Subqueries
Ref. Cursors
Record and PL/SQL Table Types
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
Difference between Procedures and Functions
User Defined Functions
Nested Functions
Using stored function in SQL statements
Creating PACKAGE Specification and Package Body
Private and Public Objects in PACKAGE
Types of exceptions :
User Defined Exceptions
Pre Defined Exceptions
RAISE_APPLICATION_ERROR
PRAGMA_AUTONOMOUS_TRANSACTION
SQL Error Code Values
Types of Triggers
Row Level Triggers
Statement Level Triggers
DDL Triggers
Trigger Auditing
PL/SQL file I/O (Input/Output)
Using UTL_FILE Package
What is Object Technology ?
OOPS-Object Instances
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 Abstract Data type Attributes
Large Objects (LOBS)
Creating Tables-LOB
Working with LOB values
Inserting, Updating & Deleting Values in LOBs
Populating Lobis DBMS_LOB Routines
Using B-FILE
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
Introduction to Oracle Database Architecture
Physical structures Logical structures
DB Memory Structures Background Process
2 Tire, 3 Tire, N-Tier Architecture
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 Flashback Queries
Dynamic SQL
New data types, Flash back Command
Purge Command, Recycle Bin
Regular expressions, DML Error Logging
Data Pump, Virtual Columns
Read only tables, Cross tab Views using
Pivot/Unpivot operators, Follows Clause
Compound triggers, New data types
Database
Tablespace
Types of tablespaces
Data files
Redesign the code.
Create indexes, constraints, alter existing objects and reports for data.
Run data manipulation language (DML) and data definition language (DDL) statements.
Control and manage database access to specific schema objects.
Retrieve data from tables.
Control privileges at the object and system level.
Query external tables.
Many MNCs worldwide are hiring Oracle PL/SQL developers.
The average salary of a certified PL/SQL developer is around $93,500 USD per annum.
BI professionals
Data Warehousing professionals
Software engineers
Aspirants willing to build their career in management related fields.
Knowledge of SQL is required but not essential to learn Oracle PL/SQL. The following job roles will get benefited by taking up this course:
Software developers
Database administrators
SQL and Analytics professionals
BI and Data Warehousing professionals
Have More Questions
Contact usHave questions? We’ve got the answers. Get the details on how you can grow in this course.
Have More Questions. Reach our Support Team
Contact usSee if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Oracle PL SQL
By providing us with your details, We wont spam your inbox.