PL/SQL Programming With Real World Examples Online Course

PL/SQL Programming with Real World Examples

All levels
English

Course Description

Oracle relational databases are currently one of the most popular databases on the market, with a lot of companies looking to use these databases within their infrastructure. Oracle databases are often use Java and SQL for programming, but it wasn’t giving the results that Oracle wanted, which is why they designed the PL/SQL language to add the procedural features of programming languages, making the databases more moldable to the programmer’s needs. PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. The program units are compiled by the Oracle Database server and are commonly stored within the server itself. At run time, the PL/SQL and SQL run at the same time and within the same server process, saving time and offering optimal efficiency.

See more less

What you’ll learn

Introduction to PL/SQL
Setting up your Sandbox
PL/SQL fundamentals
Building real-world PL/SQL components including:
development of a password strength function,
parsing XML files,
reading an external directory, and
generating random number, range-based random number and even weighted random numbers.

Covering Topics

Section 1 : Introduction

Section 2 : Setting Up Your Sandbox

Section 3 : PL/SQL Language Fundamentals

Section 4 : Building Real-World PL/SQL Components

Section 5 : Course Overview and Summary

Curriculum

  Section 1 : Introduction
1
Introduction

  Section 2 : Setting Up Your Sandbox
2
Establishing Your Programming Environment

  Section 3 : PL/SQL Language Fundamentals
3
Primitive Datatypes and PL/SQL Syntax Elements
4
User-Defined Data Types and Structures
5
Flow Control Preview
6
Variable Scope and Exception Management

  Section 4 : Building Real-World PL/SQL Components
7
Triggers Part 1
8
Triggers Part 2 Preview
9
Procedures Part 1 Parsing an External XML File
10
Procedures Part 2 External Directory Listing
11
Functions Part 1 Password Strength Calc
12
Functions Part 2 Pick Next Play
13
Packages Part 1
14
Packages Part 2

  Section 5 : Course Overview and Summary
15
Summary and Overview Part 1
16
Summary and Overview Part 2
17
Summary and Overview Part 3

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.