Oracle 10g: SQL language

The course deals with concepts of relational and object-relational databases and powerful programming language Oracle SQL.
Code: DB-006
Duration: 40 hours

Description

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

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.

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.


Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €600
Krakow €600
Wroclaw €600

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Sign up

First Name*
Last Name*
Company
Email*
Preferred Location
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.