Oracle 10g: SQL language
Продолжительность
40
часы
Місцезнаходження
Онлайн
Мова
Англійська
Код
DB-006
Тренінг для 7-8 чи більше людей?
Налаштуйте тренінги
для ваших конкретних потреб
опис
The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.
Після проходження курсу видається сертифікат
на бланку Luxoft Training
на бланку Luxoft Training
Цілі
After the training the attendees will be able to:
- manipulate rows of relational tables;
- create, modify and delete DB objects;
- manage transactions in DB;
- work with data dictionary;
- control data access;
- use complex methods of writing queries.
Цільова аудиторія
- Database administrators;
- System administrators;
- Application developers;
- Testers.
передумови
Knowledge of algorithmization principles.
Дорожня карта
- Basic concepts of relational and object-relational databases.
- Fetching, adding, updating and deleting data.
- Using SQL functions to generate necessary reports.
- Transactions control.
- Creating DB objects and working with them.
- Working with data dictionary.
- Data access control.
- Schema object management.
- Manipulating large data sets.
- Generating reports using various data aggregation.
- Managing data in different time zones.
- Using complex sub-queries and hierarchical queries.
- Regular expressions support.