๐ Special Offer! ๐ ๐ Flat 40% OFF on all courses!
All Courses
Programming Courses
Python Certification Training Course
Trending
Python Django Certification Training Course
Node.js Certification Training Course
Java Certification Training Course
Best Seller
Spring Framework Certification Training Course
Spring Boot Certification Training Course
Trending
Hibernate Certification Training Course
Microsoft .NET Framework Certification Training Course
Data Analytics Certification Training Course
Trending
PHP MYSQL with MVC Certification Training Course
Advanced Java Certification Training
Go Language Certification Training
Flutter Certification Training
Get your free demo class
Call Us
Master Program
Full Stack Certification Training Course
Trending
DevOps Master Program Certification Training Course
New
Cloud Masters Program Certification Training Course
Popular
Data Science Master Program Certification Training Course
Popular
Software Testing Master Program Certification Training Course
Get your free demo class
Call Us
Cloud Computing
AWS Solution Architect Associate Certification Training
Trending
AWS Certified DevOps Engineer Professional Training
Popular
AWS Development Certification Training Course
New
Microsoft Azure Certification Training Course (AZ-104 & AZ-304)
Microsoft Azure DevOps Certification Training Course (AZ-400)
Microservices Certification Training Course
Salesforce Developer Certification Training Course
Salesforce Administrator Certification Training Course
Linux Certification Training Course
Get your free demo class
Call Us
DevOps
DevOps Certification Training Course
Trending
Kubernetes Certification Training Course
Docker Certification Training Course
Ansible Certification Training Course
Chef Certification Training Course
GIT Certification Training Course
DevSecOps Certification Training Course in Bangalore
Get your free demo class
Get now
Data science
DataScience with Python Certification Training Course
Best Seller
Machine Learning Certification Training Course
Deep Learning Certification Training Course
(AI) Artificial Intelligence Certification Training Course
Trending
Get your free demo class
Call Us
Big Data
Big Data Hadoop Certification Training Course
Trending
Apache Spark and Scala Certification Training Course
Apache Kafka Certification Training Course
Best Seller
Get Your Free Demo Class
Call Us
Software Testing
Selenium Certification Training Course
Trending
Selenium with Python Certification Training Course
New
Selenium with C# Certification Training Course
Manual Testing Certification Training Course
Get your free demo class
Call Us
Robotic Process Automation
RPA using UiPath Certification Training Course
Trending
RPA using Automation Anywhere Certification Training Course
RPA using Blue Prism Certification Training Course
Get your free demo class
Call Us
Frontend Development
Angular Certification Training Course
Trending
React JS Certification Training Course
Best Seller
Web Development Certification Training Course
MERN Stack Certification Training Course
Get your free demo class
Call Us
Databases
MySQL Certification Training Course
Oracle Certification Training Course
MongoDB Certification Training Course
Trending
Get your free demo class
Call Us
Mobile Development
Android Certification Training Course
Trending
Get your free demo class
Call Us
Home
Courses
Programming & Frameworks
DevOps
Data Science
Cloud Computing
Robotic Process Automation
Software Testing
Frontend Development
Master Program
Databases
Big Data
Mobile Development
About
FAQs
Blog
Gallery
Success Stories
Contact
X
Contact Us
Oracle Certification Training Course
Curriculum
40 Sections
306 Lessons
50 Hours
Expand all sections
Collapse all sections
Introduction to Oracle Database
7
1.1
List the features of Oracle Database 11g
1.2
Discuss the basic design, theoretical, and physical aspects of a relational database
1.3
Categorize the different types of SQL statements
1.4
Describe the data set used by the course
1.5
Log on to the database using SQL Developer environment
1.6
Save queries to files and use script files in SQL Developer
1.7
Hands-On
Retrieve Data using the SQL SELECT Statement
9
2.1
List the capabilities of SQL SELECT statements
2.2
Generate a report of data from the output of a basic SELECT statement
2.3
Select All Columns
2.4
Select Specific Columns
2.5
Use Column Heading Defaults
2.6
Use Arithmetic Operators
2.7
Understand Operator Precedence
2.8
Learn the DESCRIBE command to display the table structure
2.9
Hands-On
Learn to Restrict and Sort Data
7
3.1
Write queries that contain a WHERE clause to limit the output retrieved
3.2
List the comparison operators and logical operators that are used in a WHERE clause
3.3
Describe the rules of precedence for comparison and logical operators
3.4
Use character string literals in the WHERE clause
3.5
Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
3.6
Sort output in descending and ascending order
3.7
Hands-On
Usage of Single-Row Functions to Customize Output
6
4.1
Describe the differences between single row and multiple row functions
4.2
Manipulate strings with character function in the SELECT and WHERE clauses
4.3
Manipulate numbers with the ROUND, TRUNC, and MOD functions
4.4
Perform arithmetic with date data
4.5
Manipulate dates with the DATE functions
4.6
Hands-On
Invoke Conversion Functions and Conditional Expressions
6
5.1
Describe implicit and explicit data type conversion
5.2
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
5.3
Nest multiple functions
5.4
Apply the NVL, NULLIF, and COALESCE functions to data
5.5
Use conditional IF THEN ELSE logic in a SELECT statement
5.6
Hands-On
Aggregate Data Using the Group Functions
4
6.1
Use the aggregation functions in SELECT statements to produce meaningful reports
6.2
Divide the data in groups by using the GROUP BY clause
6.3
Exclude groups of date by using the HAVING clause
6.4
Hands-On
Display Data From Multiple Tables Using Joins
4
7.1
Write SELECT statements to access data from more than one table
7.2
View data that generally does not meet a join condition by using outer joins
7.3
Join a table by using a self join
7.4
Hands-On
Use Subqueries to Solve Queries
5
8.1
Describe the types of problem that subqueries can solve
8.2
Define sub-queries
8.3
List the types of sub-queries
8.4
Write single-row and multiple-row subqueries
8.5
Hands-On
The SET Operators
4
9.1
Describe the SET operators
9.2
Use a SET operator to combine multiple queries into a single query
9.3
Control the order of rows returned
9.4
Hands-On
Data Manipulation Statements
7
10.1
Describe each DML statement
10.2
Insert rows into a table
10.3
Change rows in a table by the UPDATE statement
10.4
Delete rows from a table with the DELETE statement
10.5
Save and discard changes with the COMMIT and ROLLBACK statements
10.6
Explain read consistency
10.7
Hands-On
Use of DDL Statements to Create and Manage Tables
7
11.1
Categorize the main database objects
11.2
Review the table structure
11.3
List the data types available for columns
11.4
Create a simple table
11.5
Decipher how constraints can be created at table creation
11.6
Describe how schema objects work
11.7
Hands-On
Other Schema Objects
6
12.1
Create a simple and complex view
12.2
Retrieve data from views
12.3
Create, maintain, and use sequences
12.4
Create and maintain indexes
12.5
Create private and public synonyms
12.6
Hands-On
Control User Access
9
13.1
Differentiate system privileges from object privileges
13.2
Create Users
13.3
Grant System Privileges
13.4
Create and Grant Privileges to a Role
13.5
Change Your Password
13.6
Grant Object Privileges
13.7
How to pass on privileges?
13.8
Revoke Object Privileges
13.9
Hands-On
Management of Schema Objects
9
14.1
Add, Modify and Drop a Column
14.2
Add, Drop and Defer a Constraint
14.3
How to enable and disable a Constraint?
14.4
Create and Remove Indexes
14.5
Create a Function-Based Index
14.6
Perform Flashback Operations
14.7
Create an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP
14.8
Query External Tables
14.9
Hands-On
Manage Objects with Data Dictionary Views
9
15.1
Explain the data dictionary
15.2
Use the Dictionary Views
15.3
USER_OBJECTS and ALL_OBJECTS Views
15.4
Table and Column Information
15.5
Query the dictionary views for constraint information
15.6
Query the dictionary views for view, sequence, index and synonym information
15.7
Add a comment to a table
15.8
Query the dictionary views for comment information
15.9
Hands-On
Manipulate Large Data Sets
9
16.1
Use Subqueries to Manipulate Data
16.2
Retrieve Data Using a Subquery as Source
16.3
Insert Using a Subquery as a Target
16.4
Usage of the WITH CHECK OPTION Keyword on DML Statements
16.5
List the types of Multitable INSERT Statements
16.6
Use Multitable INSERT Statements
16.7
Merge rows in a table
16.8
Track Changes in Data over a period of time
16.9
Hands-On
Data Management in Different Time Zones
9
17.1
Time Zones
17.2
CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
17.3
Compare Date and Time in a Sessionโs Time Zone
17.4
DBTIMEZONE and SESSIONTIMEZONE
17.5
Difference between DATE and TIMESTAMP
17.6
INTERVAL Data Types
17.7
Use EXTRACT, TZ_OFFSET and FROM_TZ
17.8
Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL
17.9
Hands-On
Retrieve Data Using Sub-queries
9
18.1
Multiple-Column Subqueries
18.2
Pairwise and Non Pairwise Comparison
18.3
Scalar Subquery Expressions
18.4
Solve problems with Correlated Subqueries
18.5
Update and Delete Rows Using Correlated Subqueries
18.6
The EXISTS and NOT EXISTS operators
18.7
Invoke the WITH clause
18.8
The Recursive WITH clause
18.9
Hands-On
Regular Expression Support
9
19.1
Use the Regular Expressions Functions and Conditions in SQL
19.2
Use Meta Characters with Regular Expressions
19.3
Perform a Basic Search using the REGEXP_LIKE function
19.4
Find patterns using the REGEXP_INSTR function
19.5
Extract Substrings using the REGEXP_SUBSTR function
19.6
Replace Patterns Using the REGEXP_REPLACE function
19.7
Usage of Sub-Expressions with Regular Expression Support
19.8
Implement the REGEXP_COUNT function
19.9
Hands-On
Oracle PLSQL Training Syllabus - Introduction to PL/SQL
6
20.1
PL/SQL Overview
20.2
Benefits of PL/SQL Subprograms
20.3
Overview of the Types of PL/SQL blocks
20.4
Create a Simple Anonymous Block
20.5
Generate Output from a PL/SQL Block
20.6
Hands-On
PL/SQL Identifiers
8
21.1
List the different Types of Identifiers in a PL/SQL subprogram
21.2
Usage of the Declarative Section to define Identifiers
21.3
Use variables to store data
21.4
Identify Scalar Data Types
21.5
The %TYPE Attribute
21.6
What are Bind Variables?
21.7
Sequences in PL/SQL Expressions
21.8
Hands-On
Write Executable Statements
7
22.1
Describe Basic PL/SQL Block Syntax Guidelines
22.2
Comment Code
22.3
Deployment of SQL Functions in PL/SQL
22.4
How to convert Data Types?
22.5
Nested Blocks
22.6
Identify the Operators in PL/SQL
22.7
Hands-On
Interaction with the Oracle Server
6
23.1
Invoke SELECT Statements in PL/SQL to Retrieve data
23.2
Data Manipulation in the Server Using PL/SQL
23.3
SQL Cursor concept
23.4
Usage of SQL Cursor Attributes to Obtain Feedback on DML
23.5
Save and Discard Transactions
23.6
Hands-On
Control Structures
7
24.1
Conditional processing Using IF Statements
24.2
Conditional processing Using CASE Statements
24.3
Use simple Loop Statement
24.4
Use While Loop Statement
24.5
Use For Loop Statement
24.6
Describe the Continue Statement
24.7
Hands-On
Composite Data Types
7
25.1
Use PL/SQL Records
25.2
The %ROWTYPE Attribute
25.3
Insert and Update with PL/SQL Records
25.4
Associative Arrays (INDEX BY Tables)
25.5
Examine INDEX BY Table Methods
25.6
Use INDEX BY Table of Records
25.7
Hands-On
Explicit Cursors
9
26.1
What are Explicit Cursors?
26.2
Declare the Cursor
26.3
Open the Cursor
26.4
Fetch data from the Cursor
26.5
Close the Cursor
26.6
Cursor FOR loop
26.7
Explicit Cursor Attributes
26.8
FOR UPDATE Clause and WHERE CURRENT Clause
26.9
Hands-On
Exception Handling
8
27.1
Understand Exceptions
27.2
Handle Exceptions with PL/SQL
27.3
Trap Predefined Oracle Server Errors
27.4
Trap Non-Predefined Oracle Server Errors
27.5
Trap User-Defined Exceptions
27.6
Propagate Exceptions
27.7
RAISE_APPLICATION_ERROR Procedure
27.8
Hands-On
Stored Procedures and Functions
8
28.1
Understand Stored Procedures and Functions
28.2
Differentiate between anonymous blocks and subprograms
28.3
Create a Simple Procedure
28.4
Create a Simple Procedure with IN parameter
28.5
Create a Simple Function
28.6
Execute a Simple Procedure
28.7
Execute a Simple Function
28.8
Hands-On
Create Stored Procedures
9
29.1
Create a Modularized and Layered Subprogram Design
29.2
Modularize Development With PL/SQL Blocks
29.3
Describe the PL/SQL Execution Environment
29.4
Identity the benefits of Using PL/SQL Subprograms
29.5
List the differences Between Anonymous Blocks and Subprograms
29.6
Create, Call, and Remove Stored Procedures Using the CREATE Command and SQL Developer
29.7
Implement Procedures Parameters and Parameters Modes
29.8
View Procedures Information Using the Data Dictionary Views and SQL Developer
29.9
Hands-On
Create Stored Functions
8
30.1
Create, Call, and Remove a Stored Function Using the CREATE Command and SQL Developer
30.2
Identity the advantages of Using Stored Functions in SQL Statements
30.3
List the steps to create a stored function
30.4
Implement User-Defined Functions in SQL Statements
30.5
Identity the restrictions when calling Functions from SQL statements
30.6
Control Side Effects when calling Functions from SQL Expressions
30.7
View Functions Information
30.8
Hands-On
Create Packages
9
31.1
Identity the advantages of Packages
31.2
Describe Packages
31.3
List the components of a Package
31.4
Develop a Package
31.5
How to enable visibility of a Packageโs components?
31.6
How to enable visibility of a Packageโs components?
31.7
Invoke Package Constructs
31.8
View PL/SQL Source Code Using the Data Dictionary
31.9
Hands-On
Packages
9
32.1
Overloading Subprograms in PL/SQL
32.2
Use the STANDARD Package
32.3
Use Forward Declarations to Solve Illegal Procedure Reference
32.4
Implement Package Functions in SQL and Restrictions
32.5
Persistent State of Packages
32.6
Persistent State of a Package Cursor
32.7
Control Side Effects of PL/SQL Subprograms
32.8
Invoke PL/SQL Tables of Records in Packages
32.9
Hands-On
Implement Oracle-Supplied Packages in Application Development
7
33.1
What are Oracle-Supplied Packages?
33.2
Examples of Some of the Oracle-Supplied Packages
33.3
How Does the DBMS_OUTPUT Package Work?
33.4
Use the UTL_FILE Package to Interact With Operating System Files
33.5
Invoke the UTL_MAIL Package
33.6
Write UTL_MAIL Subprograms
33.7
Hands-On
Dynamic SQL
9
34.1
The Execution Flow of SQL
34.2
What is Dynamic SQL?
34.3
Declare Cursor Variables
34.4
Dynamically executing a PL/SQL Block
34.5
Configure Native Dynamic SQL to Compile PL/SQL Code
34.6
Invoke DBMS_SQL Package
34.7
Implement DBMS_SQL with a Parameterized DML Statement
34.8
Dynamic SQL Functional Completeness
34.9
Hands-On
Design Considerations for PL/SQL Code
9
35.1
Standardize Constants and Exceptions
35.2
Understand Local Subprograms
35.3
Write Autonomous Transactions
35.4
Implement the NOCOPY Compiler Hint
35.5
Invoke the PARALLEL_ENABLE Hint
35.6
The Cross-Session PL/SQL Function Result Cache
35.7
The DETERMINISTIC Clause with Functions
35.8
Usage of Bulk Binding to Improve Performance
35.9
Hands-On
Triggers
9
36.1
Describe Triggers
36.2
Identify the Trigger Event Types and Body
36.3
Business Application Scenarios for Implementing Triggers
36.4
Create DML Triggers Using the CREATE TRIGGER Statement and SQL Developer
36.5
Identify the Trigger Event Types, Body, and Firing (Timing)
36.6
Statement Level Triggers Versus Row Level Triggers
36.7
Create Instead of and Disabled Triggers
36.8
How to Manage, Test, and Remove Triggers?
36.9
Hands-On
Create Compound, DDL, and Event Database Triggers
9
37.1
What are Compound Triggers?
37.2
Identify the Timing-Point Sections of a Table Compound Trigger
37.3
Compound Trigger Structure for Tables and Views
37.4
Implement a Compound Trigger to Resolve the Mutating Table Error
37.5
Compare Database Triggers to Stored Procedures
37.6
Create Triggers on DDL Statements
37.7
Create Database-Event and System-Event Triggers
37.8
System Privileges Required to Manage Triggers
37.9
Hands-On
The PL/SQL Compiler
9
38.1
What is the PL/SQL Compiler?
38.2
Describe the Initialization Parameters for PL/SQL Compilation
38.3
List the New PL/SQL Compile Time Warnings
38.4
Overview of PL/SQL Compile Time Warnings for Subprograms
38.5
List the benefits of Compiler Warnings
38.6
List the PL/SQL Compile Time Warning Messages Categories
38.7
Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING Package Subprograms
38.8
View Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views
38.9
Hands-On
Manage PL/SQL Code
9
39.1
What Is Conditional Compilation?
39.2
Implement Selection Directives
39.3
Invoke Predefined and User-Defined Inquiry Directives
39.4
The PLSQL_CCFLAGS Parameter and the Inquiry Directive
39.5
Conditional Compilation Error Directives to Raise User-Defined Errors
39.6
The DBMS_DB_VERSION Package
39.7
Write DBMS_PREPROCESSOR Procedures to Print or Retrieve Source Text
39.8
Obfuscation and Wrapping PL/SQL Code
39.9
Hands-On
Manage Dependencies
9
40.1
Overview of Schema Object Dependencies
40.2
Query Direct Object Dependencies using the USER_DEPENDENCIES View
40.3
Query an Objectโs Status
40.4
Invalidation of Dependent Objects
40.5
Display the Direct and Indirect Dependencies
40.6
Fine-Grained Dependency Management in Oracle Database 11g
40.7
Understand Remote Dependencies
40.8
Recompile a PL/SQL Program Unit
40.9
Hands-On
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content