Oracle 11g PL/SQL Fundamentals I

An introduction to the PL/SQL database programming language

Created byIntellezy Trainers

Last updated 3/2017

English

What you'll learn

Prepare your environment
Work with Oracle database tools
Understand and work with language features
Work with the DECLARE clause
Work with the BEGIN clause
Work with the EXCEPTION clause
Use explicit cursors
Understand and use nested blocks
Understand the difference between nested blocks and subprograms

Course content

11 sections • 51 lectures • 9h 50m total length

Introduction3:06
The instructor has provided additional resources and example files for you to use. If you would like to access these, please download the attached .zip file, which contains the files shown in this course.

What Can Be Included in the BEGIN Clause7:02
Working with CHAR and VARCHAR2 Variables7:30
Handling String Literals7:41
Working with Numeric Variables6:40
Working with Date Variables6:00
Assigning and Using Boolean Variables7:44
Using Comparison Operators7:24
Using SQL Functions6:04
SQL DML within PL/SQL15:05
Using SELECT6:32
Exceptions and Embedded SQL11:16
Using Sequences14:28
Logic Control and Branching6:58
Using GOTO5:52
Working with LOOPS18:53
Creating and Using the Indefinite Loop6:59
Creating and Using the Conditional Loop8:48
Using Nested Loops11:33
Using the If-Then-Else18:54
Using the CASE Statement17:43

Requirements

Familiarity with database and programming principles

Description

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming.This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Who this course is for:

Application designers and developers
Database administrators
Business users and non-technical senior end users

Oracle 11g PL/SQL Fundamentals I

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Preparing Your Environment1 lecture • 37min

Working with Oracle Database Tools1 lecture • 31min

Language Features3 lectures • 44min

The DECLARE Clause8 lectures • 1hr 28min

The BEGIN Clause20 lectures • 3hr 19min

The EXCEPTION Clause7 lectures • 1hr 8min

Explicit Cursors6 lectures • 1hr 15min

Nested Blocks2 lectures • 23min

Declared Subprograms1 lecture • 18min

Requirements

Description

Who this course is for: