Oracle 11g - Administracja - warsztaty

• General IT knowledge
• Knowledge of language SQL in the field of data extraction and manipulation (completion of training Oracle 11g - Language SQL for administrators - workshops )

For whom

The workshops are intended for future administrators of databases and applications based on Oracle, whose duties will include supervision and ongoing maintenance of database systems and applications based on databases Oracle.

Exams and certificates

The training plan partially overlaps with the material required to pass the 1Z0-052 Oracle Database 11g: Administration I exam, which allows you to obtain the Oracle Database 11g Administrator Certified Associate certificate

Training goal

The workshops are intended to familiarize participants with the necessary knowledge and thoroughly practice all issues that database application administrators encounter during ongoing maintenance and maintenance of systems.

Training content

• Installation and configuration of the database
• Familiarization with the system architecture
• Ongoing maintenance of database systems
• Administration of users and permissions
• Data structure management
• Security and performance monitoring

Comments

The workshops are based on software version 11g XE

Architecture of the Relational Database Management System Oracle

• Differences in XE, SE, EE distributions
• Software Installation
• Setting up a database

Database instance management

• Memory structures and secondary processes
• System Dictionary
• Parameter management
• Alert log
• Data files, redo log files, control files
• Closing and resuming instances

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

UNDO transaction and space management

• Transactional modes
• Monitoring and resolving blockages
• UNDO space
• Selection of undo_retention and flashback mechanisms

Network configuration

• Configuration and control of the Listener process
• Work in dedicated and shared server mode

Data storage management – logical layer

• Tables, Temporary tables, Tables organized by index
• Limitations
• Indexes
• Views, sequences, synonyms, materialized views
• Packages, procedures, functions, types, triggers

Data transfer

• A physical copy of your data
• Logical copy of data – datapump import and export
• data loading – sqlLoader
• Outdoor boards
• Database links

Task automation

• dbms_jobs, dbms_scheduler

Statistics and cost optimization

• Monitoring current process activity and diagnosing bottlenecks
• Working with the optimizer, setting an optimization goal, query plan
• Collecting object and system statistics