Oracle Database 12c: Program with PL/SQL (CO-80186) Torque IT
Price: AED 5,039

    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
    Updated on 05 September, 2016

    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
    Are you from Torque IT ? Claim your course!
    Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

    Is this the right course for you?

    Didn't find what you were looking for ?

    or