Workshop
Oracle for Database Administrators («ODADMI»)
In this workshop you will get to know the Oracle database in detail. Important activities of a database administrator will be explained and taught with practical exercises. A top Oracle expert will be at your side.
Duration
5 days
Price
4'100.–
Course documents
Digital courseware
Course facts
- Independent installation of the Oracle database
- Independent administration of the Oracle database
- Independent analysis of the Oracle database using existing tools
- Acquisition of comprehensive knowledge about the most important competencies of the Oracle database
In this intensive workshop, our Oracle database engineer Jürg Hiltbrunner will teach you the following:
- Database management tools
- EM Database Express
- Cloud Control
- SQL Developer
- Database architecture
- Memory structures
- Database processes
- Storage architecture
- Managing Database Instance
- Spfile/Pfile
- Start database
- Stop database
- SYSOPER
- SYSDBA
- OS Authentication
- Password File
- Oracle Net
- Configuration file (tnsnames.ora,sqlnet.ora,listener.ora)
- Network compression
- Solve Oracle Net problems
- Diagnostics and Support
- DIAG
- ADR
- Tablespace Management
- Extent Management
- Bigfile Tablespace
- Datafiles
- Autoextend
- Segment Space Management
- Create Tablespace with SQL-Plus
- Enlarge Tablespace and add datafiles
- Delete Tablespaces
- Change Tablespaces
- Creating and Managing Tablespaces
- How is data stored?
- Create Tablespaces with SQL*Plus
- View Tablespace information in SQL*Plus
- Oracle Managed Files
- Move and rename Data Files online with SQL*Plus
- Schema – from admin's point of view
- Dba_objects, dba_segments, DBA_Tables and indexes
- Constraints
- Truncate High Water Mark
- Indexes, Function Based Index and Rebuild
- Views
- Sequences
- Temporary Tables
- Extended Tablespace management
- Temporary Tablespace
- Temporary Tablespace groups
- SYSAUX Tablespace
- OMF
- Managing UNDO Data
- UNDO overview
- UNDO parameters
- UNDO Guarantee
- UNDO Views
- Security
- Important principles
- Profiles
- Roles
- User Management
- Schema Authorizations
- Object Privileges
- Privilege Analysis
- Grant and Revoke of Privileges
- Resource limits via profile
- Password Management
- Password Verify Function
- Set roles
- Auditing
- Auditing overview
- Audit_Trail
- Configurate Auditing
- Evaluate Audit_Trail
- Unified Auditing
- Create an Audit Policy
- Datapump
- Direcories
- SQL-Loader overview
- Metadata
- Datapump architecture
- Export
- Import
- Datapump Job
- Datapump Dictionary Views
- Simultaneous database accesses
- Locks
- Check Locks
- Blocker
- Lock/Deadlock
- Backup and Recovery
- Backup and Recovery Strategies overview
- Flashback overview (Flashback Database, Recyclebin and Flashback Table)
- RMAN
- REDO
- SMON/PMON
- Archive log/Noarchivelog
- Fast recovery area
- Instance Recovery
Theory and practical exercises as well as system demonstrations.
This workshop is aimed at (future) database administrators as well as database developers and system administrators who take over activities in the DBA area.
You have SQL knowledge to the extent of the following course: