Oracle Database 12c Administration Online Training

Oracle Database 12c Admin Training

Oracle 12c Admin is the modern way of maintaining the database of an organization secure and effective. Oracle database provides automated backups, uptime and SLA maintenance, automated upgrades and modern web-based integration. It contains the additional features in architecture that help an organization to move hand in hand with the real-time response and provide effective solutions to the database environments. It helps in monitoring the database environment, distribution of resources and scheduled jobs.

COURSE SUMMARY

What you’ll learn in Oracle 12c Admin Training Course?

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

What are the pre-requisites to learn Oracle Database 12c Admin course?

knowledge of Data processing, understanding, and knowledge of data processing techniques, Knowledge of Oracle database concepts

Download Course Curriculum

MODULE 1: INTRODUCTION TO ORACLE DATABASE 12C

TOPICS: The Database Instance, Database Process Structures, Oracle Clusterware, Database Memory Structures, Database administration tasks, Database Storage Architecture, Relational database concepts

MODULE 2: ARCHITECTURE

TOPICS: Overview of Oracle Database Architecture, Oracle Database Instance Configurations, Oracle Database Memory Structures, Process Architecture, Oracle Database memory structures, Connecting to the Oracle Database Instance, Process architecture and structures, Database Storage Architecture, Process Structures, The Oracle database instance, The Oracle database storage architecture, Server and client processes, Overview of the Oracle database architecture, Process Startup Sequence, Connect to the Oracle database instance

MODULE 3: MANAGING THE DATABASE INSTANCE

TOPICS: Administrative tools available to a DBA, Database instance, Use SQL*Plus in Oracle, Enterprise Manager, Administer the database using, The Enterprise Manager Database Express, Overview of the Enterprise Manager framework, Home Page, Initialization parameter files, Access Enterprise Manager Database Express, Enterprise Manager Cloud Control

MODULE 4: CONFIGURING THE ORACLE NETWORK ENVIRONMENT

TOPICS: Oracle Net Listener Overview, Oracle Net Services Overview, Using the Listener Control Utility, Establishing Oracle Network Connections, Using Oracle Net Configuration Assistant, Tools for Configuring and Managing the Oracle Network, Using Enterprise Manager Cloud Control, Using Oracle Net Manager

MODULE 5: MANAGING DATABASE STORAGE STRUCTURES

TOPICS: Database Block Contents, Understanding Storage of Data, Creating a New Tablespace, Managing Tablespaces, Exploring the Storage Structure, Viewing Tablespace Information, Using Oracle Managed Files, Overview of Tablespaces Created by Default

MODULE 6: ADMINISTERING USER SECURITY

TOPICS: Creating a User, Database User Accounts, Authentication, Predefined Administrative Accounts, Privileges, Profiles, Unlocking a User Account, Roles, Resetting the Password

MODULE 7: MANAGING DATA CONCURRENCY

TOPICS: Overview of Locks, DML Locks, Enqueue Mechanism, Data Concurrency, Locking Mechanism, Lock Conflicts

MODULE 8: MANAGING UNDO DATA

TOPICS: Transactions and Undo Data, Storing Undo Information, Undo Data Overview, Managing Undo, Configuring Undo Retention, Changing an Undo Tablespace to a Fixed Size, Undo Data vs Redo Data, Guaranteeing Undo Retention

MODULE 9: PERFORMING DATABASE MAINTENANCE

TOPICS: Viewing the Alert History, Database Maintenance, Automatic Database Diagnostic Monitor, Terminology, Statistic Levels, Automatic Workload Repository, Advisory Framework, Enterprise Manager and Advisors, Managing Performance, Managing Resources by Using Database Resource Manager, Managing Space

MODULE 10: BACKUP AND RECOVERY CONCEPTS

TOPICS: Understanding Instance Recovery, Categories of Failures, Phases of Instance Recovery, Flashback Technology, Using the MTTR Advisor, Media Failure, Tuning Instance Recovery, Configuring for Recoverability, Moving Data