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)
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
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
Trainer expertise on SQL tuning