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

+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: Basic SELECT Statements

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

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

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

Course Overview
 
This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database.

Learn To

  • Identify the components of the relational model.
  • Match the structural elements of a relational database table with their descriptions.
  • Sequence the phases of the system development life cycle.
  • Match the types of SQL statements with their descriptions.
  • Match the capabilities of SQL SELECT statements with their functions.
  • Identify the guidelines for constructing basic SQL SELECT statement.
  • Write a query that restricts rows returned by using the WHERE clause.
  • Write a WHERE clause to accommodate different datatypes.
  • Use comparison operators with the WHERE clause.
  • Identify the different categories of datatypes.
  • Match the character datatypes with their descriptions.
  • Identify the features of the NUMBER datatype.

Audience

The target audience for this course includes database administrators and application developers.

This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007.

Рекомендуемая схема обучения


Oracle9i SQL: Basic SELECT Statementsтекущий курс

Fatal error: Call to a member function GetProperties() on boolean in /home/u95411/farecast.ru/www/bitrix/php_interface/init.php on line 26