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

+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 SQL: DML and DDL

Посмотреть расписание этого курса
  • Код курса: 61132
  • Длительность: 8 д.
  • Цена: 4 480 р.
Записаться

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

Course Overview
 
The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to create the external tables.

Learn To

  • Identify the data structures in an Oracle server.
  • Identify the rules for naming tables in a database.
  • Identify the DML and transaction control statements.
  • Insert rows in a table by using the INSERT statement.
  • Add a column to a table in an Oracle database.
  • Change the table structure by modifying the characteristics of an existing column.
  • Identify the features of an Oracle sequence.
  • Create a sequence by using the CREATE SEQUENCE statement.
  • Identify the properties of views.
  • Match the clauses of the CREATE VIEW statement with their functions.
  • Create a public synonym by using the CREATE PUBLIC SYNONYM statement.
  • Remove a synonym by using the DROP PUBLIC SYNONYM statement.
  • Identify the features of Oracle database security.
  • Create users in an Oracle database.
  • Match the types of multitable INSERT statements with their uses.
  • Insert rows into multiple tables by using the INSERT INTO statement unconditionally.
Audience The intended audience for this course are Database Administrators. Required prerequisite knowledge includes Oracle9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131.
Записаться на курс: Oracle9i SQL: DML and DDL

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



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

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

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

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