Oracle SQL Training Online

I want to get information about the Oracle SQL Training Online duration as well as Course Package Course with Lecture wise. So here can you provide me information about it?

[Kiran Chandar]

As per your demand here I am providing you information about the Oracle SQL Training Online duration as well as Course Package Course with Lecture wise.

Oracle SQL Training Online
Duration: 26 hours


After completing this course, applicants will:
Understand Oracle database Architecture

Perform code analysis

Know about Oracle Application-Express (APEX) basics.

Write and tune SQL code effectively to maximize performance

Write powerful PL/SQL programs (procedures, packages, functions & triggers)

Course Package:
Access to class recordings

Free 24/7 access to Oracle Cloud Database

26 hrs of Live online classes

Course Outline:
Lecture #1 –
1. Introduction to Oracle Database
ArchitecturePhysical & Logical View
Instance
Memory Structure – SGA & PGA
User & Background Process
2. RDBMS
3. Introduction to training database Environment
4. Data Model & ER Model
5. Dimensions Vs Fact tables
6. OLTP Vs OLAP
7. Using SQL*Plus & SQL Developer
8. Introduction to SQL
9. Creating the Schema
10. Oracle Data Types
11. Types of SQL Statements
12. Introduction to Data Definition Language (DDL) statements
Create
Alter
Drop
Rename
Truncate
Comment
13. Introduction to Data Manipulation Language (DML) statements
Select
Insert
Update
Delete
Merge
14.Oracle Pseudo Column

Lecture #2 –
1. Adding, Modifying & Removing Rows to a table
2. Performing Arithmetic operations
3. String Functions
4. SQL Operators (LIKE, IN, BETWEEN operators)
5. LOGICAL operators
6. Sorting data (using Order By Clause)
7. Join conditions & Join Types
Select data from Multiple Tables
Table Alias
EQUI Join
Inner Join
Non-Equijoin
Outer Joins
Right Outer Joins
Left Outer Joins
Limitations of Outer Joins
Self Joins
JOINS – Using Keyword
8. Traditional Joins Vs ANSI Joins
9. ANSI Joins
ANSI Equi Join
ANSI Right Outer Join
ANSI Left Outer Join
ANSI FULL Outer Join
ANSI Natural Join
Lecture #3 –
1. Oracle Conversion Functions
TO_DATE
TO_CHAR
TO_NUMBER
2. Oracle Single Row Functions
3. Oracle Multiple Rows Functions
4. Oracle String Functions
5. Oracle Case Related Functions
6. Oracle Analytical Functions
7. MAX/MIN
AVG
COUNT
OVER PARTITION BY
RANK
SUM
FIRST & LAST Functions
8. Oracle Group By & Having Clauses
9. Oracle Rollup
10. Oracle Decode Function
11. CASE Expressions
Searched CASE Expression

Lecture #4 –
1. Subqueries
Single-row subqueries
Multiple-row Subqueries
Multiple-column subqueries
Correlated Subqueries
Nested Subqueries
Subqueries IN Vs Exists
2. DML (delete,update & Insert using) Nested Subqueries
3. Oracle Set Operators
UNION ALL
UNION
INTERSECT
MINUS
4. Users, Privileges & Roles
5. Auditing
6. Constraints
NOT NULL
CHECK
PRIMARY KEY
FOREIGN KEY
UNIQUE
READ ONLY
CHECK OPTION
Enable/Disable/Drop Constraint
Oracle Sequences
Lecture #5 –
1. Oracle Indexes
Bitmap Indexes
B-Tree Indexes
What is High Selectivity Index
Unique INDEX
Function Based Indexes
Alter/Drop/Enable/Disable/Rename Index
2. Oracle View
Normal View
Updatable View
Recreating and dropping view
Lecture #6 –
3. Introduction to PL/SQL
4. Basic Structure of PL/SQL
5. PL/SQL Keywords
6. Operators
7. Declare, Assign Value to variable
8. Display a Value
9. DML Operations in PL/SQL
10. SELECT INTO syntax for a single Row Query
11. Datatypes in PL/SQL
12. Scalar Type
Composite Types
Reference Type
LOB Type
User Defined Type
Unidentified Column types (%TYPE & %ROWTYPE)
Lecture #7 –
1. Composite Datatypes in PL/SQL
Records
Types of Records
Table-based
User-defined record
Cursor-based record
Nested Table
VARRAY
PL/SQL Table
PL/SQL – VARRAYS
2. Variable Declaration in PL/SQL
3. Scope of variables
Lecture #8 –
1. Constants
2. PL/SQL conditional statements
IF-THEN-ELSE
IF-THEN-ELSIF
CASE
SEARCHED CASE
3. Types of LOOPS
Simple Loop
Basic Loop
While Loop
For Loop
Continue Statement
4. Oracle Cursors
Implicit Cursor
Explicit Cursor
Cursor Attributes (ISOPEN, ROWCOUNT, FOUND, NOTFOUND)
Cursor with FOR Loops
Cursor with parameters
Lecture #9 –
1. PL/SQL Records
Table-based
User-defined record
Cursor-based record
2. PL/SQL Collections
PL/SQL associative arrays
VARRAYS
Nested Tables
3. PL/SQL Collection methods
Lecture #10 –
1. Oracle Exception Handling
System Defined Exception
Named Exception
User Defined Exception
RAISE Vs RAISE_APPLICATION_ERROR
PRAGMA EXCEPTION_INIT
SQLCODE & SQLERRM
2. Oracle Stored Procedures
Anonymous block
Named Block
IN, OUT, IN OUT Parameters
Lecture #11 –
1. Oracle Functions
2. Oracle Packages
3. Oracle Triggers
4. System Level Triggers
Row Level Trigger
Statement Level Trigger
Instead of Trigger
System Triggers
Enable/Disable Triggers
Lecture #12 –
1. Oracle Performance Tuning
2. Oracle Application Express (APEX)