School For Training
SQL/PLSQL
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

CALL NOW

Course sections

Section 1
Lesson 1
1
Introduction to SQL
Section 2
Lesson 2
1
Retrieving Data
Section 3
Lesson 3
1
Updating Data
Section 4
Lesson 4
1
Inserting Data
Section 5
Lesson 5
1
Deleting Data
Section 6
Lesson 6
1
Sorting and Filtering Data
Section 7
Lesson 7
1
Advanced Filtering
Section 8
Lesson 8
1
Summarizing Data
Section 9
Lesson 9
1
Grouping Data
Section 10
Lesson 10
1
Using Subqueries
Section 11
Lesson 11
1
Joining Tables
Section 12
Lesson 12
1
Managing Tables
Section 13
Lesson 13
1
Using Views
Section 14
Lesson 14
1
Stored Procedures
Section 15
Lesson 15
1
Using Cursors
Section 16
Lesson 16
1
Using Transactions
Section 17
PL SQL COURSE CONTENT
Section 18
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
Section 19
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
Section 20
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
Section 21
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
Section 22
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
Section 23
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

MODULE 4

Creating User Defined Data Types

Lesson is locked. Please Buy course to proceed.

MODULE 4 Creation of objects
Completed
MODULE 4 Creating Object Tables
Get Widget
Get Widget