Setup Menus in Admin Panel

Compu21

Setup Menus in Admin Panel

Oracle DBA

Oracle DBA Part 1:  Oracle introduction Write efficient SQL statement Restricting and sorting data Single row, multiple row and group …

0 STUDENTS ENROLLED

    Oracle DBA

    Part 1:  Oracle introduction

    • Write efficient SQL statement
    • Restricting and sorting data
    • Single row, multiple row and group functions
    • Display data from multiple table using join function.
    • Subquery and output with SQLPLUS
    • Manipulating data
    • Create database objects such as table, index, constraint, and view.
    • Controlling user access
    • Oracle 10g date time and set operation.
    • Advance subquery and hierarchical retrieval
    • Oracle 9I extensions and DML and DDL statement
    • Introduction PL/SQL

    Part 2: Oracle database administration, Workshop I

    • Oracle architectural components
    • Operation for database server startup and shutdown.
    • Managing oracle instance and create database
    • Data dictionary contents and usage
    • Maintaining the control file, redo log file, data file and tablespace
    • Storage structure and relationship in system management and local management.
    • Managing undo data and temp data
    • Managing table, indexes, constraints, password security and resources
    • Managing user, privilege and role.
    • Globalization Support.

    Part 3: Oracle database administration, Workshop II

    • Basic oracle network architecture
    • Oracle net server-side configuration
    • Oracle net client-side configuration
    • Usage and configure of Oracle shared server
    • Instance and media recovery structure
    • Configuring DB archive mode
    • Oracle recovery management overview and configure.
    • User managed backup
    • RMAN backup
    • User managed/RMAN completed recovery
    • User managed/RMAN incomplete recovery
    • RMAN recovery catalog creation and maintenance.
    • Transporting data between databases.
    • Loading data into database

    Part 4: Performance tuning Oracle database

    • Performance tuning step and tools
    • Database configuration and I/O issues
    • Sizing share pool, buffer cache and other SGA structure
    • Tuning oracle shared server (MTS)
    • Tuning undo segments
    • Tuning SQL statement and application tuning
    • Managing statistics
    • Using materialized views
    • Monitoring and detecting lock contention
    • Using source manage and tuning OS

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts