• Skip to primary navigation
  • Skip to content
  • Skip to footer
 AREA RISERVATA
 800-177596
 CHI SIAMO
 CONTATTACI
 AREA RISERVATA
 CONTATTACI
 800-177596

Vega Training

Vega Training

Formazione Certificata Ovunque

  • Corsi
  • Corsi per Tecnologia
  • Corsi per Vendor
    • Amazon AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud
    • VMware
    • CompTIA
    • Cisco
    • Check Point
    • Fortinet
    • Huawei
  • Certificazioni
  • Calendario

Certificazione Oracle Database Administration OCP I

Vega Training, Corsi e Certificazioni

Certificazione Oracle Database Administration OCP I

Panoramica | Svolgimento e Durata | Prerequisiti
Argomenti D’esame   |  Corsi Propedeutici

Panoramica   Svolgimento e Durata
Prerequisiti
Argomenti D’esame    Corsi Propedeutici

PANORAMICA

Oracle Database Administration 2019 Certified Professional certification, Esame 1Z0-082, Esame 1Z0-083, Oracle Database Administration

Esame Oracle 1Z0-082;

Le certificazioni Oracle sono le più richieste dal Mondo IT nell’ambito Database. In generale questa certificazione risulta essere tra le prime 5 più ricercate dal mondo del Lavoro IT e costituisce senza nessun dubbio un elemento accreditante per ogni professionista che voglia operare nel campo dei DBA ad ogni livello. L’ottenimento di una Oracle Database Administration I attraverso l’Esame 1Z0-082 costituisce il primo step per ottenere La Certificazione Oracle Database Administration 2019 Certified Professional Certification OCP. L’ottenimento di tale certificazione permette di convalidare le competenze relative ad tutte le attività fondamentali per un Oracle DBA: installazione, configurazione, gestione dei processi e delle memorie in ottica performance ed availability 24/7, gestione accurata dei datafile che compongono il database, gestione della sicurezza e del backup e recovery dei dati, alta disponibilità e zero data-loss.

Certificazione Oracle Database Administration I
Parte della Certificazione Oracle Database Administration 2019 Certified Professional certification OCP
Esame Oracle 1Z0-082;

Corsi propedeutici alla certificazione

CORSI PROPEDEUTICI
Affrontare un esame di certificazione richiede una preparazione specifica.
Per questa certificazione consigliamo:

Corso Oracle Database Administration OCP I

 SVOLGIMENTO E DURATA

Esame 1Z0-082 Oracle durata 150 minuti 90 quesiti;

Negli esami sono presenti quesiti formulati in lingua inglese in forme differenti: Risposta Multipla; completamento di testo, collegamenti concettuali Drag and Drop; vere e proprie simulazioni laboratoriali.

 PREREQUISITI

Nessun prerequisito.

ARGOMENTI D’ESAME

Esame Oracle 1Z0-082 – Parte SQL

  • Retrieving Data using the SQL SELECT
  • Statement
  • Column aliases
  • Use of the DESCRIBE command
  • Capabilities of the SELECT statement
  • Use of concatenation operator, literal character
  • strings, alternative quote operator, and the DISTINCT
  • keyword
  • Arithmetic expressions and NULL values in the
  • SELECT statement
  • Restricting and Sorting Data
  • Rules of precedence for operators in an expression
  • Limiting the Rows
  • Substitution Variables
  • Using the DEFINE and VERIFY command
  • Using Single-Row Functions to Customize
  • Output
  • Manipulate strings with character function in the
  • SELECT and WHERE clauses
  • Perform arithmetic with date data
  • Manipulate numbers with the ROUND, TRUNC and
  • MOD functions
  • Manipulate dates with the date functions
  • Using Conversion Functions and Conditional
  • Expressions
  • Apply the NVL, NULLIF, and COALESCE functions to
  • data
  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE
  • conversion functions
  • Nest multiple functions
  • Reporting Aggregated Data Using Group
  • Functions
  • Restricting Group Results
  • Creating Groups of Data
  • Group Functions
  • Displaying Data from Multiple Tables Using
  • Joins
  • Self-join
  • Types of Joins
  • Non equijoins
  • OUTER join
  • Using Subqueries to Solve Queries
  • Single Row Subqueries
  • Multiple Row Subqueries
  • Using SET Operators
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations
  • INTERSECT operator
  • MINUS operator
  • UNION and UNION ALL operator
  • Managing Tables using DML statements
  • Database Transactions
  • Data Manipulation Language
  • Control transactions
  • Introduction to Data Definition Language
  • Data Definition Language
  • Creating Sequences, Synonyms, Indexes
  • Overview of indexes
  • Overview of synonyms
  • Overview of sequences
  • Creating Views
  • Overview of views
  • Managing Schema Objects
  • Creating and using temporary tables
  • Managing constraints
  • Managing Data in Different Time Zones
  • Working with CURRENT_DATE,
  • CURRENT_TIMESTAMP and LOCALTIMESTAMP
  • Working with INTERVAL data types

