30-days Money-Back Guarantee
Guha Rajan M., B.Engg, MBA
Learn PL/SQL fundamentals using Oracle Cloud Infrastructure(OCI) - Free tier. Learn to provision Oracle Cloud Autonomous Database & build expertise in PL/SQL
Updated on Sep, 2026
Office Productivity, Oracle, Oracle SQL
Duration - 4.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
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.
Oracle PLSQL programming approach
Naming conventions and formatting.
Scope of variable declaration & nested block
Using PLSQL to interact with Oracle DB
Control Statement in PLSQL
Handling Exceptions in PLSQL
Subprograms & Composite data type
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!!
Oracle PL/SQL Programming
Provisioning Oracle Cloud Autonomous Database with Oracle Cloud Infrastructure (OCI)
Connecting to a Cloud Autonomous Database using SQL Developer client.
Case study to make understanding of PL/SQL better
Basic understanding of Oracle SQL statements.
Oracle Database Access through SQL OR Request/provision Autonomous Oracle Cloud Autonomous Database in OCI free tier
Check out the detailed breakdown of what’s inside the course
Having over 25 + years of IT industry experience (Product development, Consulting & Training).
His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.
Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.
Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management.
He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.
Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of ERP, BI , Cloud technologies - Saas, Iaas, Paas, Internet of things, Machine learning, AI and open source software tools these days.
Due to his vast experience, he has crafted varied unique courses in Tutorialspoint related project management, Internet of things, ERP & BI, Database modeling and design, SQL, Linux and more importantly on Cloud Infrastructure. Has plans to create more, as his passion has been on knowledge acquisition and sharing.
Oracle Financials Business Process Certified Foundations Associate
Oracle Cloud Infrastructure 2021 Architect Professional.
Oracle Cloud Infrastructure 2021 Architect Associate.
Oracle Cloud Infrastructure 2021 Cloud Operations Associate.
Oracle Cloud Infrastructure Security 2021 Certified Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Machine Learning using Autonomous Database 2021 Certified Specialist
Also certified in Python, IOT by NPTEL (Govt of India ) 2018.
He holds a degree in engineering (Computer science) with MBA
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.