Course Contents
View Course Contents - DAY 1
...more Oracle Database 12cR2 Essential Administration Training Course
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: INTRODUCTION
- 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
Session 2: INSTALL THE ORACLE DATABASE SOFTWARE WITH THE OIU
- 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
Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)
- 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
Session 4: ADMINISTER A DATABASE
- 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
Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT
- 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
View Course Contents - DAY 2
Session 6: MANAGE AN ORACLE INSTANCE
- 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
Session 7: DATABASE STORAGE STRUCTURES
- 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
Session 8: MANAGE USERS
- Database administration accounts
- User accounts
- Create and administer user accounts
- Lock and unlock user accounts
- Change a user's password
- Administer privileges and roles
Session 9: MANAGE SCHEMA OBJECTS
- 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
Session 10: BACKUP, RECOVER AND RESTORE A DATABASE
- 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
Session 11: PERFORMANCE MONITORING
- Overview of self-monitoring architecture
- Monitor an Oracle database
- Automatic Workload Repository
- Automatic Database Diagnostics Monitor (ADDM)
- Additional monitoring
- Use the advisors
Course Contents View Course Contents - DAY 1
...more Oracle Database 12cR2 Essential Administration Training Course
Oracle Database 12cR2 Essential Administration Training Course Oracle Database 12cR2 Essential Administration Training Course
Connect to the database View Course Contents - DAY 2