Course Oracle Database Administration
Course participants will learn to install and administer databases in the Oracle environment.
Minimum input knowledge
basic knowledge of the SQL language
Course dates Oracle Database Administration
Daily courses (2 days): 09:00 - 15:00
Course price: 350.00 / 430.50 EUR
without VAT / incl. VAT
Training syllabus Oracle Database Administration
Basic Oracle Terminology
- database, instance, Oracle software
Database Administration Tools
- Oracle Enterprise Manager, SQLPlus) use of OFA (optimal flexible architecture) architecture software installation using Oracle Universal Installer (OUI)
Creating an Oracle Database
- using Database Configuration Assistant (DBCA) creating a database design template using DBCA generating scripts for creating a database using DBCA
Starting and Stopping the Oracle Database and Components
- description of an instance (the most important memory structures and processes, description of their operation) database initialization parameters Alert log working with Data Dictionary (most frequently used views) description of data structures tablespace and data files OMF (Oracle Managed Files) basic concept of automatic storage management (ASM)
Creating and Managing Database User Accounts
- user authentication granting and revoking system and object privileges, roles and profiles controlling user resource usage managing data using SQL identification and administration of PL/SQL objects description of triggers and triggering events (in more detail in the PL/SQL module) monitoring and resolving locking conflicts explanation of DML and generation of undo data
Monitoring and Administration of Undo
- description of the difference between undo data and redo data configuration of the undo retention period (retention guarantee, resolving related errors)
Database Administrator Security Privileges
- use of the principle of lowest-level access rights use of Enterprise Manager to configure the Oracle network environment creating additional listeners
Creating Network Service Aliases
- management of Oracle Net Listener (lsnrctl utility) testing Oracle Net connectivity (tnsping utility) use of shared or dedicated servers
Proactive Administration
- use of statistics managing AWR (Automatic Workload Repository) use of Automatic Database Diagnostic Monitor (ADDM) description of the Advisory Framework setting alert thresholds use of alerts generated by the server use of automated tasks
Performance Management
- use of Enterprise Manager pages to monitor performance use of SQL Access Advisor use of SQL Tuning Advisor use of automatic memory management and Memory Advisor use of dynamic views related to performance troubleshooting invalid or unusable objects
Oracle Database Backup and Recovery
- identification of types of failure that can occur in an Oracle database description of methods for setting instance recovery meaning of checkpoints, redo log files and archived log files configuration of ARCHIVELOG mode creating consistent database backups backing up the database without shutting it down creating incremental backups automating database backup monitoring Flash Recovery Area recovery after loss of controlfile recovery after loss of redo log performing complete recovery after loss of a data file
Database Flashback
- restoring table contents at a specific point in the past using the Flashback Table function restoring a dropped table displaying database contents at any point in time using the Flashback Query function displaying row versions for a certain time period using Flashback Version Query displaying row transaction history using Flashback Transaction Query description of available methods for moving data creating and using directory objects use of SQL*Loader loading data from a database other than Oracle (or from user files)
Oracle Database Export, Import
- use of export and import for fast data transfer to move data between Oracle databases use of external tables to move data using files that do not depend on the platform
Output knowledge
Getting familiar with system architecture, installation, database creation and system maintenance.
Recommended courses after completing Oracle Database Administration
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Oracle Database Administration
Average rating