Gain hands-on experience with Oracle’s PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle’s procedural language extension to Structured Query Language (SQL).
This course will give you the skills you need to write powerful and flexible programs using that language. You’ll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you’ll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Duration: 3 Months
- Details
- Learn the building blocks and core features of PL/SQL
- Begin building fully functional PL/SQL programs
- Understand procedures, packages, debugging routines, database structures, triggers, and cursor processing
- Learn how to store PL/SQL programs in a database and execute them
- Course Outline
Introduction to PL/SQL
Datatypes and Block Structure
Operators, Expressions, and Datatype Conversions
PL/SQL Functions, IF Statements, and Looping Statements
GOTO Statement, Statement Labels, and Loop Constructs
Oracle’s Built-In Functions
Procedures and Packages
Errors and Exceptions
Types of SQL Statements, Declaring Variables in PL/SQL, and Transaction Management
Using Cursors
Database Triggers, Advanced Cursor Concepts, and Managing PL/SQL Code
Debugging Your Code - Requirements
Prerequisites:
Completion of Cindy Delia’s Introduction to Oracle course (or equivalent experience).
Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac.
Software Requirements:
- PC: Windows XP or later.
- Mac: OS X Snow Leopard 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
- Oracle’s Database Software. The Database Software is available for downloading from Oracle’s website (www.oracle.com). Download the Oracle Database that supports your operating system. This course provides post-installation instruction on Oracle. Installation support will not be provided in the course. Installation support is provided from Oracle’s website.
- Adobe Flash Player. Click here to download the Flash Player.
- Adobe Acrobat Reader. Click here to download the Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Course Fee: USD 120Now available at Afghanistan, Bangladesh, Bhutan, India, Maldives, Nepal, Pakstan and Sri Lanka