Udemy – Oracle PL/SQL Fundamentals vol. I & II 2018-2

Description

Oracle PL / SQL Fundamentals vol. I & II is a training course on the Udemy site that introduces you to the PL / SQL database programming language. PL / SQL is an Oracle programming language built for SQL and Oracle relational databases. This language has structures such as conditional statements, loops, variables, and exceptions, and allows you to define functions and data types. This course is built in two separate sections and introduces you to the basics up to the advanced PL / SQL language commands.

In the first part of this course, you will learn the basics of the PL / SQL language and learn things like its syntax, structure, and features by working on database applications. In the second part, you will learn topics such as the basic shape and structure of storage units in a database, and how to build and maintain functions, packaged programs, and database triggers. At the end of the course, the instructor will teach you how to use advanced programming techniques such as cursor variables and cursor markers and prepare you for the Oracle OCP exam.

Items that are taught in this course

Environment preparation

Familiarity with database programming units

Construction and maintenance of packages

Use of ready-made system packages

Construction and maintenance of database triggers

Run System Event Trigger

Working with Oracle database tools

Familiarity with PL / SQL language features

Use nested blocks

Use a simple cursor

Oracle PL / SQL Fundamentals vol. I & II

English language

Duration: 19 hours and 59 minutes

Number of lessons: 97

Level of education: Intermediate

Instructor: Intellezy Trainers

File format: mp4

Topics

97 lectures 19:59:18

Oracle 11g PL/SQL Fundamentals I 51 lectures 09:50:45

Oracle 11g PL/SQL Fundamentals II 46 lectures 10:08:33

Prerequisite

Familiarity with database and programming principles

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p