Oracle PL/SQL For beginners using TOAD and SQL Developer

Oracle PL/SQL For beginners using TOAD and SQL Developer, available at $54.99, has an average rating of 4.15, with 37 lectures, based on 21 reviews, and has 1289 subscribers.

You will learn about 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 This course is ideal for individuals who are Software Professionals, who want to learn PL/SQL or Beginner SQL Developers It is particularly useful for Software Professionals, who want to learn PL/SQL or Beginner SQL Developers.

Enroll now: Oracle PL/SQL For beginners using TOAD and SQL Developer

Summary

Title: Oracle PL/SQL For beginners using TOAD and SQL Developer

Price: $54.99

Average Rating: 4.15

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $39.99

Quality Status: approved

Status: Live

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

Who Should Attend

Software Professionals, who want to learn PL/SQL
Beginner SQL Developers

Target Audiences

Software Professionals, who want to learn PL/SQL
Beginner SQL Developers

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: Oracle Database Setup

Lecture 1: Introduction

Lecture 2: Oracle Installation requirements

Lecture 3: Download Oracle

Lecture 4: Install Oracle

Lecture 5: Connect SQLPlus to Oracle

Lecture 6: How to start and stop Oracle Database Server

Lecture 7: What is SQL Developer

Lecture 8: Install SQL Developer

Lecture 9: Connect SQL Developer to Oracle

Lecture 10: Download Sample Schemas

Lecture 11: Unlock sample HR Schema Account

Lecture 12: Unlock sample schemas tables

Lecture 13: Connect Schema account to Oracle

Lecture 14: What is TOAD

Lecture 15: Install TOAD

Lecture 16: Connect Toad to Oracle

Lecture 17: Create a new connection in TOAD

Chapter 2: PL/SQL Essentials

Lecture 1: What is PL/SQL

Lecture 2: PL/SQL Block Structure

Lecture 3: Execute a PL/SQL Anonymous Block using TOAD

Lecture 4: PL/SQL Variables

Lecture 5: PL/SQL Variable Declaration

Lecture 6: PL/SQL Variable Assignment

Lecture 7: PL/SQL Variable Anchors

Lecture 8: Executing PL/SQL Variable Assignment using TOAD

Lecture 9: Initializing Variables in PL/SQL using TOAD

Lecture 10: PL/SQL Literals

Lecture 11: Variable Scopes in PL/SQL using TOAD

Lecture 12: Introduction to PL/SQL Functions

Lecture 13: Creating Functions

Lecture 14: Creating PL/SQL Functions using TOAD

Lecture 15: What are PL/SQL Stored Procedures

Lecture 16: How to create stored procedure using TOAD

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

Lecture 18: PL/SQL Data Types

Lecture 19: PL/SQL IF Statements

Lecture 20: PL/SQL IF Statements example using TOAD

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

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