Oracle 12c: PL/SQL Fundamentals [Class in Los Angeles] @ New Horizons Learning Group LA | CourseHorse

Oracle 12c: PL/SQL Fundamentals is unfortunately unavailable

Thankfully we have 80 other Tech Classes for you to choose from. Check our top choices below or see all classes for more options.

Tableau Desktop Level 1: Introduction for Novice Users

Tableau Desktop Level 1: Introduction for Novice Users

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Unlock the power of data visualization with a comprehensive course designed to ease novice users into the world of Tableau Desktop. Gain practical skills and insights to create impactful visual representations of data.

Beginner 18 and older

Apr 29th

7am–1:45pm PDT

Meets 3 Times

Don't see any dates that work for you?

Add to Wishlist

Mon, Apr 29th, 7am–1:45pm PDT (20 hours & 15 minutes over 3 sessions)

$1,495

3 sessions

+14950 pts

Ultimate UX™ User Experience Design Immersive

Ultimate UX™ User Experience Design Immersive

Beach Coders Academy @ 615 N Nash St, El Segundo, CA

Master the art of creating intuitive, functional, and enjoyable products with the Ultimate UX™ User Experience Design Immersive course. Dive deep into the language, theory, and best practices of UX design in this intensive program. Develop your skills through a final project that will become a valuable addition to your portfolio.

All levels 13 and older

Apr 29th

10am–12:30pm PDT

Meets 8 Times

Apr 29th

10am–12:30pm PDT

Meets 8 Times

Apr 29th

10am–12:30pm PDT

Meets 8 Times

Apr 29th

10am–12:30pm PDT

Meets 8 Times

Apr 29th

1–3:30pm PDT

Meets 8 Times

This class has 75 more dates.

Tap here to see more

Mon, Apr 29th, 10am–12:30pm PDT (20 hours over 8 sessions) Other dates (79)

$2,477

8 sessions

+24770 pts

Python Programming 2: Advanced Programming Techniques

Python Programming 2: Advanced Programming Techniques

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Enhance your expertise in Python with this course designed to equip you with the tools needed to tackle complex programming challenges.

Advanced 18 and older

May 2nd

7am–1:45pm PDT

Meets 2 Times

Don't see any dates that work for you?

Add to Wishlist

Thu, May 2nd, 7am–1:45pm PDT (13 hours & 30 minutes over 2 sessions)

$995

2 sessions

+9950 pts

Photoshop Bootcamp

Photoshop Bootcamp

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Learn the essential tools and techniques to perfect photo manipulation in our comprehensive Photoshop course. Master Photoshop in just five days with step-by-step instruction from a professional graphic designer. Ideal for designers, marketers, and anyone pursuing a career in graphic design.

All levels 14 and older

Apr 29th

9am–4pm PDT

Meets 5 Times

Jun 10th

9am–4pm PDT

Meets 5 Times

Don't see any dates that work for you?

Add to Wishlist

Mon, Apr 29th, 9am–4pm PDT (35 hours over 5 sessions) Other dates (3)

$1,795

5 sessions

+17950 pts

Photoshop Quick Start

Photoshop Quick Start

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Learn the essentials of Photoshop in just one day with this beginner course at Training Connection. Master the basics of photo retouching, color correction, background replacement, and more, and prepare your images for print and web. Ideal for designers, marketers, and those pursuing a career in graphic design.

Beginner 14 and older

Apr 29th

9am–4pm PDT

Jun 10th

9am–4pm PDT

Don't see any dates that work for you?

Add to Wishlist

Mon, Apr 29th, 9am–4pm PDT (7 hours) Other dates (3)

$495

+4950 pts

See all Tech classes Los Angeles

Start Dates (0)

$2,695
40 hours over 5 sessions

Showing 1 – 0 of 0

Save to WishList Give as a Gift

Description

What you'll learn in this oracle database training:

In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c.

Upon successful completion of this course, students will be able to:

