We may earn an affiliate commission when you visit our partners.

Oracle PL/SQL is My Game

EXAM 1Z0-149

Khaled Alkhudari

4.5

Based on 3,970 ratings

, see reviews

Khaled Alkhudari

This is one of the most amazing Udemy courses in Oracle PLSQL.

The course covers the oracle university track 100% for :

Exam Number: 1Z0-149 : Program with PL/SQL

I designed in this course in a very professional structure that includes huge amount of exercises and examples.

Be sure that you will become expert in PLSQL programming after finishing this course, and you will be ready 100% to pass the Oracle Exam.

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.

Simply this course is the best….

Read more

This is one of the most amazing Udemy courses in Oracle PLSQL.

The course covers the oracle university track 100% for :

Exam Number: 1Z0-149 : Program with PL/SQL

I designed in this course in a very professional structure that includes huge amount of exercises and examples.

Be sure that you will become expert in PLSQL programming after finishing this course, and you will be ready 100% to pass the Oracle Exam.

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.

Simply this course is the best….

Or start a personal plan

And upskill with Udemy

What's inside

Learning objectives

The full track of oracle university exam 1z0-144 : program with pl/sql
Oracle database 12c architecture
Downloading and installing oracle database 12c in details
Overview of plsql
Declaring plsql variables
Writing executable statements
Interacting with oracle db server
Writing control structure
Working with composite data types
Using explicit cursors
Handling exceptions
Creating procedures
Creating functions

Creating packages
Working with packages
Using oracle-supplied packages in application development
Using dynamic sql
Design consideration for plsql code
Creating triggers
Creating compound, ddl, and event database triggers
Using the plsql compiler
Managing plsql code
Managing dependencies
Show more
Show less

The full track of oracle university exam 1z0-144 : program with pl/sql
Oracle database 12c architecture
Downloading and installing oracle database 12c in details
Overview of plsql
Declaring plsql variables
Writing executable statements
Interacting with oracle db server
Writing control structure
Working with composite data types
Using explicit cursors
Handling exceptions
Creating procedures
Creating functions
Creating packages
Working with packages
Using oracle-supplied packages in application development
Using dynamic sql
Design consideration for plsql code
Creating triggers
Creating compound, ddl, and event database triggers
Using the plsql compiler
Managing plsql code
Managing dependencies
Show more
Show less

Syllabus

Course Setup

Course Agenda

Course Setup Notes / 4 Options

Option 2- creating the HR Schema

Read more

Chapter 2 Quiz

Chapter 3 Quiz

Chapter 4 Quiz

Chapter 5 Quiz

Chapter 6 Quiz

Chapter 7 Quiz

Chapter 8 Quiz

Chapter 9 Quiz

Chapter 10 Quiz

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers the complete set of Oracle University's track for the certification exam 1Z0-144 : Program with PL/SQL

Helps students to prepare fully for the Oracle certification exam, maximizing their chances of success

Includes a wide range of exercises and examples to strengthen the students understanding of the concepts

Provides all the necessary resources for the course, including presentations and SQL scripts, eliminating the need for students to waste time searching for additional materials

May require students to have some prior experience with PL/SQL or related technologies to fully benefit from the course

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

Comprehensive oracle pl/sql 1z0-149 exam prep

According to learners, this course is a solid foundation and highly recommended for those preparing for the Oracle 1Z0-149 PL/SQL exam. Many students reported successfully passing the exam after completing the material. The course provides a comprehensive coverage of the syllabus with abundant exercises and practical examples. Reviewers found the lectures clear and well-structured. Some found the initial database setup process challenging, but overall, it's considered an excellent resource for mastering PL/SQL and achieving certification goals. The provided scripts and materials are highlighted as particularly useful.

Scripts and presentations are valuable resources.

"Having all the SQL scripts provided for every example is a huge time saver and great for practice."

"The attached presentations are a good reference point."

"The supplemental files make it easy to follow along and replicate the exercises."

"I liked that the scripts were available for download."

Content is presented clearly and logically.

"The structure of the course is very logical, moving from basics to more complex topics smoothly."

"Explanations are clear and easy to follow, even for complex subjects."

"The instructor presents the material in a very understandable way."

"I found the course outline and flow very helpful."

Many exercises and examples are included.

"The course is packed with exercises and examples which is crucial for understanding PL/SQL concepts."

"I really appreciate the huge amount of exercises provided. It helps solidify the learning."

