>> ORACLE Database - EGOS
1
EGOS! PDF MVC Content Application Framework v7.1.21.1202. ©EGOS! The Education Company, Alle Rechte vorbehalten. Created on 04.02.2022 11:27:30. ID8048. ORACLE Database Administration Workshop >> ORACLE Database Administration Workshop Oracle 12c ist eine Datenbank, die für Grid-Computing konzipiert ist. Neben Enterprise-Class Features wir Clustering, Skalierbarkeit und Hochverfügbarkeit sind intelligente Optimierungsfunktionen ein wichtiger Aspekt. Ihr Nutzen Nach dem Seminar verstehen Sie die Konzepte der Oracle Datenbank und können Datenbankinstanzen installieren, konfigurierung und warten. In diesem Intensivworkshop werden die Inhalte intensiv und komprimiert vermittelt. Voraussetzungen Seminar ORACLE Introduction to SQL~143 oder praktische Erfahrung mit SQL Hinweise D79027, Dieses Seminar wird mit einem zertifizierten Trainingspartner durch geführt und dient somit auch als Vorbereitung für Ihre Zertifizierung. Version: 19c Preis pro Teilnehmer EUR 3555,- exklusive der gesetzlichen MwSt. Seminardauer 5 Tag(e)/Day(s) Seminarinhalte 1. Tag * Oracle Database 12c Overview - Introduction & Architecture - Instance Configurations, Memory Structures, Process Structures - Database Storage Architecture - Logical and Physical Database Structures - Container and Pluggable Database Overview * Installing Oracle Grid Infrastructure for a Standalone Server - Grid Infrastructure for a Standalone Server - Configuring Storage for Automatic Storage Management (ASM) - Installing Grid Infrastructure for a Standalone Server * Installing Oracle Database Software - Planning Your Installation, System Requirements - Using 4 KB Sector Disks - Setting Environment Variables * Creating an Oracle Database by Using DBCA - Planning the Database Storage Structure - non-CDB or CDB, Types of Databases (based on workload) - Choosing the Appropriate Character Set - Using the Database Configuration Assistant (DBCA) * Using Oracle Restart - Overview & Process startup - Controlling Oracle Restart - Oracle Restart Configuration - Using the SRVCTL Utility 2. Tag * Introduction to Upgrading to Oracle Database 12c - Upgrade Methods, Data Migration Methods - Overview of Upgrade Process - Performing a Rolling Upgrade, Upgrading a CBD * Preparing to Upgrade to Oracle Database 12c - Developing a Test Plan, Performance Testing - Using the Pre-Upgrade Information Tool - Backing Up the Database - Installing the Oracle Database 12c Software - Preparing the New Oracle Home * Upgrading to Oracle Database 12c - Upgrading by Using the Database Upgrade Assistant (DBUA) * Migrating Data by Using Oracle Data Pump - Data Pump Overview - Migrating by Using Data Pump - Importing by Using a Network Link 3. Tag * Exploring the Oracle Database Architecture - Architecture Overview - Instance Configurations, Memory Structures - Process Architecture, Process Structures - Database Storage Architecture * Managing the Database Instance - Understanding the Enterprise Manager Management Framework - Logging in to Oracle Enterprise Manager Database Express - Using the Enterprise Manager Database Express Home Page - Using Enterprise Manager Cloud Control - Using SQL*Plus and SQL Developer - Initialization Parameter Files * Configuring the Oracle Network Environment - Oracle Net Services and Net Listener - Listener Control Utility, Assistant and Manager - Enterprise Manager Cloud Control * Managing Database Storage Structures - Database Block Contents - Exploring the Storage Structure - Creating and Managing Tablespaces 4. Tag * Administering User Security - Database User Accounts, Administrative Accounts - Authentication, Privileges, Roles, Profiles * Managing Data Concurrency - Locking Mechanism, Data Concurrency - DML Locks, Enqueue Mechanism, Lock Conflicts * Managing Undo Data - Transactions and Undo Data - Storing Undo Information - Comparing Undo Data and Redo Data - Configuring Undo Retention * Implementing Oracle Database Auditing - Separation of Responsibilities, Database Security - Monitoring for Compliance, Standard Database Auditing - Unified Audit Data Trail * Performing Database Maintenance - Database Maintenance - Viewing the Alert History - Automatic Workload Repository (AWR) - Automatic Database Diagnostic Monitor (ADDM) - Advisory Framework, Enterprise Manager and Advisors 5. Tag * Managing Performance - Performance Monitoring - Tuning Activities, Performance Planning - Instance Tuning, Monitoring Performance, Managing Memory Unsere BildungsberaterInnen stehen Ihnen gerne zur Verfügung. Innsbruck +43 (0)512 36 47 77, Salzburg +43(0)662 45 01 74. © 2022 EGOS! The Education Company, Alle Rechte vorbehalten. Irrtümer und Druckfehler vorbehalten. Seite Lernen und Entwickeln www.egos.co.at
Transcript of >> ORACLE Database - EGOS
EG
OS
! PD
F M
VC
Con
tent
App
licat
ion
Fra
mew
ork
v7.1
.21.
1202
. ©E
GO
S! T
he E
duca
tion
Com
pany
, Alle
Rec
hte
vorb
ehal
ten.
Cre
ated
on
04.0
2.20
22 1
1:27
:30.
ID80
48. O
RA
CLE
Dat
abas
e A
dmin
istr
atio
n W
orks
hop
>> ORACLE DatabaseAdministration Workshop
Oracle 12c ist eine Datenbank, die für Grid-Computing konzipiert ist. Neben Enterprise-ClassFeatures wir Clustering, Skalierbarkeit und Hochverfügbarkeit sind intelligenteOptimierungsfunktionen ein wichtiger Aspekt.
Ihr Nutzen
Nach dem Seminar verstehen Sie die Konzepte der OracleDatenbank und können Datenbankinstanzen installieren,konfigurierung und warten. In diesem Intensivworkshop werdendie Inhalte intensiv und komprimiert vermittelt.
Voraussetzungen
Seminar ORACLE Introduction to SQL~143 oder praktischeErfahrung mit SQL
Hinweise
D79027,Dieses Seminar wird mit einem zertifizierten Trainingspartnerdurch geführt und dient somit auch als Vorbereitung für IhreZertifizierung.
Version: 19c
Preis pro Teilnehmer
EUR 3555,- exklusive der gesetzlichen MwSt.
Seminardauer
5 Tag(e)/Day(s)
Seminarinhalte1. Tag* Oracle Database 12c Overview- Introduction & Architecture- Instance Configurations, Memory Structures, Process Structures- Database Storage Architecture- Logical and Physical Database Structures- Container and Pluggable Database Overview* Installing Oracle Grid Infrastructure for a Standalone Server- Grid Infrastructure for a Standalone Server- Configuring Storage for Automatic Storage Management (ASM)- Installing Grid Infrastructure for a Standalone Server* Installing Oracle Database Software- Planning Your Installation, System Requirements- Using 4 KB Sector Disks- Setting Environment Variables* Creating an Oracle Database by Using DBCA- Planning the Database Storage Structure- non-CDB or CDB, Types of Databases (based on workload)- Choosing the Appropriate Character Set- Using the Database Configuration Assistant (DBCA)* Using Oracle Restart- Overview & Process startup- Controlling Oracle Restart- Oracle Restart Configuration- Using the SRVCTL Utility
2. Tag* Introduction to Upgrading to Oracle Database 12c- Upgrade Methods, Data Migration Methods- Overview of Upgrade Process- Performing a Rolling Upgrade, Upgrading a CBD* Preparing to Upgrade to Oracle Database 12c- Developing a Test Plan, Performance Testing- Using the Pre-Upgrade Information Tool- Backing Up the Database- Installing the Oracle Database 12c Software- Preparing the New Oracle Home* Upgrading to Oracle Database 12c- Upgrading by Using the Database Upgrade Assistant (DBUA)* Migrating Data by Using Oracle Data Pump- Data Pump Overview- Migrating by Using Data Pump- Importing by Using a Network Link
3. Tag* Exploring the Oracle Database Architecture- Architecture Overview- Instance Configurations, Memory Structures- Process Architecture, Process Structures- Database Storage Architecture* Managing the Database Instance- Understanding the Enterprise Manager Management Framework- Logging in to Oracle Enterprise Manager Database Express- Using the Enterprise Manager Database Express Home Page- Using Enterprise Manager Cloud Control- Using SQL*Plus and SQL Developer- Initialization Parameter Files* Configuring the Oracle Network Environment- Oracle Net Services and Net Listener- Listener Control Utility, Assistant and Manager- Enterprise Manager Cloud Control* Managing Database Storage Structures- Database Block Contents- Exploring the Storage Structure- Creating and Managing Tablespaces
4. Tag* Administering User Security- Database User Accounts, Administrative Accounts- Authentication, Privileges, Roles, Profiles* Managing Data Concurrency- Locking Mechanism, Data Concurrency- DML Locks, Enqueue Mechanism, Lock Conflicts* Managing Undo Data- Transactions and Undo Data- Storing Undo Information- Comparing Undo Data and Redo Data- Configuring Undo Retention* Implementing Oracle Database Auditing- Separation of Responsibilities, Database Security- Monitoring for Compliance, Standard Database Auditing- Unified Audit Data Trail* Performing Database Maintenance- Database Maintenance- Viewing the Alert History- Automatic Workload Repository (AWR)- Automatic Database Diagnostic Monitor (ADDM)- Advisory Framework, Enterprise Manager and Advisors
5. Tag* Managing Performance- Performance Monitoring- Tuning Activities, Performance Planning- Instance Tuning, Monitoring Performance, Managing MemoryUnsere BildungsberaterInnen stehen Ihnen gerne zur Verfügung. Innsbruck +43 (0)512 36 47 77, Salzburg +43(0)662 45 01 74.
© 2022 EGOS! The Education Company, Alle Rechte vorbehalten. Irrtümer und Druckfehler vorbehalten. Seite
Lernen und Entwickeln www.egos.co.at
