Skip to content

Innovative Technology Solutions

Oracle Database 19c: SQL and PL/SQL Fundamentals Ed 2 Training

The Oracle Database: PL/SQL Fundamentals Ed 2 training course gives you the detailed overview of PL/SQL programming language. During the training you will learn using various features of PL/SQL, writing anonymous blocks of code, using various PL/SQL conditional constructs and loops in program blocks, stored procedures and functions in their program blocks & Handle exceptions in PL/SQL code.

5865 Ratings
4.6/5

4564 Learners

Oracle Database: PL/SQL Fundamentals Ed 2/1Z0-144 Course Overview

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You’ll explore the concepts of relational databases.

Oracle Database Introduction to SQL

Learning Objectives

Key Features

Benefits to you

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Training Options

Self-Paced eLearning

5,999
  • Lifetime access to recorded self-paced eLearning course created by industry experts
  • 3.simulation test for Practice
  • 24x7 learner assistance and support

Corporate Training

Customized
  • Live Instructor Led / Campus delivery model
  • Flexible pricing options according to your requirements
  • Pre & Post evaluation test for comparison
  • 24x7 support & assistance

Course Curriculum

Who should do Oracle Database: PL/SQL Fundamentals Ed 2 training?

  • Database Administrators
  • Forms Developer
  • PL/SQL Developer
  • Portal Developer
  • System Analysts
  • Technical Consultant

Pre-requisites

  • Understanding of data processing concepts & techniques
  • Fundamentals of programming languages

Course Content

  • Course Objectives, Course Agenda and Class Account Information
  • The Human Resources (HR) Schema
  • Appendices Used in this Course
  • PL/SQL Development Environments
  • Understanding the benefits and structure of PL/SQL
  • Understanding PL/SQL Blocks
  • Generating output messages in PL/SQL
  • Identifying valid and invalid identifiers
  • Declaring and initializing variables
  • Various data types
  • Identifying the benefits of using the %TYPE attribute
  • Using bind variables
  • Lexical Units in a PL/SQL Block
  • Using SQL Functions in PL/SQL
  • Data Type Conversion
  • Using Nested Blocks as Statements
  • Referencing an Identifier Value in a Nested Block
  • Qualifying an Identifier with a Label
  • Operators in PL/SQL
  • Using Sequences in PL/SQL Expressions
  • Using SQL Statements in PL/SQL
  • Retrieving Data in PL/SQL with the SELECT statement
  • Using Naming Conventions in DML Statements and data retrieval
  • Manipulating Data on the Server Using PL/SQL
  • SQL Cursors
  • Using SQL Cursor Attributes to Obtain Feedback on DML
  • Saving and Discarding Transactions
  • Controlling PL/SQL Flow of Execution
  • Using IF and CASE Statements for conditional processing
  • Handling Nulls
  • Building Boolean Conditions with Logical Operators
  • Using Iterative Control with Loop Statements
  • Composite Data Types of PL/SQL Records and Tables
  • Using PL/SQL Records
  • Inserting and Updating PL/SQL Records
  • Using INDEX BY Tables
  • Using Associative arrays
  • Declaring and Using VArrays
  • Cursors
  • Explicit Cursor Operations
  • Controlling Explicit Cursors
  • Using Explicit Cursors to Process Rows
  • Cursors and Records
  • Cursor FOR Loops Using Subqueries
  • Explicit Cursor Attributes
  • %NOTFOUND and %ROWCOUNT Attributes
  • Concept of Exception
  • Handling Exceptions with PL/SQL
  • Predefined Exceptions
  • Trapping Predefined and Non-predefined Oracle Server Errors
  • Functions that Return Information on Exceptions
  • Usage of PRAGMA keyword
  • Trapping User-Defined Exceptions
  • Propagating Exceptions
  • Overview of Stored Procedures and Functions
  • Differentiating between anonymous blocks and subprograms
  • CREATE OR REPLACE PROCEDURE | FUNCTION
  • Understanding the Header Area of a Stored Procedure and Function
  • Creating Simple Procedures and Functions
  • Creating a Simple Procedure with an IN Parameter
  • Executing a Procedure and a Function

Oracle Database 1Z0-144 Exam Format

1Z0-144

Multiple Questions, Multiple Answeres

63 Questions

90 Minutes

Reviews

Rohit
Rohit
2020-04-13
Verified review
Training was good , thanks for the session.
Abhishek Hegde
Abhishek Hegde
2020-04-10
Verified review
Decently conducted training on Azure related to AZ-900 course. Relatable examples taken by the instructor for basics. Needed even more in depth and maybe more concepts and time with pros and cons. Overall good one.
Madhur Mall
Madhur Mall
2020-04-10
Verified review
Session was good covering basics with simple and relate-able examples.
Chetan Gullia
Chetan Gullia
2020-04-10
Verified review
Amazing experience while having Azure Cloud Training :).
Dharmendra Kumar
Dharmendra Kumar
2020-04-10
Verified review
Bhavesh Pali is a excellent trainer. Azure cloud training was awesome and well explained by Bhavesh. Thanks Again to ITS group.
Swapnil Phirke
Swapnil Phirke
2020-04-10
Verified review
Very good Training and specially trainer Mr Bhavesh has good enough knowledge to answer all queries, content is also good. Training duration need to increase as trainer has more things to share but not possible to lack of time
Kapil Ahuja
Kapil Ahuja
2020-04-10
Verified review
All modules were well covered with examples , The conceptual understanding provided by using whiteboard also helped us to grasp the concepts faster.
Nirbhay Singh
Nirbhay Singh
2020-04-10
Verified review
Thanks Bhavesh for Azure Fundamentals - AZ900

Why Innovative Technology Solutions

Our Virtual Instructor Led Training model brings classroom learning experience online. With our world-class LMS instructor-led training, self-paced E-learning and personalized mentoring you will get an immersive first-class learning experience.

Self-Paced E-learning

A self-paced e-learning with recorded video sessions that you can access anytime without going beyond your comfort zone.

Live Virtual Classroom

An interactive classroom style virtual instructor led training to engage and learn more alongside your peers with a live trainer.

Learner's Community

A Social forum where you can ask your questions, one of our expert will reply you within 24 hours on that community.

Online Access of Labs

Online access of practise labs that you can access anytime, anywhere your machine.

Industry Based Projects

Real-time Industry based projects will be shared by the trainers throughout the program

24/7 Assistance

Get engaged with integrated support assistance on your desktop and mobile learning

FAQs

Trainer will be Oracle certified having more than 15 years of experience in training and working in the IT field.

No, Exam Voucher fee is not included in the course fee.

Our Online classroom (Instructor-Led) training for Microsoft Azure Administrator will be conducted via live streaming app like zoom, Web-ex, or blue jeans by an Microsoft certified trainer having experience of more than 15 years in IT domain & training.