Complete Practical, Real-time Job Oriented Training
Oracle PL SQL Training
What is Database?
Database is a platform to store any type of data, any amount of data. Easy to use and operate. Highly
Secured and Robust.
What is Oracle?
Oracle is a useful and reliable Database Management System (DBMS) Software that can help us to
perform the day to day operations like Design, Storage, Retrieval, Security, Analysis, many more .. !
Who can join this course?
Anyone. We start the classes from scratch, right from Basics of Oracle. 100% Practical, Real-time
Scenario based and job orientation with Realtime Project !
Why to choose SQL School to master Oracle?
We are a prominent training organization with proven track record to implement start of art learning
methods for last 19 years. Beside ISO Certified Company, we have a decent client base for our LIVE
Instructor Led Trainings with MindTree, ADP, TechM, Infosys, L&T, HCL, Sutherland Global, IMI
Mobile, ValueLabs, more .. !
Oracle PLSQL Training: We assure you:
Module 1: Oracle PLSQL Queries ✅ Step-by-step Practical Trainings
Module 2: PLSQL Programming ✅ 100% Practical, Interactive
✅ Resume Guidance, Latest FAQs
Total Duration: 6 Weeks
✅ End to End Project Work
Includes Realtime Project
👉🏻For latest schedules, Free (LIVE) Demo: pls call us or visit: [Link]
👉🏻Reach us for free demo. Call us on +91 9666 44 0801
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Detailed Course Content
Module 1: Database Fundamentals, Oracle PLSQL Queries
Ch 1: Database Introduction
Database Introduction
Database Types
OLTP, DWH & OLAP
Database Realtime Use
Real-world Advantages
Job Roles
Ch 2: Oracle Installation 1
Oracle Introduction, Features
Oracle Advantages, Usage
Oracle Versions and Editions
Oracle Installation Guidance
Pre-Requisites and Precautions
Oracle SQL Command prompt
Ch 3: Oracle Installation 2
Installation Verifications
Installation Precautions
Locking, Unlocking Users
Password Resets
Oracle System user
Default Sysdba user
Ch 4: SQL BASICS 1
Need For SQL
SQL Basic Fundamentals
SQL Operations in Realtime
Possible Operations with SQL
Data Definition Language
Data Manipulation Language
Data Retrieval Language
Ch 5: SQL BASICS 2
DDL Concepts
DML Concepts
DQL Concepts
Creating Databases, Tables
Data Inserts, Edits
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Deletes, Truncates
Select
Ch 6: SQL BASICS 3
SELECT Variants
SQL Operators
IN, NOT IN
BETWEEN, NOT BETWEEN
LIKE, NOT LIKE
ALTER, DROP
RENAME
Ch 7: SQL BASICS 4
Arithmetic Operators
Logical Operators
Special Operators
Operator Precedence
UNION, UNION All & LIKE
INTERSECT, MINUS, etc..
IS NULL (IS NOT NULL)
Ch 8: Data Types
Integer Data Types
Character Data Types
Number Data Types
Boolean & Binary LOB Data Types
Date and Time Data Types
Ch 9: Data Types
Variables: Realtime use
Variables in SQL
Declaring Variables
Assigning Values
Reporting Variables
Muti Variable Assignments
Ch 10: Introduction to RDBMS
Features of RDBMS
E.F Codd Rules for RDBMS
Normalization Concepts
Client Server Architecture
Oracle Versions
SQL & SQL*PLUS
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Ch 11: Constraints & Keys I
Importance of Data Integrity
Data Integrity constraints
Types of Integrity Constraints
Domain Integrity Constraints
Entity Integrity Constraints
Ch 12: Constraints & Keys II
Referential Integrity
Check & UNIQUE
Cascading Keys in Realtime
Use Case Scenarios
ALL_CONSTRAINTS
USER_CONSTRAINTS
Ch 13: Constraints & Keys III
PRIMARY KEY Constraint
FOREIGN KEY Constraints
Column Level & Table Level
Adding Constraints
Self-Referential Integrity
Ch 14: Grouping Query Results
Distinct Values in Tables
Group, Aggregate function
Group By Statement Syntax
Group By Operations in SQL
Diff. b/w GROUP BY and ORDER BY
Ch 15: Grouping and Order by
Having with Group By
Order By Clause, Group By
Grouping() Function Usage
What is ORDER BY in SQL?
What is first ORDER BY or GROUP BY?
Ch 16: Queries & Joins - I
Joins and Table Comparisons
SET Operations with Joins
How do Joins work in SQL?
Equi Join, Simple Join
Inner Join and Query Conditions
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Ch 17: Queries & Joins - II
Cross Join (Cartesian Join)
Join syntax and Ansi Syntax
Non-Equi Join and Self Join
Inner Join and Self Join
Realtime Use Cases
Ch 18: Queries & Joins - III
Outer Joins – Types
Cross Joins – Advantages
Merge Joins, Sub Queries
Join Aliases and Conditions
Inner Self Joins with HAVING
JOINS and GROUP BY Queries
Ch 19: Normal Forms & Self Joins
Normal Forms: 1 NF, 2 NF
3 NF, BCNF and 4 NF
Adding PK to Tables
Adding FK to Tables
Cascading Keys
Self Referencing Keys
Database Diagrams
Ch 20: Single Row Function - I
Order By Clause and Group By
SQL Group By Statement
Arithmetic, Character Functions
Date & Time, String Function
Conversion, Analytical Functions
Ch 21: Single Row Function - II
Rank,Dense_Rank,Row_Number
NVL(),NVL2(), NullIF(),Coalesce()
Types of single-row functions are there?
Diff. b/w single and multiple row functions?
Categories of SQL Functions
Ch 22: Views -I
Understanding Views & Use
Relational, Standard Views
SIMPLE, COMPLEX VIEWS
Column Definitions
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
VIEWS for DML Operations
Ch 23: Views -II
View and its Types?
Forced, CHECK Constraints
READ ONLY VIEWS – Use
Indexed Views
View definition in SQL
Ch 24: Sub Queries - 1
Sub Queries in Real-world
Conditions with Sub Queries
Sub Queries, Nested Queries
Nested Sub Query Execution
Inner and Outer Queries
Ch 25: Sub Queries - 2
Delete Duplicate Records
Subquery, Clause Examples
Execution of Correlated Sub
IN, ANY SOME, ALL
Single, Multi Row Subquery
Multiple Column Subquery
Ch 26: Synonyms
Sequences, with Synonyms
Use of Synonym in Oracle?
Views Versus Synonyms
Table Synonyms Usage
Public and Private Synonyms
Ch 27: Realtime Case Study (Ecommerce / Medicare)
Module 2: PLSQL Programming
Ch 28: Transaction Types - I
DCL and TCL Commands
Transactions in Databases
Transaction Types and Uses
Commit and Rollback
Transactions with SavePoints
Ch 29: Transaction Types - II
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Read Consistency with SQL
Transaction types in Oracle?
Realtime use of Transactions
Auto Commit, Explicit, etc..
Ch 30: Cursors & Fetch
Cursors: Realtime Usage
Types of Cursors in PL/SQL
Cursor Actions
Static & Dynamic Cursors
How to use Explicit Cursor
Ch 31: Sequences
Synonym Identification Options
Realtime Use of Synonyms
Synonyms: Limitations
Basic definition of sequence?
How to check sequence definition?
Ch 32: PL/SQL – (Control Structures) – Level I
Simple If, If..Else, Nested If..Else
Ladder, Selection, Case Stmt
Iterations, Simple LOOP, WHILE
FOR LOOP and NESTED LOOPS
PL/SQL Select statements
Ch 33: PL/SQL (CONTROL STRUCTURE) - Level II
Implicit & Explicit Cursors
Cursor with Parameters
Reference Cursors
Cursor Exit Options
FOR Loops with Cursors
Realtime Considerations
Ch 34: OOPS Concepts I
Object Technology and Use
OOPS - Object Instances
Creation of Objects
User Defined Data Types
Object Tables in Oracle
Ch 35: OOPS Concepts II
Inserting rows using Object
Data @ Object Based Tables
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Methods, Indexing Abstract
Data type Attributes
What are the 4 types of OOP?
Ch 36: ADVANCED PL/SQL - 1
Procedures in PL/SQL
PROCEDURES @ Parameters
Procedures, Cursors, Queries
ALTER and DROP of SPs
Functions and Real-time Use
User Defined Functions
Ch 37: ADVANCED PL/SQL – 2
Nested Functions
Comparing Functions and SPs
Complex Procedures in PLSQL
PACKAGE Body, Big Data
Trigger Types in Realtime
Triggers with Procedures
Ch 38: ADVANCED PL/SQL - 3
Triggers and their types?
Follows & READONLY Tables
Inline Views - Manipulations
Purity Levels in Oracle
Source Dictionary Packages
PACKAGE Specifications
Module 3: Realtime Project
Realtime Project in Banking Domain
Project Requirement
Project Solution
Resume
Mock Interview
🔥 Choose #SQLSchool 🔥 We assure you:
✅ 19+ Years of Continued Trust ✅ Step-by-step Classes
✅ ISO Certified, MSME Regd. ✅ 100% Interactive
✅ 120+ MNC Clients ✅ Real-Time Projects
✅ Practical, Step by Step Trainings ✅ Resume, Mock Interviews, more ..
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016
Enrol for a LIVE Demo. Interact with our trainer before you proceed!
👉🏻Reach Us: +91 9666 64 0801
+91 9666 44 0801
👉🏻[Link]
👉🏻Training Modes: LIVE Online / Self Paced Videos
Thank you for your time, wish you all the very best!
[Link] #202, Sai Anu Avenue, Patrika Nagar, Hitech City, Hyderabad - 500016