Oracle Database: Administration Workshop Ed 1


Prezzo Emagister

1.950 € 2.785 € +IVA
  • Tipologia

    Seminario intensivo

  • Metodologia


  • Ore di lezione



Describe Oracle Database architecture

Explain Oracle Database Cloud Service (DBCS) architecture and features

Create and manage DBCS database deployments

Configure the database to support your applications

Manage database security and implement auditing

Implement basic backup and recovery procedures

Move data between databases and files

Employ basic monitoring procedures and manage performance

Modern Features, open standards, high availability, high performance, scale, security and ease of maintenance/management are the reasons why the Oracle Database is the #1 choice of the Fortune 1000. Whether you manage your data in your own data center on premises, manage your data in a hybrid or pure cloud configuration, or even run a large data management cloud service, the Oracle Database was designed to deliver the performance and features your organization requires.

This course begins with a discussion of the broad systems infrastructure where one finds Oracle database installations, and we outline how the database fits with other systems in a multi?tiered architecture, including web servers, application servers and engineered systems such as the Oracle Exadata database computing platform. We then explore the intricacies of a single database installation, including memory, process and storage structures. Periodically we delve into the internals of the database, probing into such areas internal Locking mechanisms, kernel module calls and database failures.

Whether you are a Database Architect, Developer, Administrator, or a Data Scientist, Oracle University partners with experts from product development, consulting and even our own customers to deliver a full set of curriculum to help you leverage all that the Oracle Database can do for you. See the categories below to help you get started.

Informazioni importanti

Prezzo per gli utenti Emagister: Sconto del 30% valido solo se ci sono minimo 3 iscritti






06 lug 2020Iscrizioni aperte
26 ott 2020Iscrizioni aperte

Da tener presente

A working knowledge of SQL and PL/SQL packages is very helpful in the course. Basic knowledge of Linux operating system

Domande e risposte

Comunicaci i tuoi dubbi,altri utenti potranno risponderti

Chi vuoi che ti risponda?

Pubblicheremo solo il tuo nome e la domanda

Successi del Centro


Tutti i corsi devono essere aggiornati

La media delle valutazioni dev'essere superiore a 3,7

Più di 50 opinioni degli ultimi 12 mesi

2 anni del centro in Emagister.

Cosa impari in questo corso?

  • Security
  • Office
  • SQL
  • Programmazione
  • Management
  • Database
  • Computer
  • Cloud
  • Oracle
  • Programming
  • Automation
  • Oracle database
  • Database memory
  • Programmazione oracle
  • DBCS
  • Configurare office
  • Connections
  • Storage cloud
  • Physical data
  • Stuctures connecting
  • Instace logical
  • Database
  • Instace logical


Corpo  Docente PCS

Corpo Docente PCS

Docente Senior (min. 5 anni)


Sample HR SchemaOracle Cloud OverviewOracle Database Editions, Options, and Management Packs
Oracle Database Architecture
Automatic Storage Management (ASM) OverviewOracle Database Instance ConfigurationsOracle Database Memory and Process StructuresConnecting to the Database InstanceLogical and Physical Database StructuresMultitenant ArchitectureOracle Database Server Architecture
Introdction to Oracle Database Cloud
Automated Database ProvisioningOracle Database Cloud Service ArchitectureFeatures and Tooling
Creating Oracle Database Cloud Service (DBCS) Deployments
SSH Key PairsDatabase File StorageInput to the Creation Wizard
Accessing an Oracle Database
Oracle Database Cloud Service ToolsDatabase Configuration Assistant (DBCA)Oracle Enterprise Manager Cloud ControlOracle enterprise Manager Database ExpressSQL DeveloperSQL*Plus
Managing DBCS Database Deployments
Managing Network Access to DBCSManaging the Compute NodeScaling a Database DeploymentPatching a Database Deployment
Managing Database Instances
Starting Up Oracle Database InstancesData Dictionary ViewsShutting Down Oracle Database InstancesDynamic Performance ViewsAutomatic Diagnostic Repository (ADR)Alert Log and Trace FilesInitialization Parameter Files
Oracle Net Services
Oracle Net Services Administration ToolsConfiguring Communication Between Database InstancesOracle Net Listener OverviewConnecting to an Oracle Database InstanceComparing Dedicated and Shared Server ConfigurationsNaming Methods
Administering User Security
Assigning Quotas to UsersApplying the Principal of Least PrivilegeManaging Oracle Cloud Users, Privileges, and RolesCreating and Assigning ProfilesUser AuthenticationManaging Oracle Database Users, Privileges, and Roles
Creating PDBs
Dropping PDBsCloning PDBsMethods and Tools to Create PDBsCreating PDBs from SeedUnplugging and Plugging in PDBs
Creating Master Encryption Keys for PDBs
Overview of Transparent Data Encryption (TDE)Creating and Activating an Encryption KeyCDB and PDB Master Encryption KeysEncryption in Oracle Database Cloud Service
Creating and Managing Tablespaces
Viewing Tablespace InformationCreating, Altering and Dropping TablespacesTable Data StorageTablespace Encryption by Default in DBCSImplementing Oracle Managed FilesMoving and Renaming Online Data Files
Managing Storage Space
Resumable Space AllocationShrinkable SegmentsDeferred Segment CreationSpace-Saving FeaturesOracle Database Space Management FeaturesTypes of SegmentsTable and Row CompressionBlock Space Management
Managing Undo Data
Comparing Local Undo Mode and Shared Undo ModeTransactions and Undo DataStoring Undo InformationConfiguring Undo RententionComparing Undo Data and Redo DataTemporary Undo
Moving Data
External TablesOracle Data PumpMigrating to Oracle Database Cloud ServiceSQL*Loader
Backup and Recovery Concepts
Point-in-time RecoveryComplete RecoveryCategories of FailureFlashback TechnologyInstance Recovery
Backup and Recovery Configuration
Configuring ARCHIVELOG ModeConfiguring and Monitoring the Fast Recovery AreaMultiplexing Control FilesMultiplexing Redo Log FilesArchive Redo Log Files
Creating Database Backups
RMAN Backup TypesOn-Demand Backups on DBCSUsing Recovery Manager (RMAN)Backup TerminologyAutomatic Backups on Database Cloud Service (DBCS)
Performing Database Recovery
Database Recovery AdvisorRecovering Data Files in ARCHIVELOG ModeRecovering Data Files in NOARCHELOG ModeRecovery Options in Database Cloud Service (DBCS)
Monitoring and Tuning Database Performance
Managing Memory ComponentsAutomatic Workload Repository (AWR)Advisory FrameworkMonitoring Wait Events, Sessions, and ServicesManaging Metric Thresholds and AlertsPerformance Tuning MethodologyPerformance Planning ConsiderationsAutomatic Database Diagnostic Monitor (ADDM)
SQL Tuning
Oracle OptimizerSQL Tuning AdvisorSQL Performance AnalyzerOptimizer StatisticsSQL Access AdvisorSQL Tuning Process

Ulteriori informazioni


Il Materiale Didattico è compreso nel prezzo sia per i corsi a Calendario che Dedicati.

Prezzo manuale: incluso nel prezzo del corso

Natura del corso: Operativo (previsti lab su PC)

Prezzo Emagister

1.950 € 2.785 € +IVA

Chiama il centro

per ricevere informazioni sul corso

Parla con un consulente

per ricevere informazioni sul corso