Udemy – PL/SQL Programming with Real-World Examples

Description

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 the database can be run next time. The purpose of this training 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 numbers

PL SQL-Programming training course specifications

English language

Duration: 04:10:00

Number of courses: 17

Instructor: Dr. Rick Phillips

File format: Video: AVC, 1280 * 720 | Audio: AAC 44KHz 2ch

Ability to play on: Windows, mobile, TV

PL / SQL Programming course content

Familiarity with the syntax and structure of PL / SQL language

Build real applications with this language

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

Requirements

Those taking this course should have prior working knowledge of SQL and at least one full-featured programming language.

Installation

After Extract with the player you want to see.