ORA-SQL1

New Oracle SQL Basics Course

Form of participation
Form of training
Length of training
  • 2 day (2×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

from 
195 000 Ft
+ VAT/person
Please choose the date and form of participation!
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Description

Query, GROUP BY, tables, constraints, views, columns... - one or more of these familiar to you? In this course, we will learn the basics of SQL (a standardised language for querying databases) using the Oracle database software of the same name.

Suggested For

Those who use spreadsheet or database management office software and want to build on their existing knowledge and experience to learn a new tool, SQL (structured query language).

Those who will need to use SQL in their work (e.g. to produce reports) and want to build their knowledge in a practice-oriented way.

The course is designed for people who work with the Oracle database management system (SQL is also an international standard, so most of the knowledge acquired can be used directly in other database management systems).

Outline

  • Selecting columns, conditions on rows, sorting, functions on a table.
  • Set operations, linking tables.
  • Functions on multiple rows, grouping, conditions on a group. Subqueries.
  • Creating new rows, modifying existing rows, deleting rows. Transaction handling.
  • Managing tables, constraints.
  • Overview of views, indexes, sequences, synonyms.
    Basics of privilege management.
    Data dictionary views.
Outline (PDF)

Prerequisites

  • Computer end-user skills, database fundamentals (like data, record, field, table, data relations) skills