work with Oracle database programming using the PL/SQL programming language.
learn the syntax, structure and features of the language.

Course Outline

1 - SELECTION & SETUP OF THE DATABASE INTERFACE

Considering Available Tools

Selecting the Appropriate Tool

Oracle Net Database Connections

Oracle PAAS Database Connections

Setup SQL Developer

Setup SQL*Plus

Setup Jdeveloper

2 - ABOUT BIND & SUBSTITUTION VARIABLES

Using SQL Developer

Using SQL*Plus

3 - CHOOSING A DATABASE PROGRAMMING LANGUAGE

What is Database Programming?

PL?SQL Performance Advantages

Integration wth Other Languages

4 - PL/SQL LANGUAGE FUNDAMENTALS

PL/SQL Program Structure

LANGUAGE SYNTAX RULES

EMBEDDING SQL

WRITING READABLE CODE

GENERATING DATABASE OUTPUT

SQL*PLUS INPUT OF A PROGRAM BLOCK

5 - DECLARE SECTION

About the Declare Section

DECLARE PRIMITIVE TYPES

DECLARATION OPTIONS

NOT NULL

CONSTANT

DATA DICTIONARY INTEGRATION

%TYPE

DECLARE SIMPLE USER---DEFINED TYPES

TYPE... TABLE

TYPE... RECORD

EXTENDED USER---DEFINED TYPES

6 - BEGIN SECTION

About the Begin Section

Manipulating Program Data

Logic Control & Branching

GOTO

LOOP

IF-THEN-ELSE

CASE

7 - EXCEPTION SECTION

ABOUT THE EXCEPTION SECTION

ISOLATING THE SPECIFIC EXCEPTION

PRAGMA EXCEPTION_INIT

SQLCODE &SQLERRM Example

SQL%ROWCOUNT &SELECT...INTO

8 - BEYOND THE BASICS: EXPLICIT CURSORS

ABOUT EXPLICIT CURSORS

EXTENDED CURSOR TECHNIQUES

FOR UPDATE OF Clause

WHERE CURRENT OF Clause

Using FOR…LOOP Cursors

9 - BEYOND THE BASICS: NESTED BLOCKS

10 - BEYOND THE BASICS: DECLARED SUBPROGRAMS

USING DECLARED SUBPROGRAMS

DECLARED PROCEDURE

DECLARED FUNCTION

11 - INTRODUCING DATABSE-RESIDENT PROGRAM UNITS

ABOUT DATABASE---RESIDENT PROGRAMS

PHYSICAL STORAGE & EXECUTION

TYPES OF STORED PROGRAM UNITS

STORED PROGRAM UNIT ADVANTAGES

MODULAR DESIGN PRINCIPLES

12 - CREATING STORED PROCEDURES & FUNCTIONS

STORED PROCEDURES & FUNCTIONS

CREATE PROCEDURE / CREATE FUNCTION

CREATING PROCEDURES & FUNCTIONS

RAISE_SALARY() Procedure

SALARY_VALID() Function

THE PARAMETER SPECIFICATION

DEFAULT Clause

SYSTEM & OBJECT PRIVILEGES

USING THE DEVELOPMENT TOOLS

13 - EXECUTING STORED PROCEDURES & FUNCTIONS

CALLING PROCEDURES & FUNCTIONS

UNIT TESTING WITH EXECUTE

ANONYMOUS BLOCK UNIT TESTING

SPECIFYING A PARAMETER NOTATION

SQL WORKSHEET UNIT TESTING

CALLING FUNCTIONS FROM SQL

14 - MAINTAINING STORED PROGRAM UNITS

RECOMPILING PROGRAMS

Mass Recompilation Using UTL_RECOMP()

DROPPING PROCEDURES & FUNCTIONS

DROP PROCEDURE / FUNCTION

DATA DICTIONARY METADATA

Using USER_OBJECTS

Using USER_SOURCE

Using USER_ERRORS

Using USER_OBJECT_SIZE

