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)
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