Oracle PL/SQL - Certification Training

Location
Online
Dates
Can be taken anytime (10 hours)
Course Type
Professional Training Course
Accreditation
-
Language
English
Price
$129 $13 only

Course Overview

PL/SQL is simply a 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.

Course content

Overview of PL/SQL 1. What is PL/SQL? What are the benefits? 2. PL/SQL Block Structure & Types of Blocks 3. Writing simple anonymous block 4. Using SQL*plus to run anonymous block 5. Creating Script and run it Declaring PL/SQL Variables 1. About Variables and the syntax 2. Defining Variables exercise 3. Guidelines for declaring & initializing variables 4. Delimiters in string literals (the q' Notation) 5. Types of variables and data types 1 6. Types of variables and data types 2 7. Data Types exercise 8. Define Variables Using %TYPE 9. Understating the SELECT statement in PL/SQL 10. Bind Variables Writing Executable Statements 1. Inside PL/SQL Block 2. Inside PL/SQL Block (exercise) 3. Nested Blocks 4. SQL & PL/SQL programming Guidelines Interacting with Oracle DB Server 1. SELECT statement & DML in PL/SQL 2. SELECT statement & DML in PL/SQL exercise 3. Understanding Implicit SQL cursor/ SQL Attributes 4. Implicit SQL cursor exercise

About Course Provider

Uplatz is an innovative digital marketplace for smart learning. It is a tutor-based 1:1 learning platform. We have a strong network of qualified and experienced tutors providing hot courses (such as Big Data, Hadoop, SAP FICO, Informatica, Python, and more..) in a virtual classroom set-up.

And guess what? No one in the market can beat us in course prices! Each of our courses is listed at 80% discounted rate from average market price of the same course.

What more, we have a strong technical team with a mentor from IIT Kanpur! Digital, digital, digital...

Happy Learning at uplatz!

How to enroll?

Provide us with your contact details, course provider will get back to you.

A representative from Uplatz will contact you soon.