Introduction: Managing the Database Instance

• The Database Management Tools
• EM Database Express
• EM Cloud Control
• SQL Developer
• Database Administrator

Introduction: Database Architecture Review

• Database Instance Configurations
• Memory Structures
• Process Structures
• Storage Architecture

Introduction: Starting & Stopping Databse Services

• Start & Stop the Database Listener
• ABOUT DATABASE STARTUP/SHUTDOWN
• SYSOPER
• SYSDBA
• DATABASE STATE & STAGES
• STARTUP WITH EM CLOUD CONTROL
• STARTUP WITH SQL*PLUS
• SHUTDOWN WITH EM CLOUD CONTROL
• SHUTDOWN WITH SQL*PLUS
• USING MS WINDOWS SERVICES

Introduction: Oracle Network Environment

• Oracle Net Services Architecture
• ORACLE NET CONFIGURATION ASSISTANT
• ORACLE NET MANAGER
• USING EM CLOUD CONTROL
• ADVANCED NETWORK COMPRESSION
• TROUBLESHOOTING NETWORK PROBLEMS

Introduction: Diagnostics & Oracle Support

• About Database Diagnostics
• Fault Diagnosability Infrastructure
• DATABASE INSTANCE HEALTH SNAPSHOT
• THE SUPPORT WORKBENCH
• PROACTIVE DATABASE HEALTH CHECKS
• PACKAGE DIAGNOSTIC DATA
• WORKING WITH THE KNOWLEDGE BASE

Storage: Tablespace Management

• Starter Tablespaces
• CREATE TABLESPACE WITH EM CC
• CREATE TABLESPACE WITH SQL
• MANAGE TABLESPACES WITH EM CC
• MANAGE TABLESPACES WITH EM DE
• MANAGE TABLESPACES WITH SQL
• DROP TABLESPACE
• ALTER TABLESPACE

Storage: Advanced Tablespace Management

• Managing Temporary Tablespaces
• TEMP TABLESPACE GROUPS WITH EM
• TEMP TABLESPACE GROUPS WITH SQL
• DEFAULT PERMANENT TABLESPACES
• BIGFILE TABLESPACES
• MANAGING THE SYSAUX TABLESPACE

Storage: Data Files & Temp Files Management

• Manage Data Files with EM
• ACCESS METADATA WITH SQL
• MANAGE DATA FILES WITH SQL
• MANAGE TEMP FILES
• ORACLE-MANAGED FILES (OMF)

Storage: UNDO Data & UNDO Tablespaces

• About UNDO Space Management
• GUARANTEE UNDO RETENTION
• MONITOR UNDO SPACE WITH SQL
• USE THE EM UNDO ADVISOR

Security & Schemas: Security Overview & Database Privileges

• Database Security Principles
• DATABASE SYSTEM PRIVILEGES
• DATABASE OBJECT PRIVILEGES
• SUPER ADMINISTRATOR ROLES
• PRIVILEGE ANALYSIS

Security & Schemas: User Security

• Create & Manage User Accounts
• MANAGE USERS WITH EM
• MANAGE USERS WITH SQL
• CREATE USER
• ALTER USER
• DROP USER
• GRANT & REVOKE PRIVILEGES
• RESOURCE LIMITS VIA PROFILES
• ALTER PROFILE
• DROP PROFILE
• PASSWORD MANAGEMENT VIA PROFILES
• ROLE-BASED SECURITY MANAGEMENT
• ALTER USER...DEFAULT ROLE
• SET ROLE
• DELEGATING PRIVILEGE AUTHORIZATION
• WITH ADMIN OPTION & System Privileges
• WITH GRANT OPTION & Object Privileges
• PRINCIPLE OF LEAST PRIVILEGE CHECKLIST

Security & Schemas: Database Auditing

• Auditing Database Activity
• Traditional Auditing
• Unified Auditing
• Create Audit Policy

Security & Schemas: SQL Loader

• Loader Concepts
• Loader From the Command Line
• control File Options
• Load Methods
• Loader Express Mode
• Loader From EM

Security & Schemas: Export & Import

• Manage Directory Objects
• The Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Dictionary Views
• Using the EM CC Interface

Performance & Availability: Managing Performance & SQL Tuning

• Management Advisory Framework
• Performance Monitoring & AWR
• The SQL Tuning Advisor
• Monitoring Exceptions with Metrics

Performance & Availability: Data Concurrency

• About System & User Locks
• Monitor & Manage User Locks
• Moitor Locks with Data Dictionary
• Manage Locks with EM

Performance & Availability: Backup & Recovery Concepts

• Backup & Recovery Structures
• Managing REDO Data
• Configuring for Recoverability
• Instance Recovery
• Recoverability Checklist

Additional course details:

Nexus Humans Oracle 12c Administration II training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Oracle 12c Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Oracle 12c Administration II Course

Available Delivery Options for the Oracle 12c Administration II training.

• Live Instructor Led Classroom Online (Live Online)
• Traditional Instructor Led Classroom (TILT/ILT)
• Delivery at your offices in London or anywhere in the UK
• Private dedicated course as works for your staff.

How many CPD hours does the Oracle 12c Administration II training provide?

The 5 day. Oracle 12c Administration II training course give you up to 30 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

What is the correct audience for the Oracle 12c Administration II training?

This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals.

Do you provide training for the Oracle 12c Administration II.

Yes we provide corporate training, dedicated training and closed classes for the Oracle 12c Administration II. This can take place anywhere in UK including, England, Scotland, Cymru (Wales) or Northern Ireland or live online allowing you to have your teams from across UK or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Oracle 12c Administration II program.

The Oracle 12c Administration II training takes place over 5 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

Why are Nexus Human the best provider for the Oracle 12c Administration II?

Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for UK on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.

Is there a discount code for the Oracle 12c Administration II training.

Yes, the discount code PENPAL5 is currently available for the Oracle 12c Administration II training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.