Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
PL /SQL is Oracle database's version of the standard SQL .
The PL in the SQL stands for Procedural language and combines it's programming abilities
with SQL to make Oracle database's robust and run more efficiently.
It includes the standard SQL language as well as Oracle's proprietary extensions to the standard
PL/SQL is high performance and portable.
PL/SQL can also be accessed from the command line using oracle's database built in SQL*Plus.
PL/SQL is closely integrated with SQL and supports various data types.
PL/SQL can also be used in developing web applications and supports object -oriented programming.
PL/SQL allows you to create procedures ,functions ,cursors and Triggers.
In this course we will setup a test environment from scratch by downloading and installing sample oracle database and TOAD.
Once we have our lab fully setup we will then start writing proper PL/SQL syntax.
What You Will Learn in this course:
The SQL in the PL/SQL is similar to how the standard SQL is used. The way you write a standard Create, Read (Select),update and delete is similar.
Oracle's procedural language is used to add extra functionalities to the SQL language.
At the end of this course you should have the basic skills to write PL/SQL syntax and create procedures,triggers,cursors and functions.You
will also know how to use the delimiters.
Welcome to the course.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started|
Download Oracle DatabasePreview
Install Oracle DatabasePreview
Oracle Sample Schema
Download TOAD For Oracle
Install TOAD For Oracle
Connect TOAD To Oracle Sample Schema
What is PL /SQL
|Section 2: Writing Executable Statements|
Basic PL/SQL Syntax
How to comment PL/SQL Code
PL /SQL Delimiters
Creating a Simple PL /SQL Procedure
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.