Using USER_DEPENDENCIES

15 - MANAGING DEPENDENCIES

DEPENDENCY INTERNALS

TRACKING DEPENDENCIES

THE DEPENDENCY TRACKING UTILITY

SQL DEVELOPER DEPENDENCY INFO

DEPENDENCY STRATEGY CHECKLISTS

16 - CREATING & MAINTAINING PACKAGES

ABOUT PACKAGES

CREATING PACKAGES

MAINTAINING PACKAGES

PERFORMANCE CONSIDERATIONS

17 - ADVANCED PACKAGE CAPABILITIES

DEFINER & INVOKER RIGHTS

WHITE LITS & ACCESSIBLE BY

PERSISTENT GLOBAL OBJECTS

DEFINING INITIALIZATION LOGIC

OBJECT ORIENTATION SUPPORT

18 - ADVANCED CURSOR TECHNIQUES

USING CUSROS VARIABLES

USING SYS_REFCURSOR

USING CURSOR EXPRESSIONS

19 - USING SYSTEM-SUPPLIED PACKAGE

DBMS_OUTPUT()

UTL_FILE()

FOPEN() EXAMPLE

20 - DATABASE TRIGGER CONCEPTS

ABOUT DATABASE TRIGGERS

DML EVENT TRIGGER SUB---TYPES

DATABASE TRIGGER SCENARIO

TRIGGER EXECUTION MECHANISMS

TRIGGERS WITHIN SQL WORKSHEET

21 - CREATING DATABASE TRIGGERS

STATEMENT-LEVEL TRIGGERS

Using RAISE_APPLICATION_ERROR()

ROW---LEVEL TRIGGERS

EXAMPLES OF TRIGGERS

EMPLOYEE_SALARY_CHECK Example

EMPLOYEE_JOURNAL Example

BUDGET_EVENT Example

INSTEAD OF TRIGGERS

TRIGGERS WITHIN AN APPLICATION

22 - MAINTAINING DATABASE TRIGGERS

CALL SYNTAX

TRIGGER MAINTENANCE TASKS

SHOW ERRORS TRIGGER

DROP TRIGGER

ALTER TRIGGER

MULTIPLE TRIGGERS FOR A TABLE

HANDLING MUTATING TABLE ISSUES

23 - IMPLEMENTING SYSTEM EVENT TRIGGERS

WHAT ARE SYSTEM EVENT TRIGGERS?

DEFININGTHE SCOPE

AVAILABLE SYSTEM EVENTS

SYSTEM EVENT ATTRIBUTES

Refund Policy

For open enrollment classes, ten (10) business days' written notice is required to reschedule a class with no additional fees.

In case of a no-show or a cancellation with less than ten (10) business days before class date: 100% of the class price will be due according to the date of original invoice or date of Term Net 30.

Reviews of Classes at New Horizons Learning Group LA (1)

(4.0-star rating across 1 reviews)

See reviews for other classes at New Horizons Learning Group LA

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 26950 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

New Horizons Learning Group LA

New Horizons Learning Group has been serving businesses and individuals in the Arizona, California and Nevada communities for over 35 years. With ten convenient locations we offer a wide range of technical, application and business skills courses. As the world of computer technology continues to evolve...

Read more about New Horizons Learning Group LA

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Los Angeles educator.

New Horizons Learning Group LA

New Horizons Learning Group LA
Anaheim, Orange County
1900 S State College Blvd Ste 100
Btwn E Katella & E Orangewood Avenues
Anaheim, California 92806 Anaheim, Orange County
1900 S State College Blvd Ste 100
Btwn E Katella & E Orangewood Avenues
Anaheim, California 92806

All classes at this location

Give This Course as a Gift Card

Thousands of classes
No expiration
Unique and memorable gifts for any occasion
Personalized
Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
Instant delivery
Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Credit Cards

(Neigh!)

Made in NYC © CourseHorse, Inc. 2024

Loading...