"Lots of practical examples that make the concepts easy to grasp."

"The exercises are really good for practicing what you learn."

Course closely follows the 1Z0-149 exam syllabus.

"This course covers the exam topics in a very comprehensive manner. It really helped me pass the 1Z0-149 exam."

"Following this course, I passed the Oracle 1Z0-149 exam successfully. Content matches exam very well."

"Great preparation for the Oracle 1Z0-149 exam. The material is well-organized and covers all necessary areas."

"I found the course focused exactly on what was needed for the 1Z0-149 certification."

Initial database setup can be difficult.

"Setting up the Oracle database environment was the hardest part for me. Needed external help."

"The initial setup section could be clearer, especially for beginners not familiar with database installation."

"Had some issues getting the HR schema configured correctly following the instructions."

"It took me quite some time to get the necessary software installed and working."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Oracle PL/SQL is My Game: EXAM 1Z0-149 with these activities:

Refresh PL/SQL programming skills

Show steps

Warm up and prepare for this course's fast-paced delivery by refreshing your mind on the syntax, structure, and fundamentals of PL/SQL programming.

Browse courses on PL/SQL

Show steps

Review the basics of PL/SQL, such as data types, variables, and control structures.
Write some simple PL/SQL programs to practice your skills.
Take a practice quiz or two to test your understanding.

Develop a collection of PL/SQL resources

Show steps

Increase your knowledge of the PL/SQL ecosystem by collecting and reviewing a variety of resources, such as tutorials, articles, and documentation.

Browse courses on PL/SQL

Show steps

Start with a list of resources you already know and use.
Search for additional resources online.
Organize your resources into a central location, such as a folder or a bookmark list.

Explore PL/SQL tutorials and documentation

Show steps

Enhance your understanding and expand your knowledge base of PL/SQL by exploring a variety of tutorials and documentation resources.

Browse courses on PL/SQL

Show steps

Identify reputable sources for PL/SQL tutorials and documentation, such as the Oracle website and reputable online platforms.
Select a topic or area you want to learn more about.
Follow the tutorials, read the documentation, and try out the examples.
Take notes and revisit the resources as needed to reinforce your learning.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice writing PL/SQL code

Show steps

Improve your understanding of PL/SQL syntax and semantics and reinforce your coding skills by regularly practicing writing PL/SQL code.

Browse courses on PL/SQL

Show steps

Find a set of practice exercises or coding challenges online.
Work through the exercises, writing and testing your own PL/SQL code.
Review your solutions and make corrections as needed.

Attend a PL/SQL workshop

Show steps

Accelerate your growth and refine your expertise by attending a PL/SQL workshop for in-depth guidance, practical exercises, and networking opportunities.

Browse courses on PL/SQL

Show steps

Research and identify a reputable PL/SQL workshop that aligns with your learning goals.
Register for the workshop and make necessary arrangements for attendance.
Attend the workshop, actively participate in activities, and engage with experts and peers.

Develop a PL/SQL project or application

Show steps

Demonstrate your proficiency in PL/SQL by building a project or application that showcases your skills and understanding of the technology.

Browse courses on PL/SQL

Show steps

Identify a problem or opportunity that can be addressed with a PL/SQL solution.
Design and develop a PL/SQL program or application to address the identified problem or opportunity.
Test and refine your solution to ensure it meets the desired requirements and functions as expected.
Document your project or application, including a description of the problem it solves, the approach you took, and the results you achieved.

Provide mentorship or support to other PL/SQL learners

Show steps

Share your knowledge, refine your understanding, and contribute to the community by volunteering to mentor other PL/SQL learners.

Browse courses on PL/SQL

Show steps

Identify opportunities to volunteer as a mentor through online forums, social media groups, or local meetups.
Provide guidance, feedback, and support to mentees based on your expertise and experience in PL/SQL.

Career center

Learners who complete Oracle PL/SQL is My Game: EXAM 1Z0-149 will develop knowledge and skills that may be useful to these careers:

System Analyst

`System Analyst`s analyze and design computer systems. They work with stakeholders to define system requirements, design system architectures, and implement and maintain system installations. This course may be useful for aspiring System Analysts as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust computer systems. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality computer systems.

See salaries and explore the career path for System Analyst

Software Developer

