Introduction to Oracle SQL and PL/SQL

Oracle Training Series

TTORSQLPL1

Introductory

1 Day

Course Overview

An introduction to the design and creation of relational databases. Topics include storing, retrieving, updating and displaying data using Structured Query Language (SQL) integrated into Stored Procedures, Functions, Packages and Triggers (PL/SQL Programming)

Course Objectives

This course is designed to teach students how to create programmed solutions using the PL/SQL procedural language.

Course Prerequisites

As each student is required to have a working knowledge of the programming process and understanding of the functional constructs in programming, the focus of this course is on database problems and potential solutions.  

Course Agenda

SQL Commands

                                        SELECT INTO

                                        DML – SELECT, INSERT, UPDATE, DELETE

                                        DDL – CREATE, DROP, GRANT, ALTER

                                        Transaction – COMMIT, ROLLBACK, SAVEPOINT

                        PL/SQL Concepts and Constructs

                                        Block Structure

                                        DECLARE, BEGIN, EXCEPTION, END                           

                                        Procedures, Functions, Packages and Triggers

                                        Input and Output Parameters and Return values

                        PL/SQL Code Implementations

                                                           Variables and Constants

                                        Attributes (Char, Varchar2, Number, Binary, Integer, Date)

IF – THEN – ELSIF – ELSE

                                        LOOP Forms

                                                            Simple (EXIT WHEN)

                                                            FOR LOOP

                                                            WHILE LOOP

                                        CASE

                                        CURSOR

                                        TYPES -  %TYPE, &ROWTYPE, RECORD

                                        DBMS_OUTPUT.PUT_LINE

Course Materials

Our course materials include more than a simple slideshow presentation handout. Each student will receive a comprehensive course Student Guide, complete with detailed course notes, code samples, software tutorials, diagrams and related reference materials and links. 

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

New Year, New Savings! 20223FOR1!
Enroll before Feb 15 for any THREE public classes in 2022 for the price of ONE! 

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More