title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 12c: PL/SQL I - Introduction
Duration
2 Days
Course
DBOR-952
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 12c: PL/SQL I - Introduction course is designed to provide students with an introduction to Oracle database programming using the PL/SQL programming language. Students will learn the syntax, structure and features of the language. This course progresses from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.
This course considers subjects applicable to certification as both an Oracle PL/SQL Developer Certified Associate (OCA) and an Oracle Advanced PL/SQL Developer Certified Professional (OCP). The topics considered are included within 'Exam 1Z0-144: Program With PL/SQL'.
Objectives
Upon completion of the Oracle Database 12c: PL/SQL I - Introduction course, students will be able to:
- Understand the importance of incorporating PL/SQL modules within the application architecture right from the initial design and planning phase
- Build executable PL/SQL program units
- Recognize each of the major segments of a working program and how these interact with each other during program execution
- Explore techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications
Audience
- Application designers and database developers
- Database administrators
- Web server administrators
Prerequisites
- Oracle Database 12c: SQL Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II, & III) are recommended
Topics
- Considering Available Tools
- Selecting The Appropriate Tool
- Oracle NET Database Connections
- Oracle PAAS Database Connections
- Setup SQL Developer
- Setup SQL*PLUS
- Setup JDeveloper
- Using SQL Developer
- Using SQL*PLUS
- What Is Database Programming?
- PL/SQL Performance Advantages
- Integration With Other Languages
- PL/SQL Program Structure
- Language Syntax Rules
- Embedding SQL
- Writing Readable Code
- Generating Database Output
- SQL*PLUS Input Of A Program Block
- 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
- About The BEGIN Section
- Manipulating Program Data
- Logic Control & Branching
- GOTO
- LOOP
- IF-THEN-ELSE
- CASE
- About The EXCEPTION Section
- Isolating The Specific EXCEPTION
- PRAGMA EXCEPTION_INIT
- SQLCODE & SQLERRM Example
- SQL%ROWCOUNT & SELECT...INTO
- About Explicit Cursors
- Extended Cursor Techniques
- FOR UPDATE OF Clause
- WHERE CURRENT OF Clause
- Using FOR…LOOP Cursors
- Using DECLARED Subprograms
- DECLARED Procedure
- DECLARED Function
Related Courses
-
Introduction to Oracle Database 12c and SQL
DBOR-950- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 12c: SQL II - Intermediate
DBOR-951- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.