`Software Developer`s design, develop, and maintain software applications. They work with stakeholders to define software requirements, design software architectures, and implement and test software code. This course may be useful for aspiring Software Developers as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust software applications. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality software applications.

See salaries and explore the career path for Software Developer

Data Engineer

`Data Engineer`s build and maintain data pipelines. They work with stakeholders to define data requirements, design data pipelines, and implement and maintain data pipelines. This course may be useful for aspiring Data Engineers as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust data pipelines. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality data pipelines.

See salaries and explore the career path for Data Engineer

Database Developer

`Database Developer`s design and develop database systems. They work with stakeholders to define data requirements, design database schemas, and implement and maintain database systems. This course may be useful for aspiring Database Developers as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust database systems. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality database systems.

See salaries and explore the career path for Database Developer

Database Administrator

`Database Administrator`s manage and maintain database systems. They work with stakeholders to ensure that databases are available, reliable, and secure. This course may be useful for aspiring Database Administrators as it provides a foundation in Oracle PL/SQL, a valuable skill for managing and maintaining Oracle databases. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining robust database systems.

See salaries and explore the career path for Database Administrator

Software Engineer

`Software Engineer`s design, develop, and maintain software systems. They work with stakeholders to define software requirements, design software architectures, and implement and test software code. This course may be useful for aspiring Software Engineers as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust software systems. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality software.

See salaries and explore the career path for Software Engineer

Data Scientist

`Data Scientist`s use scientific methods to analyze data and develop predictive models. They work with stakeholders to identify business problems, develop data science models, and implement and evaluate data science solutions. This course may be useful for aspiring Data Scientists as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust data science pipelines. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality data science pipelines.

See salaries and explore the career path for Data Scientist

Machine Learning Engineer

`Machine Learning Engineer`s develop and maintain machine learning models. They work with stakeholders to identify business problems, develop machine learning models, and implement and evaluate machine learning solutions. This course may be useful for aspiring Machine Learning Engineers as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust machine learning pipelines. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality machine learning pipelines.

See salaries and explore the career path for Machine Learning Engineer

Data Architect

`Data Architect`s design and manage data architectures. They work with stakeholders to define data requirements, develop data models, and implement and maintain data architectures. This course may be useful for aspiring Data Architects as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust data architectures. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality data architectures.

See salaries and explore the career path for Data Architect

Cloud Architect

`Cloud Architect`s design and manage cloud computing solutions. They work with stakeholders to define cloud computing requirements, develop cloud computing architectures, and implement and maintain cloud computing solutions. This course may be useful for aspiring Cloud Architects as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust cloud computing solutions. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality cloud computing solutions.

See salaries and explore the career path for Cloud Architect

Enterprise Architect

`Enterprise Architect`s design and manage enterprise architectures. They work with stakeholders to define enterprise architecture requirements, develop enterprise architecture models, and implement and maintain enterprise architectures. This course may be useful for aspiring Enterprise Architects as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust enterprise architectures. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality enterprise architectures.

See salaries and explore the career path for Enterprise Architect

Information Security Analyst

`Information Security Analyst`s analyze and protect information systems. They work with stakeholders to identify security risks, develop security policies, and implement and maintain security controls. This course may be useful for aspiring Information Security Analysts as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust security systems. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality security systems.

See salaries and explore the career path for Information Security Analyst

Data Analyst

`Data Analyst`s analyze and interpret data to identify trends and patterns. They work with stakeholders to develop and implement data-driven solutions to business problems. This course may be useful for aspiring Data Analysts as it provides a foundation in Oracle PL/SQL, a valuable skill for working with large datasets. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining robust data analysis pipelines.

See salaries and explore the career path for Data Analyst

Business Analyst

`Business Analyst`s analyze business needs and develop solutions to improve business processes. They work with stakeholders to define business requirements, develop business process models, and implement and evaluate business solutions. This course may be useful for aspiring Business Analysts as it provides a foundation in Oracle PL/SQL, a valuable skill for developing and maintaining robust business intelligence systems. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining high-quality business intelligence systems.

See salaries and explore the career path for Business Analyst

Project Manager

`Project Manager`s help plan, organize, and execute projects. They work with stakeholders to define project goals, develop project plans, and manage project budgets and timelines. This course may be useful for aspiring Project Managers as it provides a foundation in Oracle PL/SQL, a valuable skill for managing complex IT projects. The course covers topics such as data manipulation, control structures, and error handling, which are essential for developing and maintaining robust software systems.

