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!
Course content
- Preview04:28
- 05:01UDEMY 101: How to Use Udemy? +Some Useful Tips
- Preview05:35What is PL/SQL and Why to Use?
- 09:33PL/SQL Architecture
- 07:14The Sample (HR) Schema Used in This Course
- 00:30Welcoming Gifts: Course Material & PL/SQL Cheatsheet
- 5 questionsQuiz 1
Requirements
- Basic knowledge of Oracle SQL
Description
★ Last Course Updates:
✔ (Nov 2021): "Oracle-Supplied PL/SQL Packages" section is added!
✔ (Oct 2021): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!
✔ (Sep 2021): Closed-Captions are added!
✔ (Aug 2021): 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(İlk slayt section 8 ve Advanced slayt section 3)
Using Java/C in PL/SQL(Advanced section 7)
Managing Dependencies
Final Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL.
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.6 Instructor Rating
- 27,352 Reviews
- 119,812 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.6 Instructor Rating
- 27,352 Reviews
- 119,812 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!
✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