Oracle PL/SQL For beginners using TOAD and SQL Developer
Oracle PL/SQL For beginners using TOAD and SQL Developer
Last updated 2023-01-14
Duration: 01:59:03 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 611 MB
Genre: eLearning | Language: English [Auto]
Last updated 2023-01-14
Duration: 01:59:03 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 611 MB
Genre: eLearning | Language: English [Auto]
Build PL/SQL Programs like Functions and Stored Procedures
What you'll 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
Requirements
Basic understanding of database concepts like databases, tables advised.
Basic understanding 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 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.
Who this course is for:
Software Professionals, who want to learn PL/SQL
Beginner SQL Developers
More Info