Oracle PL/SQL is My Game: EXAM 1Z0-149 from 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

Option 3- Part 1 : Oracle Database 12c Architecture

Option 3- Part 2 : Downloading Oracle DB 12c

Option 3- Part 3 : Installing Oracle DB 12c

Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer

Option 3- Part 5: Unlock HR Account Part 1

Option 3- Part 6 : Unlock HR Account Part 2

Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c

Option 4- Installing Oracle 11g express Edition + Unlock HR

About Oracle 18c express edition

HR Schema in this Course

Navigate HR schema

Overview of PL/SQL

What is PL/SQL? What is the benefits?

PL/SQL Block Structure & Types of Blocks

Writing simple Anonymous block

Using SQL*plus to run anonyms block

Creating Script and run it

Chapter 2 Quiz

Declaring PLSQL Variables

About Variables and the syntax

Defining Variables exercise

Guidelines for declaring & initializing variables

Delimiters in string literals (the q' Notation)

Types of variables and data types 1

Types of variables and data types 2

Data Types exercise

Define Variables Using %TYPE

Understating the SELECT statement in PL/SQL

Bind Variables

Chapter 3 Quiz

Writing executable statements

Inside PL/SQL Block

Inside PL/SQL Block (exercise)

Nested Blocks

SQL & PL/SQL programing Guidelines

Chapter 4 Quiz

Interacting with Oracle DB Server

SELECT statement & DML in PL/SQL

SELECT statement & DML in PL/SQL exercise

Understanding Implicit SQL cursor/ SQL Attributes

Implicit SQL cursor exercise

Chapter 5 Quiz

Writing Control structure

IF Statement Part 1

IF Statement Part 2

Handling nulls in IF statement

CASE expression & CASE Statement

Basic Loop

While Loop

FOR Loop

Nested Loops

Nested Loops and Labels

Continue Statement

Chapter 6 Quiz

Working with Composite Data Types

PL/SQL Records: Programmer method part 1

PL/SQL Records: Programmer method part 2

PL/SQL Records: %ROWTYPE method

Nested PL/SQL Records

INDEX BY tables (Associative arrays)

INDEX BY tables Methods

INDEX BY tables of Records

nested table

Varray

Chapter 7 Quiz

Using explicit cursors

Understanding Explicit Cursor

Explicit Cursor exercise

Explicit Cursor Attributes

FOR LOOP Cursor

Cursor with Parameters

FOR UPDATE Clause & CURRENT OF Clause

Chapter 8 Quiz

Handling Exceptions

Understanding Exceptions

Predefined Oracle Server Error Exception

Common mistakes when dealing with exceptions

Non-Predefined Oracle Server Error Exception

User-Defined Error Exception

Group Functions and exceptions

Many blocks and many exceptions

Chapter 9 Quiz

Creating Procedure

Understanding Procedures and subprograms

Understanding Procedures Syntax

Creating Procedure (IN parameter)

Creating Procedure (OUT parameter)

Creating Procedure (IN OUT parameter)

Comparing the Paramter Modes

Available notations for passing parameters

Using the default option for Parameters

Exception handling in multiple blocks

Using Boolean and PL/SQL records as parameters

Chapter 10 Quiz

Creating Functions

Understanding user-defined functions

Good to know

Know what's good

, what to watch for

, 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

Reviews summary

Informative pl/sql course

Students say Oracle PL/SQL is My Game: EXAM 1Z0-149 is an informative course that provides lots of information and a smooth learning experience toward their exam preparation.

Course includes engaging assignments.

"The quizzes and assignments are engaging."

Course is well structured and easy to follow.

"Course is well structured and easy to follow."

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

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

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

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

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

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

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

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

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 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

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

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

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

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