The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"
What you'll learn
- 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
- Every Subject is Explained from the Easiest to the Most Advanced.
- Real-World Examples for Every Section
- Some Advanced SQL Techniques
- Use SQL Developer Efficiently for PL/SQL
- Learn PL/SQL Architecture Very Well
- Improve Performance of SQL& PL/SQL Codes
- Create Your Dynamic SQL & PL/SQL Queries
- Learn PL/SQL Object Oriented Programming
- Learn PL/SQL Tuning for Performance
- Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
- Become a Job-Ready Oracle PL/SQL Developer Certified Professional!
Requirements
- Basic knowledge of Oracle SQL
Description
Latest Course Updates:
(Sep 2022): "Oracle-Supplied PL/SQL Packages" section was added!
(Aug 2022): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!
(Jun 2022): Closed-Captions are added!
(May 2022): 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 about Database and PL/SQL Programming
And also our students will be prepared for:
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!
Who this course is for:
- Anyone who wants to learn PL/SQL Programming Language
- Anyone who is looking for Beginner PL/SQL Subjects
- Anyone who is looking for Advanced PL/SQL Subjects
- Anyone who wants to pass "Oracle 1Z0-144 Program with PL/SQL" Exam
- Anyone who wants to pass "Oracle 1Z0-148 Advanced PL/SQL" Exam
- Anyone who wants to pass "Oracle 1Z0-149: Program with PL/SQL" Exam with Oracle Database 19c
- SQL Developers (All Levels)
- Beginner & Intermediate PL/SQL Developers
- Database Administrators
- Application Designers
- Software Developers
Featured review
![Ljubomir Colovic](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructors
- 4.5 Instructor Rating
- 38,321 Reviews
- 167,628 Students
- 7 Courses
I 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, teaching SQL & PL/SQL and many programming languages such as Python, C, Java, PHP programming, etc.
- 4.5 Instructor Rating
- 38,390 Reviews
- 167,628 Students
- 7 Courses
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 spread these topics across a large spectrum.
Our Mission, give others the opportunity to be part of an amazing field whilst teaching them the skills that will allow them to do so.
Our expertise areas are mainly:
★ Programming Languages (Python, SQL, PL&SQL, PHP, Java, etc.)
★ Database Development
★ Data Science
★ Big Data
★ Cloud Computing
★ Data Mining
★ Data Visualization
★ Data Security
★ Computer Security
✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯
► Time is so precious so every second costs you money ($$$)
☞ Don't postpone your dreams ☜
✔ Enroll to our courses right now!
✔ Success is your destiny and we are waiting for you!
✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