Oracle PL/SQL Fundamentals with Case Study (OCI)

Build Oracle PL/SQL expertise using Oracle Cloud Autonomous DB (OCI). Built-in case study to make understanding better

4.50 (2 reviews)
Udemy
platform
English
language
Oracle
category
10
students
5 hours
content
Jun 2023
last update
$19.99
regular price

What you will learn

Oracle PL/SQL Programming

Provisioning Oracle Cloud Autonomous Database with Oracle Cloud Infrastructure(OCI)

Connecting to Cloud Autonomous Database using SQL Developer client.

Case study to make understanding of PL/SQL better

Description

The big question is – is SQL & PLSQL still relevant and should you learn it? Well, the answer is: Yes.

SQL & PL/SQL has established itself as the de-facto data access language used across many different industries, that's available in the database. 

This means that SQL & PL/SQL is no longer just used by developers, but folks from many different parallel technical fields that need to store, manipulate,  and access large volumes of data - analyse it with slice and dice concept to derive meaningful business information so as to have the business in competitive edge.

For this reason, SQL and PL/SQL isn’t going anywhere. Its stable in popularity and still dwarfs NoSQL databases on a side by side comparison.

The advantage of PLSQL is

PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications.

PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database.

Applications written in PL/SQL are fully portable.

With this course, you can learn how to provision the latest Oracle Cloud Autonomous Database 19c which is provided on

Oracle cloud infrastructure as always free tier , utilize it to learn SQL (not covered in detail in this course ) and PL/SQL, which is covered in details.


The PL/SQL topics covered in this course are :


  • Different Oracle DB environment to Learn & Practice.

  • How to get access to Oracle Cloud Free tier.

  • An Overview about all new Oracle Autonomous Cloud Database.

  • Provisioning Oracle Autonomous Database on OCI

  • Accessing the Oracle Cloud Autonomous DB for SQL - web and client version – SQL Developer.

  • What is PLSQL?

  • Oracle PLSQL programming approach

  •            Naming conventions and formatting.

  •            Scope of variable declaration &  nested block

  • Using PLSQL to interact with Oracle DB

  • Cursors in PLSQL.

  • Control Statement in PLSQL

  • Handling Exceptions in PLSQL

  • Subprograms  & Composite data type

  • Database triggers.

  • Case study in SQL & PLSQL

  •     Business case & problem statement provided in document format for the learner to work upon & provided solution.

  •     Solutions presentation in detail to validate your solution.


Happy Learning!!

Content

Introduction

Topics of Coverage - Course Introduction

Oracle Environments Options

Oracle Environment Options

Getting Access to Oracle Cloud - Free tier

Getting Access to Oracle Cloud - Free tier - Part 1
Getting Access to Oracle Cloud - Free tier - Part 2

What is Oracle Autonomous Database?

What is Oracle Autonomous Database

Provisioning Oracle Cloud Autonomous Database on Oracle Cloud Infrastructure.

Provisioning Oracle Cloud Autonomous Database - Part 1
Provisioning Oracle cloud Autonomous Database - Part 2

Using different tools to access the Cloud autonomous Database

Admin and Developer tools
Using Oracle SQL Built in web tool on cloud to access autonomous DB
Using SQL developer client
Connecting to Oracle Cloud Autonomous DB (OCI) using Oracle SQL developer client

What is PL/SQL?

What is PL/SQL

PL/SQL Programming approach

PL/SQL Programming - naming convention, comments and code formatting
PL/SQL formatting using SQL developer tool
Scope of variable declaration & nested block
Scope of variable declaration & nested block - Demonstration

Using PLSQL to interact with Oracle Database

Using PLSQL to interact with Database
PLSQL Interaction with Database - Demonstration
Quiz

Cursors in PLSQL

Cursors in PLSQL
Cursors in PLSQL - Demonstration
Cursor FOR loop

Control statements in PLSQL

Control Statements in PLSQL
Conditional statement in PLSQL - IF/THEN and Case
Quiz

Using Exceptions in PLQL

Understanding Exceptions handling
Oracle defined exception handling
Non pre-defined exception handling in Oracle PLSQL
User defined exception handling

Understanding Oracle PLSQL subprograms - procedure & functions

Understanding PLSQL Subprograms - Procedure & Functions
Oracle PLSQL - Procedure - Demonstration
Oracle PLSQL - Function - Demonstration

Composite Datatypes in Oracle PLSQL

Composite Datatypes in Oracle PLSQL
Quiz

What are Oracle Triggers?

Database triggers - An overview
Database trigger - Demonstration

Oracle SQL & PLSQL Case study.

Oracle SQL Case study - Business case & Problem statement
Oracle SQL Case Study - Solution Details
Oracle PLSQL Case Study - Business case & Problem statement
Oracle PLSQL Case Study - Solution Approach
Oracle PSLSQL Case Study -Solution -Update of Requisition Delivery Date -Part 1
Oracle PLSQL Case Study - Solution - Update Order columns - Part 2
Oracle PLSQL Case Study -Solution -Invoice generation procedure -Part 3
Oracle PLSQL Case Study - Solution - Trigger on Invoice table
Oracle PLSQL Case Study - Solution - Package creation - Part 5.

Concluding Remarks

Concluding Remarks

Screenshots

Oracle PL/SQL Fundamentals with Case Study (OCI) - Screenshot_01Oracle PL/SQL Fundamentals with Case Study (OCI) - Screenshot_02Oracle PL/SQL Fundamentals with Case Study (OCI) - Screenshot_03Oracle PL/SQL Fundamentals with Case Study (OCI) - Screenshot_04

Charts

Price

Oracle PL/SQL Fundamentals with Case Study (OCI) - Price chart

Rating

Oracle PL/SQL Fundamentals with Case Study (OCI) - Ratings chart

Enrollment distribution

Oracle PL/SQL Fundamentals with Case Study (OCI) - Distribution chart
4651368
udemy ID
4/20/2022
course created date
5/7/2022
course indexed date
Bot
course submited by