We may earn an affiliate commission when you visit our partners.
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….
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….
Register for this course and see more details by visiting:
OpenCourser.com/course/rk0y5b/oracle
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
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
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
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.
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
`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.
Software Developer
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.
Data Engineer
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.
Database Developer
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.
Database Administrator
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.
Software Engineer
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.
Data Scientist
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.
Machine Learning Engineer
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.
Data Architect
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.
Cloud 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.
Enterprise 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.
Information Security Analyst
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.
Data 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.
Business 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.
Project Manager
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.
For more career information including salaries, visit:
OpenCourser.com/course/rk0y5b/oracle
Reading list
We've selected eight 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.
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.
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.
Comprehensive reference guide to PL/SQL. It covers all the essential topics, from basic syntax to advanced techniques. This book valuable resource for experienced PL/SQL developers who need a quick reference.
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.
Quick reference guide to the PL/SQL language. It covers all the essential syntax and provides plenty of examples. This book valuable resource for both beginners and experienced PL/SQL developers alike.
Save
Fun and easy way to learn PL/SQL. It uses a humorous approach to explain concepts and provides plenty of code examples. This book great resource for beginners who want to learn more about PL/SQL in a fun and engaging way.
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.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/rk0y5b/oracle
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
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