МенюКонтакты
Обучение
Москва

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

+7 (495) 668-08-42

Санкт-Петербург

+7 (812) 441-33-15

+7 (901) 374-07-97

Почта

edu@fors.ru

Oracle Database: SQL Workshop I

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

  • Код курса: SQLI
  • Длительность: 3 д.
  • Цена: 67 050 р.
Записаться

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

Аннотация:

This Oracle Database 11g: SQL Fundamentals I - Self-Study Coursec is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Слушатели изучат:

  • Develop essential SQL skills that enable developers to write queries against single and multiple tables.
  • Manipulate data in tables.
  • Create database objects.
  • Use single row functions to customize output.
  • Work with group functions to report aggregated data.
  • Use conversion functions and conditional expressions.
  • Manipulate queries to return required data.
  • Perform calculations on data.
  • Administer database objects.

Преимущества для Вас:

By enrolling in one of Oracle University's Self-Study Courses, you can download the course material and learn at your own pace. Build a foundation of SQL knowledge on your own time, from anywhere that's convenient for you.

Темы курса:

  • Oracle Database 11g: Using SQL to Query Your Database
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

Цели курса:

  • To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting
  • To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return value
  • To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE
  • To recognize the steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries
Записаться на курс: Oracle Database: SQL Workshop I

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


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

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

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

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