Location
B 100 A, South City 1, Gurgaon – 122001, Haryana. India
Our hours
10:00 AM – 19.00 PM
Monday – Sunday
Contact us
Phone: +91-9871333203
Email: info@itstechschool.com
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
Rated 4.6 out of 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.
Learning Objectives
- Design PL/SQL anonymous block that execute efficiently
- Using PL/SQL programming constructs and conditionally control code flow
- Handle exceptions in the program units
- Create and execute simple stored procedures and functions
- Write PL/SQL code to interface with the database
- Describe the features and syntax of PL/SQL
Key Features
- Expert Oracle instructors across the globe
- Get hands-on experience
- Industry-recognized Course Completion certificate provided
- Training provided across 100+ locations globally
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
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
65%
90 Minutes
Reviews
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.