Oracle PL/SQL

indu khemchandani

Training

Online

£ 10 VAT inc.

The best Oracle courses

See all

See all

Description

  • Type

    Training

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    8h

  • Duration

    Flexible

PL/SQL is simply Procedural Language extension to the Structured Query Language (SQL). SQL is a powerful language for both querying and updating data in relational databases. Oracle created PL/SQL that extends some limitations of SQL to provide a more comprehensive solution for building mission-critical applications running on Oracle database. PL/SQL is a block structured language i.e. the programs in PL/SQL are logical blocks that can contain any number of nested sub-blocks. PL/SQL includes procedural language elements like conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variable of those types and triggers. It can support Array and handle exceptions (runtime errors). You can create PL/SQL units like procedures, functions, packages, types and triggers, etc. which are stored in the database for reuse by applications. With PL/SQL, you can use SQL statements to manipulate Oracle data and flow of control statements to process the data. PL/SQL is known for its combination of data manipulating power of SQL with data processing power of procedural languages. It inherits the robustness, security, and portability of the Oracle Database.

About this course

Please find the course link below:
https://training.uplatz.com/online-it-course.php?id=oracle-plsql-35

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • SQL
  • PL/SQL
  • Database training
  • PL/SQL Records
  • INDEX BY Tables
  • Understand Exceptions
  • Propagate Exceptions
  • Describe Packages
  • Triggers

Teachers and trainers (1)

Uplatz Elite trainer

Uplatz Elite trainer

SAP ABAP consultant

Course programme

Introduction • Course Objectives • Course Agenda • Describe the ER Schema • PL/SQL development environments available in this course • Introduction to SQL Developer Working with Oracle Cloud Exadata Express Cloud Service • Introduction to Oracle Database Exadata Express Cloud Service • Accessing Cloud Database using SQL Workshop • Connecting to Exadata Express using Database Clients Introduction to PL/SQL • Overview of PL/SQL • Identify the benefits of PL/SQL Subprograms
• Overview of the types of PL/SQL blocks • Create a Simple Anonymous Block • How to generate output from a PL/SQL Block? Declare PL/SQL Variables • List the different Types of Identifiers in a PL/SQL subprogram • Usage of the Declarative Section to Define Identifiers • Use variables to store data • Identify Scalar Data Types • The %TYPE Attribute • What are Bind Variables? • Sequences in PL/SQL Expressions Write Anonymous PL/SQL Blocks • Describe Basic PL/SQL Block Syntax Guidelines • Learn to Comment the Code • Deployment of SQL Functions in PL/SQL • How to convert Data Types? • Describe Nested Blocks • Identify the Operators in PL/SQL SQL Statements in a PL/SQL block • Invoke SELECT Statements in PL/SQL • Retrieve Data in PL/SQL • SQL Cursor concept • Avoid Errors by using Naming Conventions when using Retrieval and DML Statements • Data Manipulation in the Server using PL/SQL • Understand the SQL Cursor concept • Use SQL Cursor Attributes to Obtain Feedback on DML • Save and Discard Transactions Control Structures • Conditional processing using IF Statements

See related categories

Oracle PL/SQL

£ 10 VAT inc.

The best Oracle courses

See all

See all