Plan Szkolenia
Introduction
- Introduction to Oracle Cloud
- Overview of Oracle Database 21c
Oracle Database Architecture
- Overview of the Oracle Database architecture
- Configuring and connecting to the Oracle Database Instance
- Understanding the Oracle Database memory structures
- Process architecture and structures
- Process startup sequence
- Storage architecture
Database Instance
- Overview of the Oracle Database management tools
- Enterprise manager management framework
Setting Up the Oracle Network Environment
- Overview of the Oracle Net Services and Oracle Net Listener
- Oracle Network Connections
- Configuring the Oracle Network tools
- Listener Control Utility
- Oracle Net configuration assistant
- Oracle Net Manager
- Enterprise Manager Cloud Control
Database Storage Structures
- Overview of Database Block Content
- Storage structure
- Creating and managing Tablespaces
- Navigating and viewing Tablespace information
- Using Oracle managed files
User Security
- Managing database user accounts
- Predefined administrative accounts
- Creating a user account
- Authentication and password reset
- Understanding the concept of privileges, roles, and profiles
Data Concurrency
- Understanding the locking mechanism
- Understanding data concurrency
- DML locks
- Enqueue mechanism
- Lock conflicts
Undo Data
- Overview of Undo data
- Managing transactions and storing Undo information
- Undo data vs. Redo data
- Configuring and guaranteeing Undo retention
- Changing the size of an Undo Tablespace
Oracle Database Auditing
- Overview of database auditing
- Database security and compliance monitoring
- Standard database auditing
- Audit administration
- Configuring audit train
- Audit options
Database Maintenance
- Overview of database maintenance
- Alert history
- Automatic Database Diagnostic Monitoring (ADDM)
- Understanding the advisory framework
- Enterprise manager and advisor
Managing Performance and Resources
- Monitoring performance
- Tuning activities and performance planning
- Instance tuning
- Performance tuning methodology and data
- Managing memory
- Overview of Database Resource Manager
- Using the Database Resource Manager
- Maintenance Resource Manager plan
- Resource Manager workflow
- Resource allocation methods
Space Management
- Block space management
- Chaining and migration
- Understanding the types of segments
- Allocating extents and space
- Creating tables without segments
Backup and Recovery
- Overview of Instance Recovery
- Understanding and configuring Instance Recovery
- Instance Recovery Phases
- Using MTTR Advisor
- Understanding Media Failure
Summary and Next Steps
Wymagania
- Basic Linux and SQL knowledge
Audience
- Database administrators and developers
- Cloud database architects
- Application developers
Opinie uczestników (7)
wiedza i przekłady
Jan Maksymowski
Szkolenie - Oracle 11g - Język SQL dla administratorów - warsztaty
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
Szkolenie - 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
Szkolenie - Oracle 11g - Programowanie w PL/SQL I - warsztaty
Sposób tłumaczenia materiału oraz pokazane przykłady.
Marek Jakimowicz
Szkolenie - Tuning SQL i PL/SQL dla programistów
Podobało mi się to szkolenie, ponieważ było interaktywne
Amalia - Banca Transilvania
Szkolenie - SQL Fundamentals
Przetłumaczone przez sztuczną inteligencję
Ekspertyza trenera dotycząca tuningu SQL
Bogdan - DB Global Technology
Szkolenie - Oracle 11g - Application Tuning - Workshop
Przetłumaczone przez sztuczną inteligencję
it was very well organized