Oracle Database 12cR2 Essential Administration

Prihajajoče izvedbe

Nivo:For IT professionals
Prodajalec:Oracle (Unofficial)
Kategorija prodajalca:Database
Trajanje (dni):5
Ur/dan:8
Tip učenja:V učilnici ali preko spleta
Cena:2.250€ + DDV

The Oracle Database 12cR2 Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 12cR2 database.

The Oracle Database 12cR2 Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The Oracle Database 12cR2 Essential Administration course is not aimed at delegates who are full time Database Administrators. The focus is on using Enterprise Manager Express and SQL Developer to teach delegates how to manage the database. The usage of SQL*Plus is also covered.

 

The delegate will learn and acquire skills as follows:

  • Installing Oracle Database 12c Software
  • Creating an Oracle database
  • Administering an Oracle database with Enterprise Manager Express, SQL Developer and SQL*Plus
  • Configuring the Oracle Network Environment
  • Creating and Managing Database Storage Structures
  • Managing Schema Objects
  • Managing Users
  • Maintaining Database Security
  • Backing up, Restoring and Recovering the Database
  • Monitoring the Performance of the Database Using Advisors

 

Who will the Course Benefit?

The Oracle Database 12cR2 Essential Administration course is aimed at Database Administrators of small sized databases who need to install the Oracle Database 12c software, create, monitor and support an Oracle Database 12c database.

The Oracle Database 12cR2 Essential Administration course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 12c software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.

Session 1: INTRODUCTION

Oracle product overview

Oracle Support services

Relational database concepts

Oracle architecture

Oracle Multitenant architecture

Overview of the Oracle Cloud

Database administration tasks

Database administration responsibilities

 

Session 2: INSTALL THE ORACLE DATABASE SOFTWARE WITH THE OIU

Installation planning

Understand system requirements and operating system pre-requisites

Oracle flexible architecture

Environment variables

Use Oracle Universal Installer to install Oracle software (OUI)

The Oracle Inventory

De-install Oracle Database softare

 

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

Select a storage method

Select a CDB or non-CDB database

Select a database type based on workload

Select a character set for the database

Create a database using the DBCA

 

Session 4: ADMINISTER A DATABASE

Administrative tools available to a DBA

Use SQL*Plus and SQL Developer to manage a database

Administer the database using Enterprise Manager Express

An overview of Enterprise Manager Cloud Control

 

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

Overview of network configuration

Oracle Net Listener configuration and management

Oracle Net Naming methods

Tools for configuring and managing the Oracle network

Configure local naming for client connections with Net Manager

Start and stop the Oracle listener

Configure the listener with EM

Use TNSPING to test Oracle Net connectivity

Connect to the database

Oracle Database 12cR2 Essential Administration Training Course

 

Session 6: MANAGE AN ORACLE INSTANCE

Oracle Instance

Instance management

Memory structures

Background processes

Database authentication methods

Initialization parameters

Password file

Shut down the database

Start up the database

View alert log and trace files

 

Session 7: DATABASE STORAGE STRUCTURES

Oracle database structures

Control files

Redo log and archive redo log files

Tablespaces and data files

Create tablespaces

Manage tablespaces

Manage undo and use the Undo Advisor

Use Enterprise Manager Express and SQL Developer to view the storage structure of the database

 

Session 8: MANAGE USERS

Database administration accounts

User accounts

Create and administer user accounts

Lock and unlock user accounts

Change a user's password

Administer privileges and roles

 

Session 9: MANAGE SCHEMA OBJECTS

Create schema objects

Create a new table

View the attributes and contents of a table

Understand data integrity

Define constraints

Create indexes

View index attributes

Create views

Create synonyms

Create sequences

 

Session 10: BACKUP, RECOVER AND RESTORE A DATABASE

Oracle backup strategy

Overview of backup, restore and recovery

Backup and recovery configuration

Configure ARCHIVELOG mode

Overview of backup and recovery operations

Overview of scheduled backups

Configure backup settings

