Master Oracle PL/SQL using Oracle Cloud Infrastructure- Free tier

The big question is: Relational database, & more particularly, 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 are no longer just used by developers but by folks from many different parallel technical fields that need to store, manipulate, and access large volumes of data—analyze it with slice-and-dice concepts to derive meaningful business information so as to have the business in the competitive edge.

For this reason, SQL and PL/SQL aren’t going anywhere. It's stable in popularity and still dwarfs NoSQL databases on a side-by-side comparison.

The advantage of Oracle  PL/SQL is

PL/SQL allows sending an entire block of statements to the database at once, reducing network traffic and providing high application performance.

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 is always free tier, utilize it to learn SQL (not covered in detail in this course ) and PL/SQL, which is covered in detail.

The PL/SQL topics covered in this course are :

• Different Oracle DB environments to Learn & Practice.

• How to get access to Oracle Cloud Free tier.

• An Overview of all new Oracle Autonomous Cloud Database.

• What is a compartment in OCI and its significance.

• Provisioning Oracle Autonomous Database on OCI

• Accessing the Oracle Cloud Autonomous DB for SQL—web and client versions—SQL Developer.

• Oracle APEX tool and using it to create a sample dataset, which would be used for PLSQL demonstration & activity.

• 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 statements are provided in document format for the learner to work on & provide a solution.

•  Solutions presentation in detail to validate your solution.

Wishing you good luck & a very Happy Learning!!