Scribd Logo
Upload

Welcome to Scribd!

  • 141 views

    Oracle 11g Modules

    Uploaded by

    Harsha Vardhan V
    This document outlines four modules for an Oracle 11g certification track. Module 1 focuses on SQL fundamentals over 48 hours, teaching how to retrieve and manipulate data using SQL. Module 2 teaches PL/SQL fundamentals over 48 hours, including how to write code to interface with databases. Module 3 is a 48-hour Oracle Database 10g administration workshop covering installation, configuration, backup/recovery and more. Module 4 is another 48-hour Oracle 10g administration workshop teaching advanced tasks like performance monitoring and backup/recovery tools. Prerequisites and exit profiles are provided for each module.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Oracle 11g Modules

    Uploaded by

    Harsha Vardhan V
    141 views2 pages
    This document outlines four modules for an Oracle 11g certification track. Module 1 focuses on SQL fundamentals over 48 hours, teaching how to retrieve and manipulate data using SQL. Module 2 teaches PL/SQL fundamentals over 48 hours, including how to write code to interface with databases. Module 3 is a 48-hour Oracle Database 10g administration workshop covering installation, configuration, backup/recovery and more. Module 4 is another 48-hour Oracle 10g administration workshop teaching advanced tasks like performance monitoring and backup/recovery tools. Prerequisites and exit profiles are provided for each module.

    Original Description:

    modules

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines four modules for an Oracle 11g certification track. Module 1 focuses on SQL fundamentals over 48 hours, teaching how to retrieve and manipulate data using SQL. Module 2 teaches PL/SQL fundamentals over 48 hours, including how to write code to interface with databases. Module 3 is a 48-hour Oracle Database 10g administration workshop covering installation, configuration, backup/recovery and more. Module 4 is another 48-hour Oracle 10g administration workshop teaching advanced tasks like performance monitoring and backup/recovery tools. Prerequisites and exit profiles are provided for each module.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    141 views2 pages

    Oracle 11g Modules

    Uploaded by

    Harsha Vardhan V
    This document outlines four modules for an Oracle 11g certification track. Module 1 focuses on SQL fundamentals over 48 hours, teaching how to retrieve and manipulate data using SQL. Module 2 teaches PL/SQL fundamentals over 48 hours, including how to write code to interface with databases. Module 3 is a 48-hour Oracle Database 10g administration workshop covering installation, configuration, backup/recovery and more. Module 4 is another 48-hour Oracle 10g administration workshop teaching advanced tasks like performance monitoring and backup/recovery tools. Prerequisites and exit profiles are provided for each module.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Oracle 11g Modules

    (DBA Track)
    Module 1: oracle 11g: SQL Fundamentals
    Duration: 48 hours
    Contents:

    Identify the major components of Oracle


    Database 11g Retrieve row and column data
    from tables with the SELECT statement

    Create reports of sorted and restricted data


    Employ SQL functions to generate and retrieve
    customized data

    Execute complex queries, DDL statements, and


    DML statements

    Control database access to specific objects and


    add new users with different levels of access
    privileges

    Manage schema objects and objects with data


    dictionary views

    Manipulate large data sets in the Oracle


    database by using sub queries

    Manage data in different time zones

    Write multiple-column, scalar, and correlated sub


    queries

    Use the regular expression support in SQL


    Prerequisites:
    Student should have working knowledge of computer
    and Windows
    Exit Profile:
    After completing this program, student will be able to
    apply key concepts of relational database and SQL
    programming Language.
    Global Certification Mapped:
    1Z0-051 Oracle Database 11g: SQL
    Fundamentals
    Module 2: Oracle 11g: PL SQL Fundamentals
    Duration: 48 hours
    Contents:

    Identity the programming extensions that PL/SQL


    provides to SQL

    Write PL/SQL code to interface with the database

    Design PL/SQL anonymous blocks that execute


    efficiently

    Use PL/SQL programming constructs and


    conditional control statements

    Handle run-time errors

    Describe stored procedures and functions,

    Create , execute , and maintain procedures,


    functions, package constructs and triggers:

    Use a subset of Oracle-supplied packages to


    generates screen and file output

    Identify various techniques that impact your


    PL/SQL code design considerations

    Use the PL/SQL compiler, manage PL/SQL code,


    and mange dependencies
    Prerequisites:
    Student should have knowledge of SQL, equivalent to
    Oracle 11g: Introduction to SQL module
    Exit Profile:

    After completing this program, students will be able


    to apply key concepts of relational databases and
    SQL programming language.

    Global certification Mapped:


    1Z0-144 Oracle Database 11g: program with
    PL/SQL
    Module 3: oracle Database 10g: Administration
    Workshop I
    Duration: 48 hours
    Contents:

    Install Oracle Database 10g and configure a


    database

    Mange the oracle instance

    Manage the database storage structures

    Create and administer user accounts

    Perform backup and recovery of a database

    Monitor, troubleshoot, and maintain a database

    Configure Oracle net services

    Move data between databases and files


    Prerequisites:

    The student should have knowledge of SQL


    equivalent to:Oracle database 10g: introduction to SQL and
    Oracle Database 10gPL/SQL Fundamental

    Knowledge of Linux is desirable


    Exit Profile:

    Learner will be able to administer and maintain


    the oracle10G database
    Global Certification Mapped:
    Oracle Database 10g Administrator Certified
    Associate 1Z0-042
    Module 4: Oracle 10g Administration Workshop
    II
    Duration: 48 hours
    Contents:

    Use RMAN to create and manage backup sets


    and image copies

    Recover the database to a previous point in time

    Use Oracle secure Backup to backup and recover


    a database

    Use Oracles Flashback technology to recover


    your database

    Detect block corruptions and take appropriate


    measures to correct them

    Use the various Database advisors and views to


    monitor and improve database performance

    Control Database resource usage with the


    Resource Manager

    Simplify management tasks by using the


    Scheduler

    Review database log files for diagnostic


    purposes

    Customize language-dependent behavior for the


    database and individual sessions
    Administer a VLDB
    Implement secure database
    Transport data across platforms

    Prerequisites:

    The student should have knowledge of Oracle


    Database 10g:
    Administration workshop I

    Knowledge of Linux is desirable.

    Exit Profile:

    Learner will be able to perform advance


    database administration tasks on the Oracle 10G
    database
    Global Certification Mapped:
    Oracle database 10g Administrator Certified
    professional 1Z0-043

    You might also like