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
...
Testimonials (7)
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
Method of translating the material and examples shown.
Marek Jakimowicz
Course - Tuning SQL i PL/SQL dla programistów
Machine Translated
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Trainer expertise on SQL tuning
Bogdan - DB Global Technology
Course - Oracle 11g - Application Tuning - Workshop
it was very well organized