Introduction to Oracle PL/SQL

This course will teach you the basics of using PL/SQL and how to create stored procedures and functions.

This course was created as a coaching program, so there are several longer videos rather than many shorter videos.

You'll learn:

  • What PL/SQL is and how it can fit into your development.
  • How to create and run a simple PL/SQL program
  • How to enhance your PL/SQL code using variables, constants, conditional statements, loops, arrays, packages, collections, cursors, and more

Get Access to All Courses Now

Access this course and all other courses (and more) in Database Star Academy instantly:

Course Topics:

Lesson 1

  • What is PL/SQL?
  • Syntax of basic code
  • How to Run Your First PL/SQL Code
  • Variables: What They Are and How to Use Them
  • Blocks and Comments

Lesson 2

  • Constants
  • Using SQL Within PL/SQL
  • Conditional Statements (IF, THEN, ELSE)

Lesson 3

  • Looping
  • Variable Scope
  • Arrays

Lesson 4

  • Stored Procedures
  • Functions
  • Exceptions

Lesson 5

  • Packages
  • Collections
  • Cursors

© 2019 Database Star | Privacy | Terms of Service