PL /SQL For Beginners

Learn about Oracle's Extension to SQL
3.8 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
809 students enrolled
$19
$55
65% off
Take This Course
  • Lectures 12
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2016 English

Course Description

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.

What are the requirements?

  • Basic Knowledge of SQL
  • Basic knowledge of Databases
  • Download and install Oracle Database and TOAD. We'll cover this in the course.

What am I going to get from this course?

  • Choose the correct Delimiters to use with PL/SQL
  • Write PL/SQL Syntax
  • Insert PL/SQL Comments
  • Write PL/SQL Procedures
  • Write PL/SQL Functions
  • Define PL/SQL Cursor
  • Create PL/SQL Triggers

What is the target audience?

  • This course is meant for those who want to learn Oracle's SQL Version
  • Anyone who wants to learn new skill

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Introduction
Preview
02:06
Download Oracle Database
Preview
04:58
Install Oracle Database
Preview
04:47
Oracle Sample Schema
05:09
Download TOAD For Oracle
03:36
Install TOAD For Oracle
04:08
Connect TOAD To Oracle Sample Schema
05:21
What is PL /SQL
03:07
Section 2: Writing Executable Statements
Basic PL/SQL Syntax
11:16
How to comment PL/SQL Code
03:04
PL /SQL Delimiters
03:35
Creating a Simple PL /SQL Procedure
13:33

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bluelime Learning Solutions, Learning made simple

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.

Ready to start learning?
Take This Course