Oracle PL/SQL For beginners using TOAD and SQL Developer

Build PL/SQL Programs like Functions and Stored Procedures

4.15 (21 reviews)
Udemy
platform
English
language
Databases
category
Oracle PL/SQL For beginners using TOAD and SQL Developer
1,288
students
2 hours
content
Jan 2023
last update
$49.99
regular price

What you will learn

Create an anonymous PL/SQL block

Execute a PL/SQL anonymous PL/SQL Block

Create PL/SQL Variables

Execute a PL/SQL Variable assignment

Initialize Variables

Create PL/SQL Functions

Create a PL/SQL stored procedures

Execute a stored procedure

Implement conditional statements

Why take this course?

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 numerous data types.

  • 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.


Content

Oracle Database Setup

Introduction
Oracle Installation requirements
Download Oracle
Install Oracle
Connect SQLPlus to Oracle
How to start and stop Oracle Database Server
What is SQL Developer
Install SQL Developer
Connect SQL Developer to Oracle
Download Sample Schemas
Unlock sample HR Schema Account
Unlock sample schemas tables
Connect Schema account to Oracle
What is TOAD
Install TOAD
Connect Toad to Oracle
Create a new connection in TOAD

PL/SQL Essentials

What is PL/SQL
PL/SQL Block Structure
Execute a PL/SQL Anonymous Block using TOAD
PL/SQL Variables
PL/SQL Variable Declaration
PL/SQL Variable Assignment
PL/SQL Variable Anchors
Executing PL/SQL Variable Assignment using TOAD
Initializing Variables in PL/SQL using TOAD
PL/SQL Literals
Variable Scopes in PL/SQL using TOAD
Introduction to PL/SQL Functions
Creating Functions
Creating PL/SQL Functions using TOAD
What are PL/SQL Stored Procedures
How to create stored procedure using TOAD
How to execute or call a stored procedure using TOAD
PL/SQL Data Types
PL/SQL IF Statements
PL/SQL IF Statements example using TOAD

Reviews

Joe
August 29, 2023
This is mostly a good introduction, but a lot of it involved the narrator just reading straight off of slides. Felt a little robotic.

Charts

Price

Oracle PL/SQL For beginners using TOAD and SQL Developer - Price chart

Rating

Oracle PL/SQL For beginners using TOAD and SQL Developer - Ratings chart

Enrollment distribution

Oracle PL/SQL For beginners using TOAD and SQL Developer - Distribution chart

Related Topics

5083742
udemy ID
1/13/2023
course created date
1/17/2023
course indexed date
Bot
course submited by