See salaries and explore the career path for Project Manager

Reading list

We've selected five books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Oracle PL/SQL is My Game: EXAM 1Z0-149.

Cover image

Cover image

Oracle PL/SQL Language Pocket Reference

Save

Provides a comprehensive overview of Oracle PL/SQL, covering all the essential concepts and techniques. It valuable resource for both beginners and experienced PL/SQL developers alike. This commonly used textbook provides both depth and breadth to the course with a focus on programming concepts.

Oracle PL/SQL Language Pocket Reference: A Guide to...

Oracle PL/SQL Language Pocket Reference

Oracle PL/SQL Language Pocket Reference: A guide to...

Oracle PL/SQL Language Pocket Reference

Oracle PL/SQL Language Pocket Reference: A Guide to...

Cover image

Cover image

Save

Comprehensive guide to PL/SQL development. It covers all the essential topics, from basic syntax to advanced techniques. This book valuable resource for developers who want to learn more about PL/SQL.

Oracle8i: The Complete Reference (Book/CD-ROM...

Cover image

Cover image

Oracle PL/SQL by Example

Save

Comprehensive handbook on PL/SQL. It covers all the essential topics, from basic syntax to advanced techniques. This book valuable resource for both beginners and experienced PL/SQL developers alike.

Oracle PL/SQL by Example (The Oracle Press Database...

Oracle PL/SQL by Example

Oracle PL/SQL by Example (4th Edition)

Oracle PL/SQL by Example

Oracle PL/SQL by Example (Prentice Hall...

Cover image

Cover image

Troubleshooting Oracle Performance

Save

Provides a comprehensive tutorial on PL/SQL. It covers all the essential topics, from basic syntax to advanced techniques. This book valuable resource for both beginners and experienced PL/SQL developers alike.

Troubleshooting Oracle Performance

Troubleshooting Oracle Performance by Christian...

Mass Market Paperback

Troubleshooting Oracle Performance

Cover image

Cover image

Oracle PL/SQL Programming

Save

Provides a collection of recipes that demonstrate how to use PL/SQL to solve common programming problems. This book valuable resource for experienced PL/SQL developers who want to learn more about the language.

Oracle PL/SQL Programming: Covers Versions Through...

Oracle PL/SQL Programming: Covers Versions Through...

Oracle PL/SQL Programming

Oracle PL/SQL Programming

Share

Help others find this course page by sharing it with your friends and followers:

Copy Link

Similar courses

Here are nine courses similar to Oracle PL/SQL is My Game: EXAM 1Z0-149.

Building Your Own Database Agent

Building Your Own Database Agent

Data Analysis with SQL: Inform a Business Decision

Data Analysis with SQL: Inform a Business Decision

The Structured Query Language (SQL)

The Structured Query Language (SQL)

Analyze Data to Answer Questions

Analyze Data to Answer Questions

Manipulating Data with SQL

Manipulating Data with SQL

Introduction to SQL Window Functions

Introduction to SQL Window Functions

Advanced Topics and Future Trends in Database Technologies

Advanced Topics and Future Trends in Database Technologies

Cloud Spanner - Defining Schemas and Understanding Query Plans

Cloud Spanner - Defining Schemas and Understanding Query...

Extract, Transform, and Load Data

Extract, Transform, and Load Data

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader

Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections

30-day 100% money-back guarantee on course purchases

Lifetime access on web, mobile, and offline

Certificate of completion included with purchase

Direct instructor Q&A and active student community

OpenCourser Verified Partner Policy details last reviewed: 2026-10-22

Rating

4.5

Effort

22 total hours

Via

Udemy

Instructor

Khaled Alkhudari

Language

English

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers the complete set of Oracle University's track for the certification exam 1Z0-144 : Program with PL/SQL

Helps students to prepare fully for the Oracle certification exam, maximizing their chances of success

Includes a wide range of exercises and examples to strengthen the students understanding of the concepts

Provides all the necessary resources for the course, including presentations and SQL scripts, eliminating the need for students to waste time searching for additional materials

May require students to have some prior experience with PL/SQL or related technologies to fully benefit from the course

Share this

Share to help others discover this course.

Link

Begin learning today

Enroll now to gain full access to Oracle PL/SQL is My Game.

Enroll now Enroll in this course

Save for later

Add this course to your list. Find it anytime.

Save

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser