What you'll get
- 22+ Hours
- 7 Courses
- Course Completion Certificates
- Self-paced Courses
- Technical Support
- Case Studies
Synopsis
- Learn PL/SQL from beginner to advanced level with step-by-step explanations.
- Understand PL/SQL architecture and use SQL Developer efficiently.
- Work with real-world examples and hundreds of practical coding exercises.
- Master advanced SQL techniques and dynamic PL/SQL queries.
- Improve SQL and PL/SQL performance with tuning techniques.
- Learn object-oriented programming concepts in PL/SQL.
- Become a job-ready Oracle PL/SQL developer through hands-on practice and certification-focused training.
Content
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| Introduction to Oracle PLSQL 21c | 1h 11m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| PLSQL Developer-Project #1 | 3h 05m | ✔ | View Curriculum |
| PLSQL Project #2 | 5h 24m | ✔ | View Curriculum |
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| Oracle 9i PL/SQL:01 - The Fundamentals | 3h 29m | ✔ | View Curriculum |
| Oracle 9i PL/SQL:02 - Procedures and Functions | 3h 15m | ✔ | View Curriculum |
| Oracle 9i PL/SQL:03 - Subprograms | 3h 52m | ✔ | View Curriculum |
| Oracle 9i PL/SQL:04 - Database Triggers | 3h 12m | ✔ | View Curriculum |
Description
This comprehensive PL/SQL Programming Bootcamp is designed for learners from beginners to advanced, offering hundreds of real-world examples to master Oracle PL/SQL. The course covers everything from the basics for non-programmers to advanced topics for experienced developers, preparing students to become skilled Oracle PL/SQL developers. Participants will enhance their skills in PL/SQL coding, SQL, and PL/SQL performance, scalability, and database security.
The training also prepares students for Oracle certification exams, including:
- 1Z0-149 Oracle Database 19c: Program with PL/SQL
- 1Z0-148 Oracle Database 12c: Advanced PL/SQL
- 1Z0-144 Oracle Database 12c: Program with PL/SQL
- 1Z0-144 Oracle Database 11g: Program with PL/SQL
The course covers essential PL/SQL concepts and features, including environment setup, Oracle database tools, language syntax, DECLARE and BEGIN clauses, EXCEPTION handling, explicit cursors, nested blocks, and declared subprograms. Through hands-on practice and structured learning, students gain the knowledge and experience needed to excel in real-world PL/SQL development and certification exams.
Requirements
- Familiarity with database concepts and programming principles.
- Basic knowledge of Oracle SQL.
Target Audience
- Anyone interested in learning PL/SQL programming, from beginner to advanced levels.
- Individuals preparing for Oracle certification exams: 1Z0-144, 1Z0-148, and 1Z0-149.
- SQL developers, database administrators, application designers, and software developers seeking to enhance PL/SQL skills.
