Mastering Oracle PL/SQL using Oracle Cloud Infrastructure(OCI) - Always Free tier.
Learn PL/SQL fundamentals using Oracle Cloud Infrastructure(OCI) - Free tier. Learn to provision Oracle Cloud Autonomous Database & build expertise in PL/SQL
Oracle SQL,Oracle Database,Development,Data Science
Lectures -49
Resources -13
Quizzes -3
Duration -4.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
The big question is – 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 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 Oracle PL/SQL 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.
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 version – SQL Developer.
Oracle APEX tool and using it to create 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 statement provided in document format for the learner to work upon & provided solution.
Solutions presentation in detail to validate your solution.
Wishing you good luck & a very Happy Learning!!
Goals
What will you learn in this course:
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
Prerequisites
What are the prerequisites for this course?
Basic understanding of Oracle SQL statements.
Oracle Database Access through SQL OR Request / provision Autonomous Oracle Cloud Autonomous Database in OCI free tier
Curriculum
Check out the detailed breakdown of what’s inside the course
Course and Instructor - Introduction.
1 Lectures
- Course and Instructor - Introduction 03:38 03:38
Topics of Coverage
1 Lectures
Different Oracle environment options
1 Lectures
Getting Access to Oracle Cloud Infrastructure (OCI) - Always Free tier
3 Lectures
What is Oracle Autonomous Database?
1 Lectures
What is Compartment in OCI? & its Significance
1 Lectures
Provision Oracle Autonomous Database in Oracle Cloud infrastructure
1 Lectures
Different ways to Connect to Oracle Autonomous Database on OCI
4 Lectures
What is Oracle PL/SQL?
1 Lectures
Oracle PL/SQL Programming Approach.
4 Lectures
Using PL/SQL to interact with Oracle Autonomous Database in OCI
3 Lectures
Use of Cursors in Oracle PL/SQL
3 Lectures
Use of Control Statement in Oracle PL/SQL
4 Lectures
Significance of Exception in Oracle PL/SQL
4 Lectures
Understanding Oracle PL/SQL subprograms - Functions and Procedures
3 Lectures
Composite Datatypes in Oracle PL/SQL
2 Lectures
What are Database Triggers?
2 Lectures
Oracle SQL & PL/SQL Case study.
9 Lectures
Concluding remarks
1 Lectures
Instructor Details
GUHARAJANM
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now