TypeClassroom Training
Time5 Days

Oracle 12 C Database Administration Training Course & Certification


Audience & Prerequisites

Course Outline

Schedule & Fees


Oracle 12 C Database Administration Training Course

Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.

Objectives of Oracle 12 C Training

  • Identify the major structural components of the Oracle Database 12c
  • Create reports of aggregated data
  • Write SELECT statements that include queries
  • Retrieve row and column data from tables
  • Run DML in Oracle Database 12c
  • Create tables to store data
  • Utilize views to display data
  • Control database access to specific objects
  • Manage schema objects
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Manage objects with data dictionary views
  • Write multiple-column sub-queries
  • Employ SQL functions to retrieve customized data
  • Use scalar and correlated sub-queries
  • Create reports of sorted and restricted data

Prerequisites for Oracle 12 C Cerfitification

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Data processing
  • Familiarity with data processing concepts and techniques

Intended Audience of Oracle 12 C Course

  • Data Warehouse Administrator
  • Forms Developer
  • System Analysts
  • Business Analysts
  • Developer
  • Application Developers
  • PL/SQL Developer

Course Outline                                                  Duration: 05 Days

  1. Overview of Oracle Database 12
    • Configuring the instance and database
    • Conceptualizing the Oracle 12c architecture
  2. Constructing an Oracle 12
    • Creating the database
    • Starting and stopping the database
  3. Automating administration with Oracle Enterprise Manager (OEM) Cloud Control 12
    • Evaluating the OEM architecture
    • Maintaining the database with OEM Cloud Control 12c
  4. Flashing Back Oracle 12
    • Configuring UNDO tablespaces
    • Monitoring and reversing changes to data
  5. Managing Users and Resources
    • Establishing user accounts
    • Enforcing security
  6. Performing Space Management
    • Building the storage hierarchy
    • Structuring data and index segments
  7. Partitioning for Performance and Administration
    • Creating partitioned and subpartitioned tables
    • Maintaining index partitions
  8. Building a Fault-Tolerant Database
    • Safeguarding the database
    • Backing up the database and performing recovery

Course Duration: 05 Days

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly contact us.