Brief Introduction
Learn about Oracle's Extension to SQLDescription
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
SQL language.
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:
- How to write PL/SQL syntax
- How to write procedures
- How to create functions
- How to create cursors
- How to create Triggers
- How to insert PL/SQL comments
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.
Requirements
- Requirements
- Basic Knowledge of SQL
- Basic knowledge of Databases
- Download and install Oracle Database and TOAD. We'll cover this in the course.
Bluelime Learning Solutions
3 Raiting
SQL Crash Course for beginners - Learn SQL with MySQL
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Master the SQL statements that every software developer or data analyst needs for designing and developing databases Big databases are everywhere these days....
Complete SQL in VB.Net : Database Apps in Visual Basic & SQL
- 4.1
-
![]()
![]()
![]()
![]()
![]()
10 in 1:Data Entry App, Visual Basic ADO. Net ,Search SQL in VB ,multi user,Image in SQL Server,Backup, Aggregate,Publish Hi There!...
AZ-900 - Microsoft Azure Fundamentals Training Bootcamp 2021
- 4.6
-
![]()
![]()
![]()
![]()
![]()
NEW v3. 0 edition - Improved and completely Recorded from scratch in 2021. Pass AZ-900 Microsoft Azure Fundamentals Exam! Course Updates:...
Best Software QA Testing Training H2K Infosys Live Classes
- 0.0
-
![]()
![]()
![]()
![]()
![]()
QA Software Testing Training Course live classes only, Live Project, ALM, SQL, UNIX, Resume prep,Interview questions Contact today to avail special discounts up to 40%...
