Mastering Oracle Database 12c: PL/SQL Programming Essentials
Exam Details
| Duration: | 90 minutes |
|---|---|
| Number of Questions: | 63 |
| Passing Score: | 65% View passing score policy |
| Validated Against: | This exam has been validated against Oracle Database 12.1.0.1.0. |
| Format: | Multiple Choice |
| Exam Price: | Rs 9701 More on exam pricing |
Course Content / Exam(s)
- Course
- Human Resources (HR) Schema for This Course
- Course
- Class Account Information
- Appendixes and Practices Used in This Course
- Oracle Database 12c: Focus Areas
- Oracle Database 12c
- PL/SQL Development Environments
- Oracle SQL Developer
- Specifications of SQL Developer
- SQL Developer 4.1.3 Interface
- Coding PL/SQL in SQL*Plus
- Oracle SQL and PL/SQL Documentation
- Additional Resources
- Limitations of SQL
- Why PL/SQL?
- Why PL/SQL
- About PL/SQL
- Benefits of PL/SQL
- PL/SQL Runtime Architecture
- PL/SQL Block Structure
- Block Types
- Examining an Anonymous Block
- Executing an Anonymous Block
- Enabling Output of a PL/SQL Block
- Viewing the Output of a PL/SQL Block
- Variables
- Variables in PL/SQL
- Requirements for Variable Names
- Using Variables in PL/SQL
- Declaring and Initializing PL/SQL Variables
- Declaring and Initializing PL/SQL Variables
- Initializing Variables Through a SELECT Statement
- Types of Variables
- Declaring Variables
- Guidelines for Declaring and Initializing PL/SQL Variables
- Guidelines for Declaring PL/SQL Variables
- Naming Conventions of the PL/SQL Structures Used in This Course
- Data Types for Strings
- Delimiters in String Literals
- Data Types for Numeric values
- Data Types for Date and Time values
- Data Type Conversion
- The %TYPE Attribute
- Declaring Variables with the %TYPE Attribute
- Declaring Boolean Variables
- LOB Data Type Variables
- Composite Data Types: Records and Collections
- Bind Variables
- Bind Variables: Examples
- Using AUTOPRINT with Bind Variables
- Lexical Units in a PL/SQL Block
- PL/SQL Block Syntax and Guidelines
- Commenting Code
- SQL Functions in PL/SQL
- SQL Functions in PL/SQL: Examples
- Using Sequences in PL/SQL blocks
- Using Sequences in PL/SQL Blocks
- Nested blocks
- Nested Blocks: Example
- Variable Scope and Visibility
- Using a Qualifier with Nested Blocks
- Challenge: Determining the Variable Scope
- Operators in PL/SQL
- Operators in PL/SQL: Examples
- Programming Guidelines
- Indenting Code
- SQL Statements in PL/SQL
- SELECT Statements in PL/SQL
- Retrieving Data in PL/SQL: Example
- Retrieving Data in PL/SQL
- Naming Ambiguities
- Avoiding Naming Ambiguities
- Using PL/SQL to Manipulate Data
- Insert Data: Example
- Update Data: Example
- Delete Data: Example
- Merging Rows
- SQL Cursor
- SQL Cursor Attributes for Implicit Cursors
- PL/SQL Control Structures
- IF Statement
- IF-ELSIF Statements
- Simple IF Statement
- IF THEN ELSE Statement
- IF ELSIF ELSE Clause
- NULL Value an in IF Statement
- CASE Expressions
- Searched CASE Expressions
- CASE Statement
- Handling Nulls
- Logic Tables
- Boolean Expression or Logical Expression?
- Iterative Control: LOOP Statements
- Basic Loops
- Basic Loop: Example
- WHILE Loops
- WHILE Loops: Example
- FOR Loops
- FOR Loops: Example
- FOR Loop Rules
- Suggested Use of Loops
- Nested Loops and Labels
- Nested Loops and Labels: Example
- PL/SQL CONTINUE Statement
- PL/SQL CONTINUE Statement: Example 1
- PL/SQL CONTINUE Statement: Example 2
- Composite Data Types
- PL/SQL Records Versus Collections
- PL/SQL Records
- Creating a PL/SQL Record
- Creating a PL/SQL Record: Example
- PL/SQL Record Structure
- %ROWTYPE Attribute
- Creating a PL/SQL Record: Example
- Advantages of Using the %ROWTYPE Attribute
- Another %ROWTYPE Attribute: Example
- Inserting a Record by Using %ROWTYPE
- Updating a Row in a Table by Using a Record
- Associative Arrays (INDEX BY Tables)
- Associative Array Structure
- Steps to Create an Associative Array
- Creating and Accessing Associative Arrays
- Associative Arrays with Record values
- Using Collection Methods
- Using Collection Methods with Associative Arrays
- Nested Tables
- Nested Tables: Syntax and Usage
- Variable-Sized Arrays (Varrays)
- VARRAYs: Syntax and Usage
- Summarizing Collections
- Cursors
- Implicit Cursors
- Explicit Cursor
- Controlling Explicit Cursors
- Declaring the Cursor
- Opening the Cursor
- Fetching Data from the Cursor
- Closing the Cursor
- Cursors and Records
- Cursor FOR Loops
- Explicit Cursor Attributes
- %ISOPEN Attribute
- %ROWCOUNT and %NOTFOUND: Example
- Cursor FOR Loops Using Subqueries
- Cursors with Parameters
- FOR UPDATE Clause
- WHERE CURRENT OF Clause
- WHERE CURRENT OF Clause: Example
- What Is an Exception?
- Handling an Exception: Example
- Understanding Exceptions with PL/SQL
- Handling Exceptions
- Exception Types
- Syntax to Trap Exceptions
- Guidelines for Trapping Exceptions
- Trapping Internally Predefined Exceptions
- Internally Defined Exception Trapping: Example
- Trapping Predefined Exceptions
- Functions for Trapping Exceptions
- Trapping User-Defined Exceptions
- RAISE Statement
- Trapping User-Defined Exceptions
- Propagating Exceptions in a Sub-Block
- The RAISE_APPLICATION_ERROR Procedure
- What Are PL/SQL Subprograms?
- Differences Between Anonymous Blocks and Subprograms
- Procedure: Syntax
- Creating a Procedure
- Invoking a Procedure
- Function: Syntax
- Creating a Function
- Invoking a Function
- Passing a Parameter to the Function
- Invoking the Function with a Parameter
- Introduction to Oracle Cloud
- Oracle Cloud Services
- Cloud Deployment Models
- Evolving from On-premises to Exadata Express
- What is in Exadata Express?
- Exadata Express for Users
- Exadata Express for Developers
- Getting Started with Exadata Express
- Oracle Exadata Express Cloud Service
- Getting Started with Exadata Express
- Managing Exadata
- Service Console
- Web Access through Service Console
- Client Access Configuration through Service Console
- Database Administration through Service Console
- SQL Workshop
- Connecting through Database Clients
- Enabling SQL*Net Access for Client Applications
- Downloading Client Credentials
- Connecting Oracle SQL Developer
- Connecting Oracle SQLcl
| Schedule for Oracle Database 12c: Program with PL/SQL (Oracle Training in Nagpur, Pune And Bangalore) | ||||
| Course Contents | Exam # | Regular Track (days) | Fast Track (days) | |
| Oracle Database 11g: Program with PL/SQL (Currently No Exam for 12c) | 1Z0-144 | 40 | 5 | |
| Balance Days for arrival, exam(s) and practice | 5 | 3 | ||
| Total duration | 45 | 8 | ||
Testimonials
Apeksha Bawankar
My experience at Unisoft Technologies has been nothing short of amazing. The practical approach to learning here is truly commendable. If you’re looking to get trained in Oracle, Unisoft Technologies is the place to be. The faculty here is incredibly supportive, and their teaching methods are top-notch. The learning environment is excellent. For instance, Saurabh Sir taught us Oracle by comparing various versions of Oracle on different machines, providing clear and comprehensive knowledge. The faculty members are highly experienced and certified. They teach from their wealth of experience, which greatly enhances the learning process. The staff here, including Sushmita Ma’am and Nidhi Ma'am, are very supportive. Unisoft fosters a friendly environment where everyone strives to make you feel comfortable. The owner, Mrs. Pratigya Thakur, is an inspiring and helpful figure. She is a great personality in her own right, and there’s a lot to learn from her. She is always motivating others, which adds to the positive atmosphere. After completing my MCA, I was searching for Oracle certification and training. Unisoft proved to be the best place to get trained. I was under the guidance of Mr. Saurabh Joshi, who guided me exceptionally well and helped in solving my problems. Now, I am an OCA in Oracle 1Z0-071 with a score of 92%, all thanks to Saurabh Sir and my batch mates (Diksha, Deepraj, Swetank, Nidhi, Sayali, and Shiwani) who inspired me. It was an awesome experience learning by doing.