Configure recovery settings

Perform recovery

 

Session 11: PERFORMANCE MONITORING

Overview of self-monitoring architecture

Monitor an Oracle database

Automatic Workload Repository

Automatic Database Diagnostics Monitor (ADDM)

Additional monitoring

Use the advisors

Delegates wishing to attend the Oracle Database 12cR2 Essential Administration course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.

This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.

V angleščini Termin ni potrjen

15. junij 2020 - 19. junij 2020

  • Cena: 2.250€ + DDV
Pokaži urnik

Za več informacij nas kontaktirajte na telefonsko številko: 01 568 40 40 ali trzenje@housing.si.

Naša spletna stran uporablja piškotke, ki se naložijo na vaš računalnik. Ali se za boljše delovanje strani strinjate z njihovo uporabo?

Več o uporabi piškotkov

Uporaba piškotkov na naši spletni strani

Pravna podlaga

Podlaga za obvestilo je spremenjeni Zakon o elektronskih komunikacijah (Uradni list št. 109/2012; v nadaljevanju ZEKom-1), ki je začel veljati v začetku leta 2013. Prinesel je nova pravila glede uporabe piškotkov in podobnih tehnologij za shranjevanje informacij ali dostop do informacij, shranjenih na računalniku ali mobilni napravi uporabnika.

Kaj so piškotki?

Piškotki so majhne datoteke, pomembne za delovanje spletnih strani, največkrat z namenom, da je uporabnikova izkušnja boljša.

Piškotek običajno vsebuje zaporedje črk in številk, ki se naloži na uporabnikov računalnik, ko ta obišče določeno spletno stran. Ob vsakem ponovnem obisku bo spletna stran pridobila podatek o naloženem piškotku in uporabnika prepoznala.

Poleg funkcije izboljšanja uporabniške izkušnje je njihov namen različen. Piškotki se lahko uporabljajo tudi za analizo vedenja ali prepoznavanje uporabnikov. Zato ločimo različne vrste piškotkov.

Vrste piškotkov, ki jih uporabljamo na tej spletni strani

Piškotki, ki jih uporabljamo na tej strani sledijo smernicam:

1. Nujno potrebni piškotki

Tovrstni piškotki omogočajo uporabo nujno potrebnih komponent za pravilno delovanje spletne strani. Brez teh piškotov servisi, ki jih želite uporabljati na tej spletni strani, ne bi delovali pravilno (npr. prijava, nakupni proces, ...).

2. Izkustveni piškotki

Tovrstni piškotki zbirajo podatke, kako se uporabniki vedejo na spletni strani z namenom izboljšanja izkustvene komponente spletne strani (npr. katere dele spletne strani obiskujejo najpogosteje). Ti piškotki ne zbirajo informacij, preko katerih bi lahko identificirali uporabnika.

3. Funkcionalni piškotki

Tovrstni piškotki omogočajo spletni strani, da si zapomni nekatere vaše nastavitve in izbire (npr. uporabniško ime, jezik, regijo) in zagotavlja napredne, personalizirane funkcije. Tovrstni piškotki lahko omogočajo sledenje vašim akcijam na spletni strani.

4. Oglasni ali ciljani piškotki

Tovrstne piškotke najpogosteje uporabljajo oglaševalska in družabna omrežja (tretje strani) z namenom, da vam prikažejo bolj ciljane oglase, omejujejo ponavljanje oglasov ali merijo učinkovitost oglaševalskih akcij. Tovrstni piškotki lahko omogočajo sledenje vašim akcijam na spletu.

Nadzor piškotkov

Za uporabo piškotkov se odločate sami. Piškotke lahko vedno odstranite in s tem odstranite vašo prepoznavnost na spletu. Prav tako večino brskalnikov lahko nastavite tako, da piškotkov ne shranjujejo.

Za informacije o možnostih posameznih brskalnikov predlagamo, da si ogledate nastavitve.

Upravljalec piškotkov

Housing Co. d.o.o.