Aim of the module / training
The aim of this module is to expand the database resources in Oracle databases.
In the framework of this module, participants will gain knowledge of Oracle database operation, database access, data manipulation, and even further.
A brief description of the main module content
- Introduction
- Oracle database architecture
- Installing the Oracle Express version
- Ways of accessing database
- Syntax for annotating a command
- DDL commands
- DML commands
- Data display, filtering and sorting
- Functions to show a row as a result
- Function groups
- SQL Joins
- Subqueries and Set Operators
Achievable results after completing the module:
- Basic knowledge of the function of the note pad
- Connect based on Notes
- Note browsing, filtering and sorting
- Browse notes from 2 or more tables
- Types of connections when browsing notes
- Insert, Modify and delete notes
- Saving file browsing results.
- Working with Subqueries
- Working with Functions
Module Duration: (56 working hours)
Price: 190 €
Aim of the module / training
The purpose of this module is to expand the database resources of Oracle databases. During the course of this module, participants will gain hands-on knowledge of database operation and administration in Oracle.