Course details
Overview:
This course introduces students to PL/SQL and explains the benefits of this programming language. Participants learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. The course also imparts how to create anonymous PL/SQL blocks, stored procedures, and functions.
Participants learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts.
Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are available as optional tools. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features.
Learn To:Conditionally control code flow (loops, control structures) Use Explicit Cursors Handle runtime errors Describe stored procedures and functions Work with Composite Data Types Declare PL/SQL Variables
Objectives:
- Handle runtime errors
- Describe stored procedures and functions
- Use cursors to process rows
- Design PL/SQL anonymous block that execute efficiently
- Describe the features and syntax of PL/SQL
- Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Course Location
About Global Knowledge Egypt
Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.
See all Global Knowledge Egypt coursesSQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Implementing an Advanced Server Infrastructure John AcademyAED 246
AED 5,289Duration: Upto 14 Hours - SQL Programming Complete Bundle NextGen LearningAED 199Duration: Upto 20 Hours