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 (1)
Łukasz's way of leading
Damian - Sygnity
Course - Oracle SQL - advanced
Machine Translated