Esame Oracle 1Z0-082 – Parte Amministrazione

  • Oracle Database Architecture
  • Oracle Database Instance Configurations
  • Oracle Database Memory and Process Structures
  • Logical and Physical Database Structures
  • Oracle Database Server Architecture
  • Access an Oracle Database with Oracle supplied
  • Tools
  • Database Configuration Assistant (DBCA)
  • Oracle Enterprise Manager Cloud Control
  • Oracle enterprise Manager Database Express
  • SQL Developer
  • SQL Plus
  • Managing Database Instances
  • Starting Up Oracle Database Instances
  • Data Dictionary Views
  • Shutting Down Oracle Database Instances
  • Dynamic Performance Views
  • Automatic Diagnostic Repository (ADR)
  • Alert Log and Trace Files
  • Initialization Parameter Files
  • Oracle Net Services
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database
  • Instances
  • Oracle Net Listener Overview
  • Connecting to an Oracle Database Instance
  • Comparing Dedicated and Shared Server
  • Configurations
  • Naming Methods
  • Managing Users, Roles and Privileges
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • Creating and Assigning Profiles
  • User Authentication
  • Managing Oracle Database Users, Privileges, and Roles
  • Managing Tablespaces and Datafiles
  • Viewing Tablespace Information
  • Creating, Altering and Dropping Tablespaces
  • Table Data Storage
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files
  • Managing Storage
  • Resumable Space Allocation
  • Shrinkable Segments
  • Deferred Segment Creation
  • Space-Saving Features
  • Oracle Database Space Management Features
  • Types of Segments
  • Table and Row Compression
  • Block Space Management
  • Managing Undo
  • Transactions and Undo Data
  • Storing Undo Information
  • Configuring Undo Rentention
  • Comparing Undo Data and Redo Data
  • Temporary Undo
  • Moving Data
  • External Tables
  • Oracle Data Pump
  • SQL*Loader
  • Monitoring and Tuning Database Performance
  • Managing Memory Components
  • Automatic Workload Repository (AWR)
  • Advisory Framework
  • Monitoring Wait Events, Sessions, and Services
  • Managing Metric Thresholds and Alerts
  • Performance Tuning Methodology
  • Performance Planning Considerations
  • Automatic Database Diagnostic Monitor (ADDM)
  • SQL Statement tuning
  • Oracle Optimizer
  • SQL Tuning Advisor
  • Optimizer Statistics
  • SQL Access Advisor
  • SQL Tuning Process

 CORSI PROPEDEUTICI

Corso Oracle Database Administration OCP I;

CONTATTACI
UN NOSTRO CONSULENTE
TECNICO

Servizio attivo dal lunedì al giovedì 09.00-13.00 e 15.00-19.00 e Il venerdì dalle 09.00-13.00.

FORMAZIONE A DISTANZA

APPROFONDISCI

FORMAZIONE AZIENDALE

APPROFONDISCI

LABORATORIO LAVORO

APPROFONDISCI

LABORATORIO REMOTO

APPROFONDISCI

RICHIEDI CONSULENZA

APPROFONDISCI
ALTRE CERTIFICAZIONI
Cisco CCNA
DevNet Associate
CCNP Enterprise
Huawei HCIA R&S
CCNP Service Provider
CCNP Collaboration
Cisco Cybersecurity
CompTIA PenTest+
Fortinet NSE4
Fortinet NSE5
CCNP Security
Check Point CCSA
Palo Alto PCNSA
Check Point CCSE
CompTIA Linux+
Docker DCA
Kubernetes CKA
CompTIA A+
Windows Server 2019
Azure Administrator
AWS Solutions Architect
Google Cloud Engineer
Alibaba Cloud Computing
Azure Developer
VMware VCP-DCV
CCNP Data Center
Oracle SQL
Azure Database Admin
Azure Data Scientist Associate
Power BI
Java OCA
Programming C#
Python PCAP Associate
Altre Certificazioni

Footer

CHI SIAMO


Formazione Aziendale
Formazione a Distanza
Laboratorio Remoto
Casi di successo
Partner e convenzioni
Marketplace
About Vega Training

DIRITTI E PRIVACY


Privacy
Cookie
ISO 9001
Contatti

QUICK LINKS


Corsi Cisco
Corsi Check Point
Corsi Fortinet
Corsi Huawei
Corsi Microsoft
Corsi Google Cloud
Corsi Alibaba Cloud
Corsi VMware
Corsi CompTIA

CONTATTI



Dall’estero: +39 02 87168254
[email protected]

Trustpilot

Vega Training® SRL - Piva: 01985170743 - Copyright 2022