Network Technology

National Insurance Academy
In Pune

Price on request
You can also call the Study Centre
20272... More
Compare this course with other similar courses
See all

Important information

  • Training
  • Pune
  • Duration:
    1 Week
Description

Important information
Venues

Where and when

Starts Location
On request
Pune
25, Baner Road, Balewadi, 411045, Maharashtra, India
See map

Course programme

PL/SQL programming is an intense hands-on course that is designed to give the participant maximum exposure to Oracle PL/SQL. The participant learns by doing, and this class has dozens of in-class exercises and the participant will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques.

The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views. The PL/SQL section begins with simple concepts and the participant gradually masters PL/SQL through increasingly challenging classroom exercises.

This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.
Learning Objectives

By the end of this course the participant will be able to write advanced PL/SQL code blocks, and will be able to use advanced features such as ref cursors and bulk fetches. The participant will also become familiar with the internals of Oracle PL/SQL and will be able to compile PL/SQL for super-fast performance.
Basics of PL/SQL he topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views. The PL/SQL section begins with simple concepts and the participant gradually masters PL/SQL through increasingly challenging classroom exercises.

This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.


Compare this course with other similar courses
See all