Oracle Database 12c Essential Administration

Modules

Hide all

Introduction (8 topics)

• Oracle product overview
• Oracle Support services
• Relational database concepts
• Oracle architecture
• Oracle 12c Multitenant architecture
• Overview of the Oracle Cloud
• Database administration tasks
• Database administration responsibilities

Install the Oracle Database Software with the OIU (7 topics)

• Installation planning
• Understand system requirements and operating system pre-requisites
• Oracle flexible architecture
• Environment variables
• Use Oracle Universal Installer to install Oracle software (OUI)
• The Oracle Inventory
• De-install Oracle Database softare

Create a Database with the Database Configuration Assistant (DBCA) (5 topics)

• Select a storage method
• Select a CDB or non-CDB database
• Select a database type based on workload
• Select a character set for the database
• Create a database using the DBCA

Administer a Database (4 topics)

• Administrative tools available to a DBA
• Use SQL*Plus and SQL Developer to manage a database
• Administer the database using Enterprise Manager Express
• An overview of Enterprise Manager Cloud Control

Configure the Oracle Network Environment (9 topics)

• Overview of network configuration
• Oracle Net Listener configuration and management
• Oracle Net Naming methods
• Tools for configuring and managing the Oracle network
• Configure local naming for client connections with Net Manager
• Start and stop the Oracle listener
• Configure the listener with EM
• Use TNSPING to test Oracle Net connectivity
• Connect to the database

Manage an Oracle Instance (10 topics)

• Oracle Instance
• Instance management
• Memory structures
• Background processes
• Database authentication methods
• Initialization parameters
• Password file
• Shut down the database
• Start up the database
• View alert log and trace files

Database Storage Structures (8 topics)

• Oracle database structures
• Control files
• Redo log and archive redo log files
• Tablespaces and data files
• Create tablespaces
• Manage tablespaces
• Manage undo and use the Undo Advisor
• Use Enterprise Manager Express and SQL Developer to view the storage structure of the database

Manage Users (6 topics)

• Database administration accounts
• User accounts
• Create and administer user accounts
• Lock and unlock user accounts
• Change a user's password
• Administer privileges and roles

Manage Schema Objects (10 topics)

• Create schema objects
• Create a new table
• View the attributes and contents of a table
• Understand data integrity
• Define constraints
• Create indexes
• View index attributes
• Create views
• Create synonyms
• Create sequences

Backup, Recover and Restore a Database (9 topics)

• Oracle backup strategy
• Overview of backup, restore and recovery
• Backup and recovery configuration
• Configure ARCHIVELOG mode
• Overview of backup and recovery operations
• Overview of scheduled backups
• Configure backup settings
• Configure recovery settings
• Perform recovery

Performance Monitoring (5 topics)

• Overview of self-monitoring architecture
• Monitor an Oracle database
• Automatic Workload Repository
• Automatic Database Diagnostics Monitor (ADDM)
• Additional monitoring