Oracle Administration Informatics
Price: AED 4,000

    Course details



    Course Overview
    (PL/SQL, Workshop I & Workshop II)
    Oracle 10g- Introduction to SQL and PL/SQL
    Course Contents:
    Retrieving Data Using the SQL SELECT Statement
    Restricting and Sorting Data
    Using Single Row Functions to Customize Reports
    Reporting Aggregated Data Using the Group Functions
    Displaying Data From Multiple Tables
    Using Sub queries to Solve Queries
    Using the SET Operators
    Manipulating Data
    Using DDL Statements to Create and Manage Tables
    Creating Other Schema Objects
    Managing Objects with Data Dictionary Views
    Controlling User Access
    Generating Reports by Grouping Related Data
    Managing Data in Different Time Zones
    Searching Data Using Advanced Sub queries
    Hierarchical Data Retrieval
    Introduction to PL/SQL Objects
    Procedural Language
    PL/SQL Blocks, Anonymous Blocks and Named Blocks
    Creating PL/SQL Procedures and Functions
    Understanding Triggers
    Oracle 10g-Administration Workshop I
    Course Contents:
    Installing Oracle Database 10g Software
    Create an Oracle Database
    Database interfaces
    Controlling the database
    Storage Structures
    Administering users
    Managing Schema Objects
    Managing Data
    Oracle Database Security
    Oracle Net Services
    Oracle Shared Server
    Performance Monitoring
    Proactive Maintenance: Objectives Undo Management
    Monitoring and Resolving Lock Conflicts
    Backup and Recovery Concepts
    Database Backups
    Database Recovery
    Oracle 10g-Administration Workshop II
    Course Contents:
    Using Globalization Support
    Securing the Oracle Listener
    Configuring Recovery Manager
    Using Recovery Manager
    Diagnostic Sources
    Recovering from non-critical losses
    Database Recovery
    Flashback database
    Recovering from User Errors
    Dealing with Database Corruption
    Automatic Database Management
    Monitoring and Managing Storage
    Automatic Storage Management
    Monitoring and Managing Memory
    Managing Resources
    Automating Tasks with the Scheduler Updated on 25 November, 2019

    About Informatics

    INFORMATICS is the only institute where you get real valuable coaching. INFORMATICS stands unique from the rest of the institutes by evidently giving you return on your investment in terms of performance improvement.

    INFORMATICS seeks to improve the human condition by advancing knowledge and fostering creativity. It does so through research and education and a commitment to social justice, human rights and a sustainable environment. It values: excellence in research and scholarship, excellence in education, excellence in management, international focus, innovation and creativity, diversity, fairness, engagement, integrity, and self-reliance.

    See all Informatics courses
    Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?