• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

Introduction
Introduction FREE 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:00:00

Oracle 11g PL/SQL Beginner

4.7( 9 REVIEWS )
26 STUDENTS
Duration: 9.92 Hours
PRIVATE
Oracle 11g PL/SQL Beginner

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.

  • Learning outcome
  • 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

  • Learners of all backgrounds and qualifications can enroll in this course. Being Familiar with database and programming principles will help learners quest.
  • Why should I take this course?
  • 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.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel

Select your currency
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only$68.11 / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon