Oracle 12c Database Administration Training
Course duration
- 5 Days
Course Outline
This Introduction to Oracle 12c Database Administration training class provides a complete, hands-on introduction to Oracle database administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer, and SQL*Plus.
This course is appropriate for anyone needing to understand and manage an Oracle 12c database or those needing a general understanding of Oracle database functionality, including end users, business analysts, application developers, database administrators, and IT management.
- Gain a thorough understanding of Oracle 12c database administration.
- Oracle12c SQL.
- Oracle12c PL/SQL.
- Introduction
- Components of an Oracle Database
- Duties of a Database Administrator
- DBA Management Tools
- Review of the Sample Schema
- The Taxes Table
- The ZipCodes Table
- The Jobs Table
- The Departments Table
- The Employees Table
- Objects In The EL Model
- Analysis
- Join Conditions
- SQL*PLUS
- Starting SQL*Plus
- SQL Commands
- PL/SQL Commands
- SQL*Plus Commands
- Login.sql (login.sql In Linux/UNIX)
- SQL Developer
- A Brief Overview of SQL
- What Generation?
- What Sublanguages Are Supported?
- Key Single Row Functions
- Key Group Functions
- Key Analytical Functions
- Other Available Analytical Tools
- Help Me!
- Object Naming
- What Are the Key Datatypes?
- What Constraints Are Available for Table Definitions?
- How Do You Select from Multiple Tables?
- What Is a Self Join?
- What Else Can You Do with a Self Reference?
- New SQL Features of Note in Oracle 12c
- Top N and Bottom N Queries
- Using Extended Datatypes
- DEFAULT Values
- IDENTITY Columns
- Invisible Columns
- Temporal Validity
- Pattern Matching
- Creating Multiple Indexes On Columns
- Miscellaneous New SQL Features
- A Brief Overview of PL/SQL
- NEW PL/SQL Features of Note in Oracle 12c
- White Lists
- The WITH Clause for Functions
- PRAGMA UDF
- New Inquiry Directives
- New DBMS_SQL Functionality
- Enhanced Language Interface Features
- Miscellaneous New PL/SQL Features For Oracle12c
- LAB 1: Introduction
- LAB 1 Solutions: Introduction
- Creating Oracle Databases
- Overview of Database Creation
- THE Oracle Universal Installer
- Prerequise Tasks
- Getting On The Server
- Memory Requirements
- Hardware Requirements
- Software Requirements
- Kernel Requirements
- Resource Limits
- Package Requirements
- Required Users And Groups
- Required Directories
- What About Windows?
- Running the Installer
- Post Installation
- Environment
- Using the Database Configuration Assistant
- Database Templates
- LAB 2: Creating Oracle Databases
- LAB 2 Solutions: Creating Oracle Databases
- Basic Database Administration
- A Brief Roadmap
- Basic Database Administration
- Oracle Networking
- Instance Management
- Storage Management
- Oracle Security
- Schema Objects
- Backup And Recovery
- Oracle Advisors
- Problem Resolution
- Software Management
- Automated Storage
- Database Management Using EMDE
- Environmental Variables
- Accessing Enterprise Manager Database Express
- Enterprise Manager Database Express Access for Non-DBA Users
- Database Administration with Other Tools
- LAB 3: Basic Database Administration
- LAB 3 Solutions: Basic Database Administration
- A Brief Roadmap
- Oracle Networking
- Oracle Networking Overview
- The Oracle NET Listener
- Making a Connection
- Using Easy Connect
- Using Local Naming
- Using NET Manager
- Controlling the Listenerl>
- Starting and Stopping the Listener
- Securing the Listener
- Troubleshooting Networking
- Lab 4: Oracle Networking
- Lab 4 Solutions: Oracle Networking
- Instance Management
- Managing the Oracle Instance
- Needed Vocabulary
- Getting the Database Up
- Changing Parameters
- Background Processes
- Other Processes
- Controlling Memory Usage
- The Startup Process
- Startup Nomount
- Startup Mount
- Startup/Startup Open
- Startup Restrict/Startup Open Restrict
- Startup Force
- The Shutdown Process
- Shutdown/Shutdown Normal
- Shutdown Transactional
- Shutdown Immediate
- Shutdown Abort
- The Overall Shutdown Process
- Using Services For Startup/Shutdown
- Memory Management
- Alternative Architectures
- Real Application Clusters
- Pluggable Databases
- Lab 5: Instance Management
- Lab 5 Solutions: Instance Management
- Managing the Oracle Instance
- Storage Management
- The Basic Logical Structures
- The Block
- The Extent
- The Segment
- The Tablespace
- The Database
- The Physical Structures
- More About Control Files
- More About Online Redo Logs
- More About Archived Redo Logs
- More About Rollback Segments
- What Types Of Tablespaces Are There?
- Tablespace Status
- Default Tablespace Type
- Changing Tablespace Size
- Tablespace Properties
- Encrypted Tablespaces
- Why Add Tablespaces?
- Using EMDE for Storage Management
- Changing Tablespace and Other Alerts
- Managing Space within Tables and Indexes
- Switching Log Files
- Undo Retention
- Reviewing Undo Information
- The Undo Advisor
- Changing Undo Tablespace Size
- Lab 6: Storage Management
- Lab 6 Solutions: Storage Management
- The Basic Logical Structures
- Oracle Security
- Creating User Accounts
- Application Schemas
- Automatically Created Accounts
- Types Of Privileges
- About Roles
- Predefined Roles
- Viewing Roles in Enterprise Manager Database Express
- Creating Roles in Enterprise Manager Database Express
- Dropping a Role
- Admin and Grant Options
- SYSDBA/SYSOPER Details
- User Account Administration
- Considerations Regarding Password Case Sensitivity
- Profiles and Password Policies
- Other Security Features
- Auditing
- Fine Grained Auditing
- The Virtual Private Database
- Oracle Label Security
- Oracle Database Vault
- Oracle Data Redaction
- Lab 7: Oracle Security
- Lab 7 Solutions: Oracle Security
- Creating User Accounts
- Schema Objects
- Schema Objects
- Object Naming
- Fully Qualified Naming
- Aliases
- Object Control
- Table Management
- Column Attributes
- Available Datatypes
- Large Object Enhancements
- Column Constraints
- Partitioning
- Table Storage Attributes
- Table Compression
- Accessing Table Information
- Creating A Table
- Adding Columns
- Dropping Columns
- Adding Constraints
- Disabling Constraints
- Loading Data
- Field Delimited Data
- Comma Delimited Data
- SQL Developer Import
- SQL Developer Export
- About Indexes
- Index Creation
- Views
- Permission Control within Views
- Stored Procedures
- Other Objects
- Materialized Views
- Synonyms
- Sequences
- Database Links
- Lab 8: Schema Objects
- Lab 8 Solutions: Schema Objects
- Schema Objects
- Backup and Recovery
- Overview/Key Concepts
- Users for Backup
- The Fast Recovery Area
- The RMAN Repository
- Database Configuration
- RMAN Configuration
- Block Change Tracking
- Oracle Secure Backups
- Oracle Suggested Backup Strategy
- Scheduling Backups
- Backup Validation and Other RMAN Maintenance
- Restore Validation
- The Report Command
- The List Command
- Oracle Advised Recovery
- User-Directed Recovery
- Flashback Table
- Flashback to before Drop
- Flashback Database
- Manual Restore and Recover
- The Recovery Catalog
- Backup Management
- Monitoring FRA Space Usage
- Oracle Advised Recovery
- Lab 9: Backup And Recovery
- Lab 9 Solutions: Backup And Recovery
- Oracle Advisors
- Proactive Monitoring
- The Automatic Database Diagnostic Monitor
- Monitoring the Database with EMDE
- Using the Performance Hub
- The Summary Tab
- The RAC Tab
- The Activity Tab
- The Workload Tab
- The Monitored SQL Tab
- The ADDM Tab
- The Current ADDM Findings Tab
- The Database Time Tab
- The Resources Tab
- The System Statistics Tab
- Workload Repository Reports
- Modifying Automatic Snapshot Settings
- Using Other Advisors
- SQL Tuning Advisor Details
- The Automatic SQL Tuning Advisor
- SQL Access Advisor
- Running Memory Advisors
- Real Application Testing
- Database Replay
- SQL Performance Analyzer (SPA)
- Lab 10: Oracle Advisors
- Lab 10 Solutions: Oracle Advisors
- Proactive Monitoring
- Problem Resolution
- Overview
- The Resolution Process
- Lab 11: Problem Resolution
- Lab 11 Solutions: Problem Resolution
- Software Management
- Patch Management
- Upgrading The Database
- Edition-Based Redefinition
- Removing Oracle Software
- Automated Storage
- Automatic Storage Management Overview
- The ASM Instance
- Disks, Disk Groups and Failure Groups
- Creating and Dropping Disk Groups
- Adding and Dropping Disks
- ASM Backups
- Hardening the Database
- Eliminating Single Points of Failure
- Hardening Data Files
- Hardening the Control Files
- Hardening the Redo Logs
- Adding Redo Log Groups
- Hardening the Archived Redo Logs
- Hardening the Peripheral Files
- Hardening the Backups
- Hardening the Fast Recovery Area
- Lab 14: Hardening The Database
- Lab 14 Solutions: Hardening The Database
- OS Backup and Recovery
- Why Use the Operating System?
- Closed Backups in Noarchivelog Mode
- Closed Restore in Noarchivelog Mode
- Open Backups in Archivelog Mode
- Restoring in Archivelog Mode
- Recovery in Archivelog Mode
- Incomplete Recovery
- Lab 15: OS Backup and Recovery
- Lab 5 Solutions: OS Backup and Recovery
- Advanced Recovery Manager
- Configuring the Recovery Catalog
- Running Scripts in RMAN
- Creating Scripts in the Catalog
- Lab 16: Advanced Recovery Manager
- Lab 16 Solutions: Advanced Recovery Manager
- Data Pump
- Using Data Pump
- Command Line Syntax
- Using Interactive Mode
- Reattaching
- Data Pump Import Options
- EXPDP Examples
- IMPDP Examples
- Enterprise Manager Database Express and Data Pump
- The Data Pump Driver
- Data Dictionary Views
- Lab 17: Data Pump
- Lab 17 Solutions: Data Pump
- Using Data Pump
- Advanced Security
- DBMS_RLS
- Implementation Tasks
- Our Example Scenario
- The Policy Package
- The Dynamic Predicate Package
- Creating the Context And The Trigger
- Using DBMS_RLS
- Exempting Policies
- DBMS_FGA
- Controlling Column Access with Virtual Columns
- Lab 18: Advanced Security
- Lab 18 Solutions: Advanced Security
- DBMS_RLS
- Shared Server
- Initialization Parameters
- Enabling Shared Servers
- Dispatcher Configuration
- Data Dictionary Views
- Configuring the Client for Shared Server
- Lab 19: Shared Server
- Lab 19 Solutions: Shared Server
- Logminer
- Logminer Basics
- DBMS_LOGMNR
- DBMS_LOGMNR.ADD_LOGFILE
- DBMS_LOGMNR.START_LOGMNR
- DBMS_LOGMNR. END_LOGMNR
- DBMS_LOGMNR.MINE_VALUE
- DBMS_LOGMNR.COLUMN_PRESENT
- DBMS_LOGMNR_D
- DBMS_LOGMNR_D.BUILD
- DBMS_LOGMNR_D.SET_TABLESPACE
- Supplemental Logging
- LOGMINER Use Summary
- Using LOGMINER
- Using Enterprise Manager Database Express with LOGMINER
- Lab 20: LOGMINER
- Lab 20 Solutions: LOGMINER
InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).
InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)
For an overall view of our offerings, please visit us at www.intersource.ch.