Oracle Database 12c: Administration I

Course ID

31050

Course Description

This course provides a complete, hands-on introduction to Oracle Database Administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer and SQL*Plus.

Prerequisites

Oracle12c SQL is required. Oracle12c PL/SQL is highly desirable.

Audience

This course is appropriate for anyone needing to understand and manage an Oracle 12c database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers, database administrators and IT management.

Course Content

    Introduction
  • Components of an oracle database
  • Duties of a database administrator
  • Dba management tools
  • Review of the sample schema
    • The taxes table
    • The zipcodes table
    • The jobs table
    • The departments table
    • The employees table
    • Objects in the el model
    • Analysis
    • Join conditions
    • Sql*plus
    • Starting sql*plus
    • Sql commands
    • Pl/sql commands
    • Login.sql (login.sql in linux / unix)
  • Sql developer
  • A brief overview of sql
  • What generation?
  • What sublanguages are supported?
  • Key single row functions
  • Key group functions
  • Key analytical functions
  • Other available analytical tools
  • Help me!
  • Object naming
  • What are the key datatypes?
  • What constraints are available for table definitions?
  • How do you select from multiple tables?
  • What is a self join?
  • What else can you do with a self reference?
  • New sql features of note in oracle12c
    • Top n and bottom n queries
    • Using extended datatypes
    • Default values
    • Identity columns
    • Invisible columns
    • Temporal validity
    • Pattern matching
    • Creating multiple indexes on columns
    • Miscellaneous new sql features
  • A brief overview of pl/sql
  • New pl/sql features of note in oracle12c
    • White lists
    • The with clause for functions
    • Pragma udf
    • New inquiry directives
    • New dbms_sql functionality
    • Enhanced language interface features
    • Miscellaneous new pl/sql features for oracle12c

    Creating oracle databases
  • Overview of database creation
  • The oracle universal installer
  • Prerequise tasks
    • Getting on the server
    • Memory requirements
    • Hardware requirements
    • Software requirements
    • Kernel requirements
    • Resource limits
    • Package requirements
    • Required users and groups
    • Required directories
    • What about windows?
  • Running the installer
  • Post installation
  • Using the database configuration assistant
  • Database templates
  • Lab 2: creating oracle databases
  • Lab 2 solutions: creating oracle databases

    Basic database administration
  • A brief roadmap
    • Basic database administration
    • Oracle networking
    • Instance management
    • Storage management
  • Oracle security
  • Schema objects
  • Backup and recovery
  • Oracle advisors
    • Problem resolution
    • Software management
    • Automated storage
  • Database management using emde
  • Environmental variables
  • Accessing enterprise manager database express
    • Enterprise manager database express access for non-dba users
  • Database administration with other tools

    Oracle networking
  • Oracle networking overview
  • The oracle net listener
  • Making a connection
    • Using easy connect
    • Using local naming
  • Using net manager
  • Controlling the listener
    • Starting and stopping the listener
    • Securing the listener
  • Troubleshooting networking

    Instance management
  • Managing the oracle instance
    • Needed vocabulary
  • Getting the database up
  • Changing parameters
  • Background processes
  • Other processes
  • Controlling memory usage
  • The startup process
  • Startup nomount
  • Startup mount
  • Startup | startup open
  • Startup restrict | startup open restrict
  • Startup force
  • The shutdown process
  • Shutdown | shutdown normal
  • Shutdown transactional
  • Shutdown immediate
  • Shutdown abort
    • The overall shutdown process
    • Using services for startup / shutdown
  • Memory management
  • Alternative architectures
    • Real application clusters
    • Pluggable databases

    Storage management
  • The basic logical structures
    • The block
    • The extent
    • The segment
    • The tablespace
    • The database
  • The physical structures
    • More about control files
    • More about online redo logs
    • More about archived redo logs
    • More about rollback segments
    • What types of tablespaces are there?
    • Tablespace status
    • Default tablespace type
    • Changing tablespace size
    • Tablespace properties
    • Encrypted tablespaces
    • Why add tablespaces?
  • Using emde for storage management
  • Changing tablespace and other alerts
  • Managing space within tables and indexes
  • Switching log files
  • Undo retention
  • Reviewing undo information
  • The undo advisor
  • Changing undo tablespace size

    Oracle security
  • Creating user accounts
    • Application schemas
    • Automatically created accounts
  • Types of privileges
  • About roles
  • Predefined roles
  • Viewing roles in enterprise manager database express
  • Creating roles in enterprise manager database express
  • Dropping a role
  • Admin and grant options
  • Sysdba / sysoper details
  • User account administration
  • Considerations regarding password case sensitivity
  • Profiles and password policies
  • Other security features
    • Auditing
    • Fine grained auditing
    • The virtual private database
    • Oracle label security
    • Oracle database vault
    • Oracle data redaction

    Schema objects
  • Schema objects
    • Object naming
    • Fully qualified naming
    • Aliases
    • Object control
    • Table management
    • Column attributes
    • Available datatypes
    • Large object enhancements
    • Column constraints
    • Partitioning
    • Table storage attributes
    • Table compression
    • Accessing table information
    • Creating a table
    • Adding columns
    • Dropping columns
    • Adding constraints
    • Disabling constraints
  • Loading data
    • Field delimited data
    • Comma delimited data
    • Sql developer import
    • Sql developer export
  • About indexes
    • Index creation
  • Views
    • Permission control within views
  • Stored procedures
  • Other objects
    • Materialized views
    • Synonyms
    • Sequences
    • Database links

    Backup and recovery
  • Overview / key concepts
  • Users for backup
  • The fast recovery area
  • The rman repository
  • Database configuration
  • Rman configuration
  • Block change tracking
  • Oracle secure backups
  • Oracle suggested backup strategy
  • Scheduling backups
  • Backup validation and other rman maintenance
  • Restore validation
  • The report command
  • The list command
  • Oracle advised recovery
  • User-directed recovery
  • Flashback table
  • Flashback to before drop
  • Flashback database
  • Manual restore and recover
  • The recovery catalog
  • Backup management
  • Monitoring fra space usage
  • Oracle advised recovery

    Oracle advisors
  • Proactive monitoring
    • The automatic database diagnostic monitor
  • Monitoring the database with emde
  • Using the performance hub
    • The summary tab
    • The rac tab
    • The activity tab
    • The workload tab
    • The monitored sql tab
    • The addm tab
    • The current addm findings tab
    • The database time tab
    • The resources tab
    • The system statistics tab
    • Workload repository reports
    • Modifying automatic snapshot settings
    • Using other advisors
    • Sql tuning advisor details
    • The automatic sql tuning advisor
    • Sql access advisor
    • Running memory advisors
  • Real application testing
    • Database replay
    • Sql performance analyzer (spa)

    Problem resolution
  • Overview
  • The resolution process

    Software management
  • Patch management
  • Upgrading the database
  • Edition-based redefinition
  • Removing oracle software

    Automated storage
  • Automatic storage management overview
  • The asm instance
  • Disks, disk groups and failure groups
  • Creating and dropping disk groups
  • Adding and dropping disks
  • Asm backups

    Hardening the database
  • Eliminating single points of failure
  • Hardening data files
  • Hardening the control files
  • Hardening the redo logs
    • Adding redo log groups
  • Hardening the archived redo logs
  • Hardening the peripheral files
  • Hardening the backups
  • Hardening the fast recovery area

    Os backup & recovery
  • Why use the operating system?
  • Closed backups in noarchivelog mode
  • Closed restore in noarchivelog mode
  • Open backups in archivelog mode
  • Restoring in archivelog mode
  • Recovery in archivelog mode
  • Incomplete recovery

    Advanced recovery manager
  • Configuring the recovery catalog
  • Running scripts in rman
  • Creating scripts in the catalog

    Data pump
  • Using data pump
    • Command line syntax
    • Using interactive mode
    • Reattaching
    • Data pump import options
    • Expdp examples
    • Impdp examples
  • Enterprise manager database express and data pump
  • The data pump driver
  • Data dictionary views

    Advanced security
  • Dbms_rls
    • Implementation tasks
    • Our example scenario
    • The policy package
    • The dynamic predicate package
    • Creating the context and the trigger
    • Using dbms_rls
    • Exempting policies
  • Dbms_fga
  • Controlling column access with virtual columns

    Shared server
  • Initialization parameters
  • Enabling shared servers
  • Dispatcher configuration
  • Data dictionary views
  • Configuring the client for shared server

    Logminer
  • Logminer basics
  • Dbms_logmnr
  • Dbms_logmnr.add_logfile
  • Dbms_logmnr.start_logmnr
  • Dbms_logmnr. End_logmnr
  • Dbms_logmnr.mine_value
  • Dbms_logmnr.column_present
  • Dbms_logmnr_d
  • Dbms_logmnr_d.build
  • Dbms_logmnr_d.set_tablespace
  • Supplemental logging
  • Logminer use summary
  • Using logminer
  • Using enterprise manager database express with logminer

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 5 days
Price - $2995.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.