Oracle Database - SQL Fundamentals (ORA0)

Databases, Oracle

Get practical Oracle SQL skills: learn to write clear SELECT queries, combine data with JOINs, and filter results using WHERE. The course covers relational concepts, basic data manipulation and tools for exploring and extracting data.

Build and change database structures: create tables, indexes, constraints and views using DDL, and manage data with DML statements like INSERT, UPDATE and DELETE. The training also covers access control and tools for running scripts and flashback queries.

Location, current course term

Brno + online (volitelně)	9/24/2025 - 9/26/2025 CZECH Order 12/17/2025 - 12/19/2025 CZECH Order
Praha + online (volitelně)	10/20/2025 - 10/22/2025 CZECH Order 12/17/2025 - 12/19/2025 CZECH Order
Custom	Customized Training (date, location, content, duration)

The course:

Hide detail

• Introduction and distinguishing SQL from SQL*Plus commands
1. Logging in via iSQL*Plus
2. Working with SQL*Plus and SQL Developer
3. Using SET commands

• Retrieving data with the SELECT statement
1. Using arithmetic and concatenation operators
2. Using WHERE to select specific rows
3. Applying logical expressions in WHERE
4. Using LIKE for text matching
5. Logical operators AND, OR, NOT
6. Operator precedence

• CROSS JOIN to produce a Cartesian product
1. NATURAL JOIN
2. Restricting NATURAL JOIN to listed columns – JOIN USING
3. General joins – JOIN ON; joining three or more tables
4. LEFT, RIGHT and FULL OUTER JOIN

• Sorting results with ORDER BY

• Overview and use of aggregate functions
1. Grouping rows with GROUP BY
2. Filtering grouped results with HAVING
3. ROLLUP, CUBE and GROUPING clauses

• Date and numeric functions
1. Using SYSDATE to get the current date, default formats
2. Using the DUAL table to evaluate expressions
3. Handling data across time zones

• DISTINCT with aggregate functions
1. How aggregates handle NULL values
2. Grouping by multiple columns
3. Avoiding invalid queries with aggregates

• Best practices for subqueries
1. Types of subqueries: single-row, scalar subqueries
2. Using aggregate functions in subqueries
3. Illegal subquery constructs
4. Multi-row subqueries
5. Using IN, ANY and ALL with subqueries
6. Effect of empty subquery results on the outer query

• Combining row sets with UNION and eliminating duplicates
1. UNION ALL to keep duplicates
2. INTERSECT operator
3. MINUS operator

• Using DML commands INSERT, UPDATE, DELETE
1. Using DDL to create tables, indexes, constraints and views

• Working with flashback queries

• Saving SQL commands into batch/script files

• Managing objects via data dictionary views

• Controlling user access and privileges

• Retrieving hierarchical data

• Support for regular expressions and case-insensitive searches

Assumed knowledge:

Basic knowledge of MS Windows.

Recommended subsequent course:

Oracle Database - Programming in PL/SQL (ORA5)

Schedule:

3 days (9:00 AM - 5:00 PM )

Course price:

656.00 € ( 793.76 € incl. 21% VAT)

Language: