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
Relational Database Management System Architecture Oracle
- Differences in XE, SE, EE distributions. Installing the Software. Setting up a database
Database instance management
- Memory Structures and Background Processes System Glossary Parameter Management Alert Log Data Files, Redo Log Files, Control Files Instance Shutdown and Raise
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
Transaction and UNDO space management
- Transaction modes Lock monitoring and resolution UNDO space Selection of undo_retention and flashback mechanisms
Network configuration
- Configuration and control of the Listener process Work in dedicated and shared servers mode
Data storage management - logical layer
- Tables, Temporary Tables, Index-Organized Tables Limitations Indexes Views, Sequences, Synonyms, Materialized Views Packages, Procedures, Functions, Types, Triggers
Data portability
- Physical copy of data Logical copy of data – datapump import and export data loading – sqlLoader External tables Database links
Task automation
- dbms_jobs, dbms_scheduler
Statistics and cost optimization
- Monitoring the current activity of processes 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 the Oracle 11g training - Language SQL for administrators - workshops)
35 Hours
Testimonials (5)
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
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