The Oracle Database 19c Development Fundamentals course provides step-by-step instructions on how to perform a variety of administrative and development tasks for activities based on real-life work scenarios. Students get introduced to Relational Database Modelling Concepts, the Oracle Database 19c Enterprise Edition Options, Architecture, performance management and tuning.
On successful Completion of this course you will be able to:
Describe Databases and the Relational Model
Describe the basic architecture and concepts Oracle
Describe Oracle Database Related Products
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in Oracle
Modify data using SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Implement pivoting and grouping sets
Create Databases and Database Objects
Perform Oracle Database Administration
Perform Database Performance Management
Perform SQL Database Tuning
Develop efficient PL/SQL programmes to access Oracle databases
Create stored procedures and functions for reuse and maintenance