Oracle Database SQL

Oracle Database SQL

Certification Mandatory Oracle Database SQL Certified Associate

• Resource should must have hands on experience
• In Writing Medium and Complex queries
• Join concepts Oracle Analytical Functions
• SQL Level Tunning Query Level
• Ingestion Performance tunning Insert Update Data level
• In Autotrace Explain plan
• To read predict the SQL Predictive plan outputs what is Access path why SQL Engine opt that etc
• To read predict the various SQL Stats generated from Auto trace plan outputs
• To change predictive plan via changing Join and Access methods
• Various Optimizer Hints to improve or change predictive plan outputs both Select and Ingestion of data
• Minimum level of readingpredicting AWR Statistics to understand what went wrong in DB or SQL
• Witting Packages Procedures Views Bulk write and read
• Tunning Related Data Dictionary table ie where to look what to look etc
• OOPS Concepts
• NFRs Partitions Indexes Materialized Views PRAGAMA Autonomous Transactions