PL /SQL For Beginners

PL /SQL For Beginners, available at $29.99, has an average rating of 3.1, with 13 lectures, based on 23 reviews, and has 1009 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is meant for those who want to learn Oracle's SQL Version or Anyone who wants to learn new skill It is particularly useful for This course is meant for those who want to learn Oracle's SQL Version or Anyone who wants to learn new skill.

Enroll now: PL /SQL For Beginners

Summary

Title: PL /SQL For Beginners

Price: $29.99

Average Rating: 3.1

Number of Lectures: 13

Number of Published Lectures: 13

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: $44.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: Download Oracle Database

Lecture 3: Install Oracle Database

Lecture 4: Oracle Sample Schema

Lecture 5: Download TOAD For Oracle

Lecture 6: Install TOAD For Oracle

Lecture 7: Connect TOAD To Oracle Sample Schema

Lecture 8: What is PL /SQL

Chapter 2: Writing Executable Statements

Lecture 1: Basic PL/SQL Syntax

Lecture 2: How to comment PL/SQL Code

Lecture 3: PL /SQL Delimiters

Lecture 4: Creating a Simple PL /SQL Procedure

Lecture 5: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 4 votes
2 stars: 4 votes
3 stars: 5 votes
4 stars: 4 votes
5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu