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
Server architecture Oracle
- Main database and instance components
- Memory structures
- Secondary processes
- Logical and physical data storage structures
- Container bases
Working environment with RDBMS Oracle
- Tools
- Built-in administrative users
- Connection to container bases
- System monitoring via system dictionary
Instance management
- Initialization parameters
- Lifting and placing instances
- Opening and closing containers
- Querying dynamic views
Network environment
- Listener work
- Dynamic and static website registration
- Local naming
- Databaselinks
- Work in dedicated and shared server mode
Security
- User management
- Permission management
- Role management
- Profiles and Quotations
Data space management
- Tablespaces
- Data files
- Segments, Extensions, Blocks
Container management
- Creating, deleting, moving, disconnecting, cloning a container database
Withdrawal space management
- Transactional
- Flashback
- UNDO space configuration
- Retention configuration
Data migration
- Oracle Data Pump
- Export and Import tools
- SQL Loader
- External Tables
Backup and Restore
- Recovering from an instance failure
- Log files
- Archived log files and archivelog mode
- Control files
- Cold and hot backup
- Incremental and full backups
- Using RMAN
- File crash recovery
Requirements
...
21 Hours
Testimonials (6)
wiedza i przekłady
Jan Maksymowski
Course - Oracle 11g - Język SQL dla administratorów - warsztaty
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
The way trainer demonstrated everything
Manveen - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
Trainer expertise on SQL tuning
Bogdan - DB Global Technology
Course - Oracle 11g - Application Tuning - Workshop
Help Chops
Aarón Fernández Rodríguez - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated