Course Outline

Oracle architecture overview
   Instance and database
   New instance features in Oracle 12c
   Multitenant architecture
   Container databases
   Pluggable databases

System security, instance and database configuration
    Server access management and database access for SYSDBA role users
    Initialization parameters - binary and text parameter file
    Starting and shutting down the instance
    Opening and closing the database
    Opening and closing of pluggable databases (PDBs) in Oracle 12c
    Status of the instance and databases (container and pluggable ones)
    Permissions
    Roles
    Profile management

Oracle Net
    Call descriptors
    Network services
    Listener server process
    Oracle Net Manager
    Serve and client configuration for remote connection
    
Logical storage structure
    Tablespaces
    Segments
    Extents
    Blocks

Database users
    Database architecture
    Schemas and their objects
    Global and local schema in Oracle 12c
    User management in Oracle 12c

Logical database structure
    Tabels
    limitations
    Indexes
    Views
    Profiles
    Sequences
    Synonyms
    Directories

Managing the physical database structure
    Initialization parameters and passwords
    Alert.log file and trace files
    Controlfiles management
    Adding and moving control files
    Redo.log files management
    Mirrorig, adding and moving redo files
    Switching the database mode and the difference between the ARCHIVELOG and NOARCHIVELOG modes
    Archivelog file management
    Mirroring, adding and moving archivelog files
    Data file management and free space on disks
    Moving data files
    Database files in Oracle 12c containers
    Automatic Storage Management architecture

Disk space management
    Problems with free space in tablespaces
    Free disk space management
    Providing space for temporary segments
    Fragmented tablespaces and segments
    Multiple files tablespaces
    Segment advisor
    Undo Advisor
    Use of indexes

Memory structures within instances
    SGA area
    PGA area
    Area of ​​executable code
    Secondary processes
    Dynamic memory management
    ASMM since 10g and AMM since 11g

Creating a database
Differences in the creation of non-PDB and PDB databases
Selecting and updating data (how SQL commands are processed)
Ensuring consistency and concurrency of transactions
Database structure management
Tablespaces
    Types of tablespaces
    OFA (Optimal Flexible Architecture) architecture
    System tablesspace
    SYSAUX tablespace
    TEMP tablespace
    UNDO tablespace
    USERS table space
    EXAMPLE table space
    Tablespace management
    Resizing table space
    Segments in tablespaces
    Moving tables to different tablespaces or to the same tablespace vs HighWaterMark vs Indexes

Archiving and database recovery:
    Hot and cold backup
    Backup of datafiles and control files
    Restoring and recovering the database
    RMAN - Recovery Manager
    Backup using the RMAN tool
    Restoring and recovering database using the RMAN tool

Oracle Flashback
    Flashback Query - retrospective queries
    DBMS_FLASHBACK package - moving the session back and forward in time
    FlashbackVersions Query - querying data versions over time
    FlashbackTransaction Query - monitoring of all DML commands in database
    FlashbackTable - moving tables back and forward in time
    Flashback Drop - retrieving dropped tables back
    Flashback Database - moving the database back in time

National language support
Oracle Scheduler and the DBMS_SCHEDULER package
Control system resources

Requirements

SQL basic knowledge

  28 Hours
 

Testimonials (7)

Related Courses

Related Categories