A Comprehensive Guide to Make You a Job-Ready PL/SQL Developer.Also Covers Oracle 1Z0-144 and 1Z0-149 PL SQL Exam Topics
Latest Course Updates:
(Aug 2024) : "Oracle-Supplied PL/SQL Packages" section was added!
(Jun 2024): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!
(May 2024) : High-Quality Closed-Captions are added!
(Apr 2024): New Quiz Questions are added!
Become an Oracle Database PL/SQL Developer Certified Professional!
This comprehensive PL/SQL Programming Bootcamp is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a Hero in PL/SQL will find everything that they are looking for.
Students will learn and improve their:
PL/SQL Coding Skills
SQL & PL/SQL Performance
PL/SQL Scalability
Portability and Security of Database and PL/SQL Programming
And also our students will be prepared for:
(NEW!) Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL Oracle Certification Exam
Exam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL | Oracle Certification Exam
Exam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam
Exam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam
Our PL/SQL Programming Bootcamp Covers:
PL/SQL Terminologies
PL/SQL Architecture
PL/SQL Variables
PL/SQL Control Structures
If-Then-Else Structure
Case Expressions
Loops
While Loop
For Loop
Nested Loop
Loop Labeling
Continue Statement
GOTO Statement
Using SQL inside PL/SQL
PL/SQL Cursors
Using PL/SQL Program Units (Functions & Procedures)
PL/SQL Packages
PL/SQL Exceptions & Exception Handling
PL/SQL Debugging
Dynamic SQL & PL/SQL
PL/SQL Composite Data Types (Collections)
Associative Arrays
Nested Tables
Varrays
Records
PL/SQL Triggers
Oracle-Supplied Packages
Using Large Objects in PL/SQL (LOBs)
Using PL/SQL Object Oriented
Using PL/SQL Compiler
PL/SQL Performance &Tuning
PL/SQL Caching
PL/SQL Security
PL/SQL Fine-Grained Access Control (VPD)
PL/SQL Hints
PL/SQL Object Dependencies
Designing Better PL/SQL
Using Java/C in PL/SQL
Managing Dependencies
Important Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL
See you in the first lecture!
Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!
Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
7 Lectures
17 Lectures
2 Lectures
13 Lectures
16 Lectures
7 Lectures
17 Lectures
17 Lectures
10 Lectures
20 Lectures
14 Lectures
27 Lectures
6 Lectures
16 Lectures
10 Lectures
3 Lectures
4 Lectures
1 Lectures
We have been working for more than 28 years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 25+ years on SQL & PL/SQL programming using many different Oracle Technologies.Currently, I work as a Project Manager on a huge database which has more than 20 million active-users, and at the same time,...
Hi, welcome to our courses.'Code Star' Academy is a platform and community that teaches SQL & PL/SQL Development, SQL Tuning, Python Programming, Web Development and many Computer Science related topics. Through a passion for tech and what it means to be a Computer Scientist and Developer, Code Star Academy creates great courses, blog posts and videos to instruct, inspire and...
Wonderful experience!
Very good course, I did learn a lot of stuff I didn't know especially about collections, cursors, and dynamic SQL & PL/SQL.
I did enjoy all the course, now I have to apply everything I did learn in my daily job.
Thanks you did a very good job with this course.
Очень полезный курс, даже для работающих
I was not able to install the oracle database correctly. the resource files are quite old. Please replace them with the current version of files.
good thanks for the information
Very detailed in explaining each topic with good example code.
The content was good but fell short of the completeness promised in the overview. When I asked two questions, I received no response, which was disappointing. Additionally, there was supposed to be a bonus for enrolling in other courses, but nothing has been provided.
very well explain so far.
It explains the theory which i haven't heard before and that help me understand the why vs just the how to use PL/SQL
Your email address will not be published. Required fields are marked *
Shubham R. P.
Its Great to learn from the best !