When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Software Development
pluralsight logo

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

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.

     0 |
  • Reviews ( 0 )
Free
Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL

Related Courses

This Course Includes

  • iconpluralsight
  • icon0 (0 reviews )
  • icon1 hour 18 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcore courses
  • iconpluralsight

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

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 You Will Learn?

  • Course Overview : 2mins.
  • PL/SQL Program Components : 27mins.
  • DML and PL/SQL Blocks : 38mins.
  • INTO Clause and Returned Values : 10mins.