Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL from Pluralsight

Companies rely on the backend developers when meeting SLAs with customers. This course will teach you how to proficiently write PL/SQL executable blocks using DML and the INTO clause to hold values returned by PL/SQL for the Oracle database.

Writing high-performing database code is one of the key ingredients to maintain and improve customer satisfaction. In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL, you’ll learn to apply the guidelines and recommendations offered by Oracle in structuring your PL/SQL program and writing maintainable code. First, you’ll explore the lexical units that make up a PL/SQL program. Next, you’ll use Data Manipulation Language (DML) and discover how to select, insert, delete, and update data in an Oracle database. Finally, you’ll learn to use the INTO clause to hold the values returned by a SQL statement. When you finish this course, you’ll have the skills and knowledge to write effective PL/SQL code needed to create a fast-performing backend.

What's inside

Syllabus

Course Overview

PL/SQL Program Components

DML and PL/SQL Blocks

INTO Clause and Returned Values

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops knowledge of an SQL language for storing and managing data

Examines using PL/SQL atomically within an SQL statement

Teaches best practices for writing efficient and maintainable code

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 Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL with these activities:

Review Oracle database concepts

Show steps

This activity will help refresh fundamental knowledge

Browse courses on Oracle Database

Show steps

Review Oracle database concepts
Practice creating and querying Oracle databases

Review PL/SQL syntax

Show steps

This activity will help provide foundational knowledge

Browse courses on PL/SQL

Show steps

Review the PL/SQL syntax
Practice writing simple PL/SQL statements

Follow a tutorial on writing PL/SQL code

Show steps

This activity will help build skills in writing PL/SQL code

Browse courses on PL/SQL

Show steps

Find a tutorial on writing PL/SQL code
Follow the tutorial step-by-step
Practice writing PL/SQL code on your own

Four other activities

Expand to see all activities and additional details

Show all seven activities

Attend a study group to discuss PL/SQL topics

Show steps

This activity will help benefit from the perspectives of others

Browse courses on PL/SQL

Show steps

Find a study group
Attend the study group regularly
Participate in discussions

Practice writing PL/SQL code on LeetCode

Show steps

This activity will help reinforce understanding of PL/SQL concepts

Browse courses on PL/SQL

Show steps

Create a LeetCode account
Find PL/SQL problems on LeetCode
Solve the problems

Create a PL/SQL program to solve a real-world problem

Show steps

This activity will help apply PL/SQL skills to a practical problem

Browse courses on PL/SQL

Show steps

Identify a real-world problem that can be solved using PL/SQL
Design a PL/SQL program to solve the problem
Implement the PL/SQL program
Test the PL/SQL program

Start a project to create a PL/SQL application

Show steps

This activity will help gain experience in developing PL/SQL applications

Browse courses on PL/SQL

Show steps

Choose a project idea
Design the application
Develop the application
Test the application
Deploy the application

Career center

Learners who complete Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL will develop knowledge and skills that may be useful to these careers:

Database Architect

Database Architects design and implement database systems. This course can help you build a foundation for a career as a Database Architect by teaching you how to write efficient PL/SQL code, which is essential for designing and implementing Oracle databases.

See salaries and explore the career path for Database Architect

Database Administrator

Database Administrators are responsible for the installation, configuration, maintenance, and performance of database management systems. This course can help you build a foundation for a career as a Database Administrator by teaching you how to write efficient PL/SQL code, which is essential for managing Oracle databases.

See salaries and explore the career path for Database Administrator

Business Intelligence Analyst

Business Intelligence Analysts use data to help businesses make better decisions. This course can help you build a foundation for a career as a Business Intelligence Analyst by teaching you how to write PL/SQL code to extract and analyze data.

See salaries and explore the career path for Business Intelligence Analyst

Data Analyst

Data Analysts use their knowledge of data and statistical techniques to solve business problems. This course can help you develop the skills you need to be a successful Data Analyst by teaching you how to write PL/SQL code to manipulate and analyze data.

See salaries and explore the career path for Data Analyst

Web Developer

Web Developers design, develop, and maintain websites. This course can help you develop the skills you need to be a successful Web Developer by teaching you how to write efficient PL/SQL code, which is used in a variety of web development frameworks.

See salaries and explore the career path for Web Developer

Network Administrator

Network Administrators are responsible for the planning, implementation, and management of computer networks. This course can help you develop the skills you need to be a successful Network Administrator by teaching you how to write efficient PL/SQL code, which is used in a variety of network management systems.

See salaries and explore the career path for Network Administrator

Data Engineer

Data Engineers design, build, and maintain data pipelines. This course can help you develop the skills you need to be a successful Data Engineer by teaching you how to write efficient PL/SQL code, which is used in a variety of data engineering tools.

See salaries and explore the career path for Data Engineer

Data Scientist

Data Scientists use their knowledge of data, statistics, and machine learning to solve complex business problems. This course can help you develop the skills you need to be a successful Data Scientist by teaching you how to write PL/SQL code to manipulate and analyze data.

See salaries and explore the career path for Data Scientist

IT Manager

IT Managers are responsible for the planning, implementation, and management of information technology systems. This course can help you develop the skills you need to be a successful IT Manager by teaching you how to write efficient PL/SQL code, which is used in a variety of IT systems.

See salaries and explore the career path for IT Manager

Software Developer

Software Developers design, develop, and maintain software applications. This course can help you develop the skills you need to be a successful Software Developer by teaching you how to write efficient PL/SQL code, which is used in a variety of software applications.

See salaries and explore the career path for Software Developer

Systems Analyst

Systems Analysts design, develop, and implement computer systems. This course can help you develop the skills you need to be a successful Systems Analyst by teaching you how to write efficient PL/SQL code, which is used in a variety of computer systems.

See salaries and explore the career path for Systems Analyst

Mobile Developer

Mobile Developers design, develop, and maintain mobile applications. This course can help you develop the skills you need to be a successful Mobile Developer by teaching you how to write efficient PL/SQL code, which is used in a variety of mobile development frameworks.

See salaries and explore the career path for Mobile Developer

Computer Programmer

Computer Programmers design, develop, and maintain computer programs. This course can help you develop the skills you need to be a successful Computer Programmer by teaching you how to write efficient PL/SQL code, which is used in a variety of programming languages.

See salaries and explore the career path for Computer Programmer

Artificial Intelligence Engineer

Artificial Intelligence Engineers design, develop, and maintain artificial intelligence systems. This course may help you develop some of the skills you need to be a successful Artificial Intelligence Engineer by teaching you how to write PL/SQL code, which is used in some artificial intelligence tools.

See salaries and explore the career path for Artificial Intelligence Engineer

Machine Learning Engineer

Machine Learning Engineers design, develop, and maintain machine learning models. This course may help you develop some of the skills you need to be a successful Machine Learning Engineer by teaching you how to write PL/SQL code, which is used in some machine learning tools.

See salaries and explore the career path for Machine Learning Engineer