Oracle Oracle PLSQL for Beginners

Oracle PLSQL for Beginners

Catalog: Oracle
Short name: PLSQL for Beginners
Course start date: 2024-07-02
Paystack
Enroll Me

Description

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language.

Participants learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Participants learn to create anonymous PL/SQL blocks as well as stored procedures and functions.

Participants learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers.

Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.

Participants are introduced to the utilization of some of the Oracle-supplied packages.

This course is a combination of Oracle Database PL/SQL Fundamentals and Oracle Database Develop PL/SQL Program Units courses. Participants use Oracle SQL Developer to develop these program units.

Course Duration:-3h 28m

Sections

General
0 activities

About PLSQL Enviornment and Benefits
Benefits of Sub programs ‚ Invoking Procedures and Functions
PLSQL Block Structure‚ Block Type and Program Structure
PLSQL Block Structure‚ Block Type and Program Structure count..
Naming Rules‚ Scalar Data types
Base scalar data types
Percentage type Attributes‚ Composit Data Types
Declaring Variables
PLSQL Block Syntax‚ SQL function in PLSQL
Nested Blocks‚ Identifiers‚ Programming Guidelines
Practical Examples Session 2
SQL Statements and Naming Conventions
Manipulating Data‚ Naming Conventions
SQL Cursor
Practical Examples Session 3 - 1
Practical Examples Session 3 - 2
Writing Control Structures
If Statements and Case Expressions
Logic Tables and Iterative Constructs
WHILE Loops
Practical Examples Session 4-1
Practical Examples Session 4-2
PLSQL record and rowtype Attribute
Creating and Using Index By Table
Creating and Using Index By Table (summary)
Working with Composite Data Types
Course Certificate
Secure Video
26
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-3h 28m