Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Architecture of the Relational Database Management System Oracle
- Differences in XE, SE, EE distributions
- Software Installation
- Setting up a database
Database instance management
- Memory structures and secondary processes
- System Dictionary
- Parameter management
- Alert log
- Data files, redo log files, control files
- Closing and resuming instances
Data storage management – physical layer
- Data files
- Tablespaces
- Segments, extents
- Blocks
User management
- Creating and modifying users
- Permissions and roles
- Profiles
- Monitoring user sessions
- Audit
UNDO transaction and space management
- Transactional modes
- Monitoring and resolving blockages
- UNDO space
- Selection of undo_retention and flashback mechanisms
Network configuration
- Configuration and control of the Listener process
- Work in dedicated and shared server mode
Data storage management – logical layer
- Tables, Temporary tables, Tables organized by index
- Limitations
- Indexes
- Views, sequences, synonyms, materialized views
- Packages, procedures, functions, types, triggers
Data transfer
- A physical copy of your data
- Logical copy of data – datapump import and export
- data loading – sqlLoader
- Outdoor boards
- Database links
Task automation
- dbms_jobs, dbms_scheduler
Statistics and cost optimization
- Monitoring current process activity and diagnosing bottlenecks
- Working with the optimizer, setting an optimization goal, query plan
- Collecting object and system statistics
Requirements
- General IT knowledge
- Knowledge of language SQL in the field of data extraction and manipulation (completion of training Oracle 11g - Language SQL for administrators - workshops )
35 Hours
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
The way trainer demonstrated everything
Manveen - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
