Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
PL/SQL For Beginners
Rating: 4.3 out of 5(22 ratings)
1,794 students

PL/SQL For Beginners

Create functions, Stored Procedures and build PL/SQL Program components
Created by247 Learning
Last updated 3/2026
English

What you'll learn

  • Create PL/SQL Blocks
  • Execute PL/SQL Blocks
  • Create PL/SQL Variables
  • Create PL/SQL Functions
  • Create PL/SQL Stored Procedures
  • Implement conditional statements

Course content

3 sections34 lectures1h 55m total length
  • Introduction0:20
  • Oracle Installation Requirements1:27
  • Download Oracle3:59
  • Install Oracle1:58
  • What is SQLplus3:23
  • Connect SQLplus to Oracle3:13
  • How to start and stop Oracle database1:26
  • What is SQL Developer2:41
  • Install SQL Developer3:41
  • Connect SQL Developer to Oracle2:29
  • Download Sample Schemas2:12
  • Unlock sample schema account5:18
  • Unlock sample schema tables4:39
  • Connect schema account to Oracle1:49
  • Overview of PL/SQL2:04

Requirements

  • Basic database concepts advised
  • Basic knowledge of SQL advised

Description

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.


This course is designed for Software Professionals, who are willing to learn PL/SQL Programming Language in simple and easy steps. This tutorial will give you great understanding on PL/SQL Programming concepts, and after completing this course, you will be at an intermediate level of expertise from where you can take yourself to a higher level of expertise.


Before proceeding with this course, you should have a basic understanding of software basic concepts like what is database, source code, text editor and execution of programs, etc. If you already have an understanding on SQL and other computer programming language, then it will be an added advantage to proceed.


  • PL/SQL is tightly integrated with SQL.

  • It offers extensive error checking.

  • It offers a variety of programming structures.

  • It supports structured programming through functions and procedures.

  • It supports object-oriented programming.

  • It supports the development of web applications and server pages.


Who this course is for:

  • Beginners to PLSQL
  • Beginner Oracle SQL Developers