Oracle Database 19c Administration - 5 days online classroom
3.850,00 EUR
- 5 days
Master the essential skills required to administer and support Oracle Database 19c environments with this hands-on Oracle Database 19c Administration course. Designed for database administrators and IT professionals, the course provides practical experience in configuring, managing, securing, monitoring, and maintaining Oracle databases in real-world enterprise environments.
Key Features
Language
Course material in English
Level
Beginner - Intermediate level
5 days of live instructor-led
Virtual training (8 hours / day)
Interactive hands-on live labs
All relevant course materials
60+ recommended study hours
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Oracle Database Administration Fundamentals
Develop the skills to manage and maintain Oracle Database 19c environments, including database architecture, storage management, user administration, and data security.
Oracle Network Configuration
Learn how to configure Oracle Net Services, manage listeners and naming methods, and troubleshoot connectivity using tools such as TNSPING and Net Manager to ensure reliable database access.
User & Privilege Management
Gain practical experience creating users, managing authentication, assigning roles, and controlling privileges while maintaining secure and compliant Oracle database environments
Job Scheduling & Automation
Use Oracle Scheduler to automate administrative tasks such as backups, reporting, and maintenance jobs through time-based and event-driven scheduling for improved operational efficiency.
Course timeline
Day 1
Session 1: Introduction to Oracle Database
- Oracle database and relational concepts
- Oracle architecture and multitenant environment
- Overview of Data Guard, RAC, ASM, and Oracle Cloud
- Core database administration tasks
Session 2: Oracle Database Architecture
- Oracle instance and architecture components
- Memory and process structures
- Client/server processes
- Storage architecture and database connections
Session 3: Administering a Database Instance
- DBA administration tools
- Managing databases with SQL*Plus, SQL Developer, and Enterprise Manager
- Enterprise Manager framework and Database Express
- Initialization parameter files
Session 4: Configuring the Oracle Network Environment
- Oracle networking fundamentals
- Listener configuration and management
- Net naming methods and connectivity tools
- Configuring connections with Net Manager and Enterprise Manager
- Using TNSPING and managing Oracle Net services
Session 5: Storage Structures
- Database storage concepts and blocks
- Tablespaces and datafiles
- Managing storage with Enterprise Manager
- Creating, altering, and dropping tablespaces and datafiles
- Temporary tablespaces and Oracle Managed Files (OMF)
Day 2
Session 6: Managing Users
- Database administration accounts
- Creating and managing user accounts
- User authentication and password management
- Monitoring users and terminating sessions
- Schema-only accounts
Session 7: Managing Privileges
- Database access control
- System and object privileges
- Grant and revoke commands
- Creating and managing roles
- Using predefined Oracle roles
Session 8: Managing Profiles & Resources
- User profiles and resource parameters
- Creating and maintaining profiles
- Password and resource management
Session 9: Database Auditing
- Database security and auditing concepts
- Standard auditing and unified audit trails
- AUDIT_ADMIN and AUDIT_VIEWER roles
- Configuring audit trails and audit options
Day 3
Session 10: Data Concurrency & Lock Conflicts
- Oracle locking and concurrency control
- DML locks and contention issues
- Detecting and resolving lock conflicts
- Preventing locking problems
Session 11: Undo Management
- Undo data and tablespaces
- Configuring undo retention
- Monitoring and sizing undo space
- Flashback query retention and Undo Advisor
Session 12: Backup & Recovery Configuration
- Oracle backup and recovery concepts
- Flashback technology and recovery methods
- Instance and media recovery
- Configuring database recoverability and MTTR
Session 13: Proactive Database Maintenance
- Database monitoring and maintenance
- Alert logs and Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Advisors and notification rules
Session 14: Performance Management
- Performance monitoring and tuning
- Tuning methodologies and planning
- Memory management and instance tuning
- Managing private temporary tables
Day 4
Session 15: SQL Tuning
- SQL performance tuning
- Oracle Optimizer and execution plans
- SQL Advisors and tuning recommendations
- SQL Tuning Advisor and statement management
Session 16: Moving Data
- Data Pump export and import
- Directory objects and Data Pump architecture
- SQL Loader fundamentals
- Record filtering and control files
- External tables and data loading methods
Session 17: Managing Resources with Resource Manager
- Database Resource Manager overview
- Creating resource plans and directives
- Resource allocation and maintenance plans
Session 18: Automating Tasks with the Scheduler
- Oracle Scheduler fundamentals
- Scheduler workflow and access rights
- Creating jobs and job classes
- Time-based and event-based scheduling
Day 5
Session 19: Managing Space
- Space management concepts
- Segment and extent management
- Space allocation techniques
- Row chaining and migration
- Creating tables without segments
Session 20: Oracle Support
- Enterprise Manager Support Workbench
- Oracle Support and security updates
- My Oracle Support integration
- Managing service requests and patches
- Applying database patches
Who Should Enroll in this Program?
Oracle Database Administrators (DBAs)
IT infrastructure and operations professionals
Database support engineers and system administrators
Technical professionals managing Oracle environments
Professionals preparing for Oracle DBA responsibilities
Teams responsible for database performance
Prerequisites
- Basic understanding of relational database concepts
- Familiarity with Oracle SQL and database querying
- Basic Linux or command-line experience is beneficial
- Previous exposure to PL/SQL or Oracle environments is helpful but not mandatory
- Completion of an Oracle SQL course or equivalent experience is recommended
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!