The PL SQL-Programming course examines the PL / SQL language. This language is a customized version of SQL developed by the developer for the oracle database. The syntax of this language is almost similar to Pascal and Ada languages. This language is one of the three languages available to you alongside SQL and Java in the Oracle database. Programs written in this language and stored in a database can be run next time. The purpose of this course is to study the concept and structure of this language in detail and take a closer look at its various datatypes. Of course, how to build custom data types is also taught. In the next part of the training, the flow control, the field of variables and how to manage errors are taught.
The main part of this course is dedicated to the basic knowledge of this language so that you have a complete understanding of the structure of the language to be able to build real programs. In this course, several real examples are taught, which are:
- Develop a function to detect the strength of passwords
- Parse XML files
- Reading from external folders
- Generate random numbers, random numbers in a specified range and even weighted random number
Complete list of educational topics and titles
Introduction
1 lecture 04:50
Setting Up Your Sandbox
1 lecture 09:03
PL / SQL Language Fundamentals
4 lecture 57:40
Building Real-World PL / SQL Components
8 lecture 02:08:13
Course Overview and Summary
3 lecture 50:14
nstallation guide
After Extract with the player you want to see.