Oracle 10g: SQL language
Duration
40
hours
Location
Online
Language
English
Code
DB-006
Training for 7-8 or more people?
Customize trainings
for your specific needs
Description
The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
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.
Target Audience
- Database administrators;
- System administrators;
- Application developers;
- Testers.
Prerequisites
Knowledge of algorithmization principles.
Roadmap
- 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.