0

  • No products in the cart.

Oracle 19c PL / SQL Fundamentals

ratings 

Oracle 19c PL/SQL Fundamentals is a three—day, hands-on course that introduces Oracle database programming using the PL/SQL programming language.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 4, 2021

Students Enrolled

Total Reviews

Posted by

ashar hafeez

Certification

In this course you learn about:

· Using PL/SQL programming language for database applications and development

· incorporating PL/SQL modules within the application architecture from the initial design and planning phase

· The essentials of building executable PL/SQL program units

· Each of the major segments of a workin g program and how these interact with each other during program execution,

· Important error or exception handling capabilities of the language.

· How database-resident program units can be used as part of the overall database application architecture

· Applying these new skills to the development of PL/SQL packages.

· Advanced database programming capabilities and benefits

· How database triggers can be used as part of an advanced database application design

Course Curriculum

    • CONSIDERING AVAILABLE TOOLS 00:00:00
    • SELECTING THE APPROPRIATE TOOL 00:00:00
    • ORACLE NET DATABASE CONNECTIONS 00:00:00
    • ORACLE PAAS DATABASE CONNECTIONS 00:00:00
    • SETUP SQL DEVELOPER 00:00:00
    • SETUP SQL*PLUS 00:00:00
    • SETUP JDEVELOPER 00:00:00
    • About BIND and Substitution Variables 00:00:00
    • USING SQL DEVELOPER 00:00:00
    • USING SQL*PLUS 00:00:00
    • WHAT IS DATABASE PROGRAMMING? 00:00:00
    • PL/SQL PERFORMANCE ADVANTAGES 00:00:00
    • INTEGRATION WITH OTHER LANGUAGES 00:00:00
    • PL/SQL PROGRAM STRUCTURE 00:00:00
    • LANGUAGE SYNTAX RULES 00:00:00
    • EMBEDDING SQL 00:00:00
    • WRITING READABLE CODE 00:00:00
    • GENERATING DATABASE OUTPUT 00:00:00
    • SQL*PLUS INPUT OF A PROGRAM BLOCK 00:00:00
    • ABOUT THE DECLARE SECTION 00:00:00
    • DECLARE PRIMITIVE TYPES 00:00:00
    • DECLARATION OPTIONS 00:00:00
    • NOT NULL 00:00:00
    • CONSTANT 00:00:00
    • DATA DICTIONARY INTEGRATION 00:00:00
    • %TYPE 00:00:00
    • DECLARE SIMPLE USER-DEFINED TYPES 00:00:00
    • TYPE … TABLE 00:00:00
    • TYPE … RECORD 00:00:00
    • EXTENDED USER-DEFINED TYPES 00:00:00
    • ABOUT THE BEGIN SECTION 00:00:00
    • MANIPULATING PROGRAM DATA 00:00:00
    • LOGIC CONTROL & BRANCHING 00:00:00
    • GOTO 00:00:00
    • LOOP 00:00:00
    • IF-THEN-ELSE 00:00:00
    • CASE 00:00:00
    • ABOUT THE EXCEPTION SECTION 00:00:00
    • ISOLATING THE SPECIFIC EXCEPTION 00:00:00
    • PRAGMA EXCEPTION_INIT 00:00:00
    • SQLCODE & SQLERRM Example 00:00:00
    • SQL%ROWCOUNT & SELECT…INTO 00:00:00
    • ABOUT EXPLICIT CURSORS 00:00:00
    • EXTENDED CURSOR TECHNIQUES 00:00:00
    • FOR UPDATE OF Clause 00:00:00
    • WHERE CURRENT OF Clause 00:00:00
    • Using FOR…LOOP Cursors 00:00:00
    • ABOUT DATABASE-RESIDENT PROGRAMS 00:00:00
    • PHYSICAL STORAGE & EXECUTION 00:00:00
    • TYPES OF STORED PROGRAM UNITS 00:00:00
    • STORED PROGRAM UNIT ADVANTAGES 00:00:00
    • MODULAR DESIGN PRINCIPLES 00:00:00
    • STORED PROCEDURES & FUNCTIONS 00:00:00
    • CREATE PROCEDURE / CREATE FUNCTION 00:00:00
    • CREATING PROCEDURES & FUNCTIONS 00:00:00
    • RAISE_SALARY() Procedure 00:00:00
    • SALARY_VALID() Function 00:00:00
    • THE PARAMETER SPECIFICATION 00:00:00
    • DEFAULT Clause 00:00:00
    • USING THE DEVELOPMENT TOOLS 00:00:00
    • CALLING PROCEDURES & FUNCTIONS 00:00:00
    • UNIT TESTING WITH EXECUTE 00:00:00
    • ANONYMOUS BLOCK UNIT TESTING 00:00:00
    • SPECIFYING A PARAMETER NOTATION 00:00:00
    • SQL WORKSHEET UNIT TESTING 00:00:00
    • CALLING FUNCTIONS FROM SQL 00:00:00
    • RECOMPILING PROGRAMS 00:00:00
    • Mass Recompilation Using UTL_RECOMP() 00:00:00
    • DROPPING PROCEDURES & FUNCTIONS 00:00:00
    • DROP PROCEDURE / FUNCTION 00:00:00
    • DATA DICTIONARY METADATA 00:00:00
    • Using USER_OBJECTS 00:00:00
    • Using USER_SOURCE 00:00:00
    • Using USER_ERRORS 00:00:00
    • Using USER_OBJECT_SIZE 00:00:00
    • Using USER_DEPENDENCIES 00:00:00
    • DEPENDENCY INTERNALS 00:00:00
    • TRACKING DEPENDENCIES 00:00:00
    • THE DEPENDENCY TRACKING UTILITY 00:00:00
    • SQL DEVELOPER DEPENDENCY INFO 00:00:00
    • DEPENDENCY STRATEGY CHECKLISTS 00:00:00
    • ABOUT PACKAGES 00:00:00
    • CREATING PACKAGES 00:00:00
    • MAINTAINING PACKAGES 00:00:00
    • PERFORMANCE CONSIDERATIONS 00:00:00
    • DEFINER & INVOKER RIGHTS 00:00:00
    • WHITE LISTS & ACCESSIBLE BY 00:00:00
    • PERSISTENT GLOBAL OBJECTS 00:00:00
    • DEFINING INITIALIZATION LOGIC 00:00:00
    • OBJECT ORIENTATION SUPPORT 00:00:00
    • USING CURSOR VARIABLES 00:00:00
    • Using SYS_REFCURSOR 00:00:00
    • USING CURSOR EXPRESSIONS 00:00:00
    • DBMS_OUTPUT() 00:00:00
    • UTL_FILE() 00:00:00
    • FOPEN() Example 00:00:00
    • ABOUT DATABASE TRIGGERS 00:00:00
    • DML EVENT TRIGGER SUB-TYPES 00:00:00
    • DATABASE TRIGGER SCENARIO 00:00:00
    • TRIGGER EXECUTION MECHANISMS 00:00:00
    • TRIGGERS WITHIN SQL WORKSHEET 00:00:00
    • STATEMENT-LEVEL TRIGGERS 00:00:00
    • Using RAISE_APPLICATION_ERROR() 00:00:00
    • ROW-LEVEL TRIGGERS 00:00:00
    • EXAMPLES OF TRIGGERS 00:00:00
    • EMPLOYEE_SALARY_CHECK Example 00:00:00
    • EMPLOYEE_JOURNAL Example 00:00:00
    • BUDGET_EVENT Example 00:00:00
    • INSTEAD OF TRIGGERS 00:00:00
    • TRIGGERS WITHIN AN APPLICATION 00:00:00
    • CALL SYNTAX 00:00:00
    • TRIGGER MAINTENANCE TASKS 00:00:00
    • SHOW ERRORS TRIGGER 00:00:00
    • DROP TRIGGER 00:00:00
    • ALTER TRIGGER 00:00:00
    • MULTIPLE TRIGGERS FOR A TABLE 00:00:00
    • HANDLING MUTATING TABLE ISSUES 00:00:00
    • WHAT ARE SYSTEM EVENT TRIGGERS? 00:00:00
    • DEFINING THE SCOPE 00:00:00
    • AVAILABLE SYSTEM EVENTS 00:00:00
    • SYSTEM EVENT ATTRIBUTES 00:00:00

    Course Reviews

    Profile Photo
    ashar hafeez
    0
    62

    Students

    About Instructor

    Pak

    Course Events

    [wplms_eventon_events]

    More Courses by Insturctor

    © 2021 Ernesto.  All rights reserved.  
    X