Coursera Bets $100 Million That Andrew Ng Can Do What Coursera Can’t

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

PL/SQL

via SWAYAM Plus

Go to class Write review
Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More → Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates

PL/SQL (Procedural Language/Structured Query Language) is an extension of SQL used for developing powerful and robust database applications. In this course, you will learn the basics of PL/SQL, including data types, control structures, functions, procedures, and packages. You will also learn how to interact with oracle databases using PL/SQL. The course covers subprograms, functions, and procedures, as well as cursors, collections, triggers, and packages. By the end of the course, you will have a solid understanding of PL/SQL programming and be prepared to develop robust database applications using PL/SQL and take the oracle PL/SQL developer certified associate exam.

Intended audience

PL/SQL Developer, Database Developer, Database Administrator (DBA)

Prerequisites

  • Prior learning experience in DBMS, SQL
  • Basic knowledge about PL/SQL language basics, strong foundation in SQL programming and relational database concepts

Assessment & certification

  • Assessment fee: Included — no extra fee
  • Assessment mode: Online
  • Assessment type: MCQ
  • Assessment provider: GUVI
  • Certificate provider: PL/SQL Developer, Database Developer, Database Administrator (DBA)

Syllabus

  • Week 1: Understanding of PL/SQL language, its syntax, and its structure, and how it is used to develop powerful and robust database applications.
  • Week 2: Developing PL/SQL programs, including subprograms, functions, procedures, cursors, collections, triggers, and packages.
  • Week 3: Interacting with an Oracle database using PL/SQL, including retrieving data, manipulating data, and creating database objects.
  • Week 4: Using control structures like loops and conditional statements to control the flow of execution in their PL/SQL code.
  • Week 5: Debugging PL/SQL code and handle exceptions in their programs.
  • Week 6: Best practices for PL/SQL development, including code organization, maintainability, and performance optimization.
  • Week 7: Prepration to take the Oracle PL/SQL Developer Certified Associate exam after completing this course.

Taught by

Guvi

Reviews

Start your review of PL/SQL

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.