OraDuration: 4 days – 28 hours
Overview
The core objective of this training course is to learn about the Oracle 21C database SQL transactions. The training will start from installing the Oracle 21C server and then understanding the fundamental of creation databases and tables, including the metadata components of these schemas. The course will discuss also the single row and multiple row transactions used in query transactions. Other components like views, sequence, set, and basic PL/SQL routines.
Objectives
- Install and configure the default Oracle 21C database server
- Learn and understand the Data definition language of Oracle 21C
- Learn and understand the Data Manipulation language of Oracle 21C
- Learn to create stored routines
Course Content
Introduction to Relational Databases
- Review on database management system concepts
- Best practices in creating SQL scripts
- Installation of Oracle 21C server
- Installation of client applications
- SQL developer
- Oracle JBuilder
- Creating a script file
- Spooling a script file
Designing, managing, ang creating table schemas
- The dual table
- Creating and dropping a table
- Column data types
- Column constraints and metadata
- Foreign key relationships and integrity constraints
- Altering table columns and metadata
- Creating temporary table
The data manipulation languages
- Approaches in inserting records
- Updating table records and fields
- Deleting table records
- Truncating table
The query transactions
- The selection and projection
- The single row functions
- The string functions
- The number functions
- The temporal functions
- The ordering statement
- The data analysis statements
- The group by
- The having statement
- The multiple row transactions
- The JOIN transactions
- The SET operations
- The subquery
- Advance query topics
- Other Oracle components
- Creating views
- Creating sequences
- Creating routines
- Integrating Oracle 21C database to Java client applications
