Oracle PL/SQL for beginners

Oracle PL/SQL for beginners, available at $19.99, has an average rating of 3.83, with 33 lectures, based on 3 reviews, and has 708 subscribers.

You will learn about Create PL/SQL Blocks Execute PL/SQL Blocks Create and initialize variables Create functions Create PL/SQL Stored procedures Execute or call PL/SQL Procedures Use conditional statements to execute block of code This course is ideal for individuals who are Beginners to PL/SQL It is particularly useful for Beginners to PL/SQL.

Enroll now: Oracle PL/SQL for beginners

Summary

Title: Oracle PL/SQL for beginners

Price: $19.99

Average Rating: 3.83

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Create PL/SQL Blocks
Execute PL/SQL Blocks
Create and initialize variables
Create functions
Create PL/SQL Stored procedures
Execute or call PL/SQL Procedures
Use conditional statements to execute block of code

Who Should Attend

Beginners to PL/SQL

Target Audiences

Beginners to PL/SQL

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.

Course Curriculum

Chapter 1: Installing Oracle Database Server

Lecture 1: Introduction

Lecture 2: Oracle installation requirements

Lecture 3: Download Oracle Database Server

Lecture 4: Install Oracle

Lecture 5: What is SQLPlus

Lecture 6: Connect SQLPlus to Oracle

Lecture 7: How to start and stop Oracle Database Server

Lecture 8: What is SQL Developer

Lecture 9: Install SQL Developer

Lecture 10: Connect SQL Developer to Oracle

Lecture 11: Download Sample Schemas

Lecture 12: Unlock sample HR schemas

Lecture 13: Unlock sample HR Schemas Tables

Lecture 14: Connect Schema account to Oracle

Chapter 2: PL/SQL Fundamentals

Lecture 1: what is PL/SQL

Lecture 2: PL/SQL Block Structure

Lecture 3: Execute a PL/SQL Annonymous Block using SQLPlus

Lecture 4: Edit a PL/SQL Code Block using SQLPlus

Lecture 5: PL/SQL Variables

Lecture 6: PL/SQL Variable Declaration

Lecture 7: PL/SQL Variable Assignment

Lecture 8: PL/SQL Variable Anchors

Lecture 9: Initializing Variables in PL/SQL using SQLPlus

Lecture 10: PL/SQL Literals

Lecture 11: Variable Scopes in PL/SQL using SQLPlus

Lecture 12: Introduction to PL/SQL Functions

Lecture 13: Creating Functions

Lecture 14: Creating PL/SQL Functions using SQLPlus

Lecture 15: What are PL/SQL Stored Procedures

Lecture 16: How to create stored procedure using SQLPlus

Lecture 17: How to execute or call a stored procedure using SQLPlus

Lecture 18: PL/SQL IF Statements

Lecture 19: PL/SQL IF Statements example using SQLplus

Instructors

Skill Tree
Skill based learning

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 0 votes
5 stars: 1 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