Certificate in Oracle Database Programming [CCOR]

Certificate in Oracle Database Programming [CCOR]

Certificate in Oracle Database Programming [CCOR]

Duration     : 3 Months
Eligibility    : CCCP

    Introduction to SQL constructs
    Review of Basic SQL statements
    Select, Project, Join
    Describing Oracle tables
    Restricting row returns Using SQL*Plus
    Creating basic reports
    Using the set commands
    Column wrapping
    Creating breaks and summaries
    Adding prompts to queries Joining Oracle tables
    Equi-join
    Outer join
    Hiding joins by creating views
    Using IN, NOT IN, EXISTS and NOT EXISTS
    Subqueries
    Exercise � write a subquery
    Correlated subquery
    Non-correlated subqueries Advanced SQL operators
    Between operator
    IN and NOT In operators
    Sub-queries
    EXISTS clause
    Using wildcards in queries (LIKE operator) Aggregation in SQL
    Count(*)
    Sum
    Avg
    Min and max
    Using the group by clause SQL access methods
    Review of Basic joining methods
    Merge join
    Hash Join
    Nested Loop join
    Advanced SQL operators
    Between operator SQL Tuning
    Introduction to rule-based optimization
    Introduction to cost-based optimization
    Collecting table and index statistics
    Using column histograms
    Changing the default optimizer modes
    Using TKPROF
    Using SQL*Trace
    SQL reusability within the library cache
    Table high-water mark
    Table striping and table partitions
    Using EXPLAIN PLAN
    Interpreting EXPLAIN PLAN Output
    Using indexes to improve performance
    Identifying full-table scans
    Re-writing SQL queries
    Using hints to improve SQL performance
    Using parallel query to improve performance
    Tuning sub-queries