Oracle Database SQLC-ORACLE-SQL-I

The course is available on demand.

Remote training: online live with a trainer and a group. Available on demand, at time and place convenient to you, for groups of at least 5 participants.

exempt from VAT

Price: 990 EUR

refreshments included

computer station included

first minute (30+ days before) - 3%

Category: Databases and SQL

This course covers all the skills needed to use Oracle Database in professional work. Structured knowledge of SQL can be an asset to business analysts, report writers, application developers in the RAD environments (Oracle Forms, Oracle Fusion and even Microsoft Access), programmers and enterprise application architects.

This four-day intensive course covers, among other things, the full requirements for the 1Z0-071 Oracle Database SQL exam, which when passed grants you an Oracle Database SQL Certified Associate certificate.

This course covers work at the user level. It does not focus on performance or implementation aspects.

What if you want to go one step further and become an Oracle database developer?


4 days


  1. Introduction to databases:
    • basic concepts relating to databases
    • relational data model
    • transactional databases.
  2. A few words about Oracle:
    • DBMS architecture,
    • versions and licenses,
    • available tools,
    • work environment configuration.
  3. Create simple SQL queries:
    • displaying data retrieved from the database,
    • sorting and limiting the number of rows returned,
    • using alternative column names – aliases,
    • basic mathematical operations and string concatenation,
    • data filtering,
    • substitution of variables during query execution,
    • NULL value and its handling in database,
    • elimination of repetitive rows – DISTINCT clause.
  4. Extended data selection:
    • logical operators of conjunction and negation of conditions,
    • comparison operators (>, >=, =, <, <=, <>, !=),
    • range operator (BETWEEN),
    • membership operator (IN),
    • pattern operator (LIKE).
  5. scalar functions
    • date and time operations,
    • operations on character types,
    • numeric functions,
    • conditional functions, logical operators (CASE, DECODE, COALESCE, NVL, NVL2),
    • implicit type conversion,
    • functions relating to type conversion: TO_CHAR, TO_DATE, TO_NUMBER,
    • use of functions in all places of the query
  6. Data aggregation
    • grouping functions,
    • filtering rows after aggregation.
  7. Set operations
    • control of the order of rows returned by operations on sets.
  8. Joining data sets:
    • available join criteria, equijoin types, theta-join, natural joins
    • Oracle and ANSI SQL syntax
    • cross joins,
    • external joins,
    • selfjoin type,
    • antijoin type.
  9. Nested queries (subqueries)
    • scope of subqueries,
    • scalar subqueries,
    • multiline subqueries,
    • correlated and uncorrelated subqueries.
  10. DML (Data Manipulation Language) commands and transactions
    • inserting rows,
    • deleting data from the database,
    • changing data in the database,
    • the scope of constraints when performing DML operations
  11. Transaction Management
    • commit, rollback transactions, save points,
    • locks on concurrent execution of operations,
    • deadlocks,
    • UNDO space principle and FLASHBACK operations.
  12. DDL (Data Definition Language) commands
    • creating, deleting and modifying tables, column types,
    • constraints, primary and foreign keys,
    • creating simple and complex views,
    • schemas in a database,
    • other database objects: indexes, synonyms (public and private), sequences.
  13. Database design
    • basic information about standardisation,
    • normalization and efficiency,
    • selecting appropriate data types
    • good practices of creating and naming objects

Download as PDF

Audience and prerequisites

Course participants do not need to have any prior specialist knowledge, but should have no problems with basic computer skills. It may be advantageous, but it is not necessary to have good knowledge of Excel or to have some programming skills.


Course participants receive completion certificates signed by ALX.

There are currently no entries

Enter your e-mail address and we will notify you about future dates


Ask us anything about this training

* I hereby give my consent to the processing of my personal data by ALX Training Ltd. for the purpose of this request.