Oracle PL/SQL Online Training

Name: Oracle PL/SQL Online Training
Rating: 4.3 (152 reviews)
Author: Tutorialspoint

Learn Oracle PL/SQL and its programming concepts from scratch with comprehensive online training.

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Tutorialspoint

English [CC]

category icon Development,Database Design,PL/SQL

Lectures -15

Duration -2 hours

4.3 ★★★★ ★

Enroll Course

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Oracle PL/SQL is a procedural extension to the SQL language that is used to develop stored procedures, functions, triggers, and packages in Oracle databases. It is a powerful and versatile language that can be used to automate tasks, implement business logic, and develop complex applications.

Oracle PL/SQL Online Training Overview

In this course, you will learn the fundamentals of Oracle PL/SQL, including the language syntax, variables, data types, operators, control flow statements, functions, procedures, triggers, packages, object-oriented programming, logging, and debugging.

By the end of the course, you will have gained a deeper understanding of Oracle PL/SQL. You will develop the skills you need, the latest techniques, and best practices, to develop and maintain Oracle database applications.

This course is perfect for anyone who wants to learn Oracle PL/SQL. It is a good starting point for Oracle database administrators, Oracle developers, and anyone who wants to develop applications on Oracle databases.

Goals

What will you learn in this course:

Learn the fundamentals of Oracle PL/SQL
Learn the latest techniques and best practices in Oracle PL/SQL
Develop the skills you need to develop and maintain Oracle database applications
Understand the PL/SQL language syntax
Write PL/SQL code that is clear, concise, and efficient
Use PL/SQL to develop stored procedures, functions, triggers, and packages
Apply the latest techniques and best practices in PL/SQL development

Prerequisites

What are the prerequisites for this course?

Basic knowledge of SQL
Some familiarity with programming

Curriculum

Check out the detailed breakdown of what’s inside the course

Oracle PL/SQL
14 Lectures

Oracle Pl/SQL - Introduction 06:11 06:11
Oracle PL/SQL - Getting Started 10:04 10:04
Oracle PL/SQL - Conditional Statements 11:12 11:12
Oracle PL/SQL - Loops 07:25 07:25
Oracle PL/SQL - Implicit Cursors 04:58 04:58
Oracle PL/SQL - Explicit Cursors 06:46 06:46
Oracle PL/SQL - Advanced Cursors 11:36 11:36
Oracle PL/SQL - Exception Handling 08:57 08:57
Oracle PL/SQL - Creating Procedure 14:53 14:53
Oracle PL/SQL - Creating Functions 03:26 03:26
Oracle PL/SQL - Packages 07:30 07:30
Oracle PL/SQL - Advanced Packages 09:29 09:29
Oracle PL/SQL - Database Triggers 24:47 24:47
Oracle - PL/SQL - Advanced Database Triggers 05:27 05:27

Instructor Details

Tutorialspoint

Simply Easy Learning

Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.

The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.

40 million readers read 100 million pages every month

Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!

We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.