Oracle 10g: SQL language

The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.

40 hours
English
Online

duration: 40 hours
location: Online
Language: English
Code: DB-006
price: € 600 *

Available sessions

To be determined

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.

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.