Oracle Database: PL/SQL Fundamentals Ed 2

loading..
(Course eligible for SATVs)

Call for a Quote

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Lessons

  • Understanding the benefits and structure of PL/SQL
  • Understanding PL/SQL Blocks
  • Generating output messages in PL/SQL

Lessons

  • Identifying valid and invalid identifiers
  • Declaring and initializing variables
  • Various data types
  • Identifying the benefits of using the %TYPE attribute
  • Using bind variables

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

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

•Required Prerequisites:•Familiarity with data processing concepts and technique•Familiarity with programming languages•Oracle Database 12c: Introduction for Experienced SQL Users•Suggested Prerequisites:•Familiarity with data processing concepts and techniques•Familiarity with programming languages

After completing this course, students will be able to:

Register

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          NextTechLive   

            Show all

            Flexible Mentored Learning   

              Show all

              Flexible Mentored Learning   

                Show all

                Flexible Mentored Learning   

                  Show all

                  Flexible Mentored Learning   

                    Show all
                    Need your team upskilled?
                    Looking to upskill your team

                    blah is false