In this module, you will identify the demography of the tables. Different data types will be explored. Also, select statement execution will be elaborated.
Query Optimization Techniques
In this module, you will understand the different techniques offered by Oracle to know how any select statement gets executed internally. This module also describes the compilation process of any select statement.
Indexing Strategies
In this module, you will interpret how indexes contribute to enhancing the performance of a query, and the hazards of a full table scan are covered.
Performance Tuning Tools and Techniques
In this module, you will understand how hints can be useful to uplift the query execution process. A querying technique known as Inline view is covered. An Oracle object temporary table’s usage for solving real-life problems is depicted.