Course details
Introduction
This five-day instructor-led course consists of PL/SQL Fundamentals (2 days) and PL/SQL Program Units (3 days) and introduces participants to the fundamentals of PL/SQL. In this course participants learn about PL/SQL syntax, blocks, programming constructs and about the advantages that PL/SQL provides. This course provides the essential skills that allow developers to write and execute PL/SQL program units efficiently, develop reusable program units such as procedures and functions, package constructs and database triggers. Participants will also learn how to use a subset of Oracle-supplied packages, identify various techniques that impact PL/SQL design considerations, and how to manage PL/SQL code effectively.
This course, applicable to Oracle Database 10g and 11g users, will teach participants how to make use of Oracle SQL Developer as the main tool (with SQLPlus optionally available) for hands-on practice to reinforce the fundamental concepts and new skills acquired.
Course Content
PL/SQL FUNDAMENTALS
- Lesson 1: Introduction to PL/SQL
- Lesson 2: Declaring PL/SQL Variables
- Lesson 3: Writing Executable Statements
- Lesson 4: Interacting with Oracle Database Server: SQL Statements in PL/SQL Programs
- Lesson 5: Writing Control Structures
- Lesson 6: Working with Composite Data Types
- Lesson 7: Using Explicit Cursors
- Lesson 8: Handling Exceptions
- Lesson 9: Introducing Stored Procedures and Functions
DEVELOP PL/SQL PROGRAM UNITS
- Lesson 1: Creating Procedures
- Lesson 2: Creating Functions and Debugging Subprograms
- Lesson 3: Creating Packages
- Lesson 4: Working with Packages
- Lesson 5: Using Oracle-Supplied Packages in Application Development
- Lesson 6: Using Dynamic SQL
- Lesson 7: Design Considerations for PL/SQL Code
- Lesson 8: Creating Triggers
- Lesson 9: Creating Compound, DDL, and Event Database Triggers
- Lesson 10: Using the PL/SQL Compiler
- Lesson 11: Managing PL/SQL Code
- Lesson 12: Managing Dependencies
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Oracle Forms (Video-Based) UplatzZAR 230Duration: Upto 10 Hours
- ZAR 230Duration: Upto 3 Hours
