Расписание курсов

+7 (495) 913-75-75 доб.221

+7 (495) 668-08-42

+7 (812) 441-33-15

+7 (901) 374-07-97

+7 (383) 263-31-70

+7 (861) 944-79-98

+7 (391) 272-07-31



Oracle9i PL/SQL: Basics

Посмотреть расписание этого курса

  • Код курса: 61133
  • Длительность: 8 д.
  • Цена: 4 480 р.
Записаться Добавить в корзину

Описание курса

Course Overview
The Oracle9i PL/SQL: Basics course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous easy-to-understand examples ensure that the concepts are amply illustrated.

Learn To

  • Identify the features of PL/SQL.
  • Identify the benefits of PL/SQL.
  • Select the actions by which a PL/SQL engine processes a block of code.
  • Identify the functions of PL/SQL variables.
  • Identify the guidelines for declaring PL/SQL variables.
  • Match the PL/SQL datatypes with their descriptions.
  • Retrieve data from a table by using the SELECT statement.
  • Identify the conditions in which various SELECT exceptions are raised.
  • Write the code to add rows to a table by using the INSERT statement.
  • Write PL/SQL code using the IF-THEN-ELSE statement.
  • Write PL/SQL code using the IF-THEN-ELSIF statement.
  • Write PL/SQL code using the CASE expression.
  • Declare a PL/SQL record by using the RECORD datatype.
  • Reference a PL/SQL record by using the dot notation.
  • Declare PL/SQL records with %ROWTYPE.
  • Identify the declaration methods of cursors, both implicit and explicit.
  • Sequence the steps for controlling explicit cursors.
  • Write the code to declare a cursor by using the CURSOR statement.
  • Match the types of exceptions with their properties.
  • Match some common predefined Oracle server exceptions with their descriptions.
  • Identify the guidelines to trap exceptions.


The intended audience for this course are Application Developers, Database Administrators, System Analysts, and Technical Support Professionals. Required prerequisites are Oracle SQL and SQL*Plus and Oracle Basic PL/SQL Suggested prerequisites are Oracle9i SQL and SQL*Plus: Basic SELECT Statements (61130) Oracle9i SQL and SQL*Plus: Data Retrieval Techniques (61131) and Oracle9i SQL and SQL*Plus: DML and DDL (61132).

Записаться на курс: Oracle9i PL/SQL: Basics

Начало курса:

Отправьте другу или начальнику ссылку на почту
Заявка на обучение

Заявка на обучение

Записаться на курс:

Выберите дату начала курса: