Oracle Database Development Fundamentals

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
• Design modular applications using packages