Поиск
Обучение
Поиск

+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

Почта

edu@fors.ru

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.

Audience

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

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



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

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

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

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