Oracle 10g: SQL language
Durată
40
ore
Locație
Pe net
Limba
Engleză
Cod
DB-006
Training pentru 7-8 sau mai multe persoane?
Personalizați antrenamentele
pentru nevoile dumneavoastră specifice
Descriere
The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training
în formularul Luxoft Training
Obiective
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.
Public țintă
- Database administrators;
- System administrators;
- Application developers;
- Testers.
Cerințe preliminare
Knowledge of algorithmization principles.
Foaia de parcurs
- 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.