No products in the basket.

Log In Sign Up

Home
Course
Employability
Oracle 11g PL/SQL Beginner

Oracle 11g PL/SQL Beginner

Get 92% Discount | CPD Accredited | Affordable Pricing | No Hidden Charges | 24/7 Tutor Support | Instant Access

4.7

★ ★ ★ ★ ★

★ ★ ★ ★ ★

9 Reviews

stds 27 Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49. FIND OUT MORE

Description

The Oracle 11g PL/SQL Beginner course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts. You’ll learn the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method.

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

Requirements

9.5+ hours of high-quality e-learning content.
Course completion certificate.
To excel as an Application Developer, Designer or Database Administrator.
Code in PL/SQL which further help to boost your career.
This course mostly includes practical examples with explanations which makes it more valuable.

Curriculum

Introduction

Introduction

00:03:00

Preparing Your Environment

Course Setup

00:37:00

Working with Oracle Database Tools

Selecting the Appropriate Database Tool

00:31:00

Language Features

Understanding PL/SQL

00:18:00
PL/SQL Blocks

00:15:00
Working with SQL Plus

00:11:00

The DECLARE Clause

DECLARE Clause Objects

00:16:00
PL/SQL Available Data Types

00:17:00
Declaring Simple Data Types and Assignments

00:12:00
Declaring Complex Data Types and Assignments

00:11:00
Declaring Complex RowTypes and Assignments

00:07:00
Declaring Complex Tables

00:08:00
Declaring Complex Records

00:08:00
Creating and Declaring User-Defined Types

00:09:00

The BEGIN Clause

What Can Be Included in the BEGIN Clause

00:07:00
Working with CHAR and VARCHAR2 Variables

00:08:00
Handling String Literals

00:08:00
Working with Numeric Variables

00:07:00
Working with Date Variables

00:06:00
Assigning and Using Boolean Variables

00:08:00
Using Comparison Operators

00:07:00
Using SQL Functions

00:06:00
SQL DML within PL/SQL

00:15:00
Using SELECT

00:07:00
Exceptions and Embedded SQL

00:11:00
Using Sequences

00:14:00
Logic Control and Branching

00:07:00
Using GOTO

00:06:00
Working with LOOPS

00:19:00
Creating and Using the Indefinite Loop

00:07:00
Creating and Using the Conditional Loop

00:09:00
Using Nested Loops

00:12:00
Using the If-Then-Else

00:19:00
Using the CASE Statement

00:18:00

The EXCEPTION Clause

What Are the Types of Exceptions

00:06:00
Trapping Exceptions

00:06:00
Identify Exception Details

00:11:00
Creating User-Defined Exceptions

00:11:00
Using SQLCODE and SQLERRM Objects

00:09:00
Understand the Implicit Cursor

00:15:00
Creating User-Defined Events

00:12:00

Explicit Cursors

Understanding the Concept and Purpose of Explicit Cursors

00:18:00
Learn about Cursor Attributes

00:10:00
Using the Continue Statement

00:06:00
Working with Updateable Cursors

00:19:00
Creating and Using Cursor Parameters

00:15:00
FOR…LOOP Cursors

00:07:00

Nested Blocks

Understanding Nested Blocks

00:11:00
Difference between Global vs Local Objects and Exceptions

00:13:00

Declared Subprograms

Subprograms: How They Differ from Nested Blocks

00:18:00

Conclusion

Conclusion

00:04:00

Assessment

Order Your Certificate

Order Your Certificate

00:01:00

Oracle 11g PL/SQL Beginner

Free

Save 92% - Grab Now!

Offer Ends in

countdownmail.com

PRIVATE COURSE

Or

All Courses for £49

14-Day Money-Back Guarantee

This course includes:

Duration:

9 hours, 56 minutes
Access:

1 Year
Units:

52

Chat with usLiveChat