Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

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

via Pluralsight

Overview

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.

Taught by

Eduardo Freitas

Reviews

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.