• 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

Oracle 11g PL/SQL Beginner

4.7( 9 REVIEWS )
259 STUDENTS
$ 249.00
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