Oracle 19c database administration

    Czas trwania
    Godzina rozpoczęcia
    Stopień trudności

      Oracle 19c database administration

      Remote and stationary training options

      About training

      Participants will learn about the structure of the Oracle server, principles of instance architecture and data organization in databases. Knowledge includes the issues of the impact of database storage structures, schemas and server configuration to its proper work. The participant will gain knowledge of safety rules in the databases and the practical ability to configure access management and Oracle Network Environment configuration.

      View the training programme

      What will you gain from the training?

      Training objectives 

      Participants will learn about the structure of the Oracle server, principles of instance architecture and data organization in databases. Knowledge includes the issues of the impact of database storage structures, schemas and server configuration to its proper work. The participant will gain knowledge of safety rules in the databases and the practical ability to configure access management and Oracle Network Environment configuration. The training will enable the acquisition of skills for monitoring server health and databases. Skills acquired during the training also includes server configuration management database schemas and users, as well as the current performance of administrative tasks. Practical exercises will be carried out on MS Windows.

      Skills

      After completing the course, participants will know how to:

      • modify the relevant instance, database and session parameters
      • start, stop and restart the server
      • design and create a new database
      • prepare parameters file
      • create and manage users
      • grant and revoke the roles and privileges
      • manage schema objects and their parameters
      • manage tablespaces
      • use Flashback mechanisms to recover data
      • monitor database on different levels
      • configure the listener
      • create a database link and use remote query
      Is this training for you?

      Audience profil & requirements 

      This course is for database administrators. The training can be useful also for developers implementing databases and database applications who – by understanding the principles of operation of the server – will be able to better use its potential. 

      Duration

      Duration:

      • 4 days, 32 hours
      Detailed training program

      Detailed training program

          Oracle Server Architecture Overview

          Databases and instances

          New features in Oracle 19c instance architecture

          Multitenant Architecture

          Container databases

          Pluggable databases

          The differences in the container management in the Enterprise and Standard editions

          Logical storage structure

          •     Tablespaces
          •     Blocks
          •     Extents
          •     Segments

          Database users

          •     Database and Diagrams
          •     Schemes and their objects

          Logical database structure

          •     Tables
          •     Limitations
          •     Indexes
          •     Views
          •     Profiles
          •     Sequences
          •     Synonyms

          The physical data storage structure

          •     Data Files
          •     Redo log files
          •     Control files
          •     Archived log files
          •     Initialization parameter files
          •     Alerts log and trace files
          •     Backup files
          •     Oracle ManagedFiles
          •     Password files

          Instance memory structures 

          •     SGA
          •     PGA
          •     Shared SQL Area
          •     Background Processes

          Starting and Closing instance

          Creating a database

          Initialization parameters

          •     Binary and text parameters file
          •     Basic parameters
          •     Advanced Parameters

          Selecting and updating data (how SQL commands are processed)

          Dynamic memory management of the SGA

          Ensuring consistency and concurrency transactions

          Managing database structure

          Tablespaces

          •     Types of tablespaces
          •     Architecture OFA (Optimal Flexible Architecture)
          •     SYSTEM tablespace
          •     SYSAUX tablespace
          •     TEMP tablespace
          •     UNDOTBS1 tablespace
          •     USERS tablespace
          •     EXAMPLE tablespace
          •     Managing tablespaces
          •     Changing the size of the tablespace
          •     Segments in the spaces tables

          Managing the physical structure of the database

          •     Moving data files
          •     Moving redo log files
          •     Transferring control files
          •     Automatic Storage Management architecture

          Storage Space management

          •     Free space management in tablespaces
          •     Providing space for temporary segments
          •     Undo tablespace management
          •     Fragmented tablespaces and segments
          •     Local tablespace management 
          •     Bigfile tablespaces
          •     Segment Advisor
          •     Undo Advisor
          •     Automatic Workload Repository
          •     The use of indices

          Rollback

          •     Data read consistency
          •     Recovering

          Oracle Flashback

          •     Flashback Query
          •     DBMS_FLASHBACK package
          •     FlashbackVersions Query
          •     FlashbackTransaction Query
          •     FlashbackTable
          •     Flashback Drop
          •     Flashback Database

          National language support

          Oracle Scheduler and DBMS_SCHEDULER package

          Oracle Net

          •     Descriptors 
          •     Network Services
          •     Listener Processes
          •     Oracle Net Configuration Assistant
          •     Oracle Net Manager
          •     Server Listener

          Distributed Databases

          •     Database Connectivity
          •     Remote selects

          System resources control and management

          Database users support

          Security system

          •     Privileges
          •     Roles
          •     Database access management
          •     Profile Management

          Monitoring

          •     Data monitoring location
          •     Instructions monitoring 
          •     Privileges monitoring
          •     Schema objects monitoring
          •     Precision monitoring
          •     Monitoring dictionary views

          DOWNLOAD FILE

          Training delivery method

          The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.

          Development path

          Podobne tematy