Apex Administration in Linux & Windows

  • Date: 30 May - 18 July 2017
  • Duration: Evening(5:00 PM-8:00 PM)
  • No. of Classes/sessions: 18 sessions
  • Class Schedule: Sunday, Tuesday and Thursday
  • Total Hours: 54

Price: Tk. 18,000



123456, 5647890 , 0123456789, 012345678910


  • Introduction (Database Architecture)
    • Describe course objectives
    • DBA roles and responsibilities
    • Explore the Oracle DBMS architecture
    • Basic Linux command
  • Installing the Oracle Database Softwarein Linux
    • Explain core DBA tasks and tools
    • Plan an Oracle installation
    • Use optimal flexible architecture
    • Install software with the Oracle Universal Installer (OUI)
  • Creating an Oracle Database
    • Create a database with the Database Configuration Assistant (DBCA)
    • Create a database design template with the DBCA
    • Use optimal flexible architecture
  • Managing the Oracle Instance
    • Start and stop the Oracle database and components
    • Use Enterprise Manager (EM)
    • Access a database with SQL*Plus and iSQL*Plus
    • Modify database initialization parameters
    • Understand the stages of database startup
    • View the Alert log
    • Use the Data Dictionary
  • Managing Database Storage Structures
    • Describe table data storage (in blocks)
    • Define the purpose of tablespaces and data files
    • Create and manage tablespaces
    • Obtain tablespace information
  • Administering User Security
    • Create and manage database user accounts
    • Authenticate users
    • Assign default storage areas (tablespaces)
    • Create and manage roles
    • Create and manage profiles
    • Implement standard password security features
  • Backup and Recovery Concepts
    • Identify the importance of checkpoints, redo log files, and archived log files
    • Configure ARCHIVELOG mode
    • Back your database up without shutting it down
    • Create incremental backups
    • Automate database backups
  • Performing Database Recovery
    • Recover from loss of a control file
    • Recover from loss of a redo log file
    • Perform complete recovery following the loss of a data file
  • Performing Flashback
    • Monitor and administer undo
    • Describe Flashback database
    • Restore the table content to a specific point in the past with Flashback Table
    • Recover from a dropped table
    • View the contents of the database as of any single point in time with Flashback Query
    • See versions of a row over time with Flashback Versions Query
    • View the transaction history of a row with Flashback Transaction Query Moving Data
    • Explain the general architecture of Data Pump
    • Use Data Pump Export and Import to move data between Oracle databases
  • Configuring Recovery Manager
    • Recovery Manager Features and Components
    • Using a Flash Recovery Area with RMAN
    • Configuring RMAN
    • Control File Auto backups
    • Retention Policies and Channel Allocation
    • Using Recovery Manager to connect to a target database in default NOCATALOG mode
    • Displaying the current RMAN configuration settings
    • Altering the backup retention policy for a database
    • RMAN Command Overview
    • Compressed Backups

    This training is intended for a person who has experience working with Microsoft Excel and would like to learn more about creating dynamic reports, dynamic dashboard, dynamic template and Charts which Increase one’s productivity as well as reduce work load and reporting errors by creating and modifying macros.

    Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.


    Roksana Parvin

    Web Designer

    Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

    Read MOre