English French German Italian Portuguese Russian Spanish

logo_old

  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.


    Read More

  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

Oracle 12c Database Administration Training

 PDF PrintEmail

Course duration

  • 5 Days

Course Outline

This Introduction to Oracle 12c Database Administration training class provides a complete, hands-on introduction to Oracle database administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer, and SQL*Plus.

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, including end users, business analysts, application developers, database administrators, and IT management.

  • Gain a thorough understanding of Oracle 12c database administration.
  • Oracle12c SQL.
  • Oracle12c PL/SQL.
  1. Introduction
    1. Components of an Oracle Database
    2. Duties of a Database Administrator
    3. DBA Management Tools
    4. Review of the Sample Schema
      1. The Taxes Table
      2. The ZipCodes Table
      3. The Jobs Table
      4. The Departments Table
      5. The Employees Table
      6. Objects In The EL Model
      7. Analysis
      8. Join Conditions
    5. SQL*PLUS
      1. Starting SQL*Plus
      2. SQL Commands
      3. PL/SQL Commands
      4. SQL*Plus Commands
      5. Login.sql (login.sql In Linux/UNIX)
    6. SQL Developer
    7. A Brief Overview of SQL
    8. What Generation?
    9. What Sublanguages Are Supported?
    10. Key Single Row Functions
    11. Key Group Functions
    12. Key Analytical Functions
    13. Other Available Analytical Tools
    14. Help Me!
    15. Object Naming
    16. What Are the Key Datatypes?
    17. What Constraints Are Available for Table Definitions?
    18. How Do You Select from Multiple Tables?
    19. What Is a Self Join?
    20. What Else Can You Do with a Self Reference?
    21. New SQL Features of Note in Oracle 12c
      1. Top N and Bottom N Queries
      2. Using Extended Datatypes
      3. DEFAULT Values
      4. IDENTITY Columns
      5. Invisible Columns
      6. Temporal Validity
      7. Pattern Matching
      8. Creating Multiple Indexes On Columns
      9. Miscellaneous New SQL Features
    22. A Brief Overview of PL/SQL
    23. NEW PL/SQL Features of Note in Oracle 12c
      1. White Lists
      2. The WITH Clause for Functions
      3. PRAGMA UDF
      4. New Inquiry Directives
      5. New DBMS_SQL Functionality
      6. Enhanced Language Interface Features
      7. Miscellaneous New PL/SQL Features For Oracle12c
    24. LAB 1: Introduction
    25. LAB 1 Solutions: Introduction
  2. Creating Oracle Databases
    1. Overview of Database Creation
    2. THE Oracle Universal Installer
    3. Prerequise Tasks
      1. Getting On The Server
      2. Memory Requirements
      3. Hardware Requirements
      4. Software Requirements
      5. Kernel Requirements
      6. Resource Limits
      7. Package Requirements
      8. Required Users And Groups
      9. Required Directories
      10. What About Windows?
    4. Running the Installer
    5. Post Installation
      1. Environment
    6. Using the Database Configuration Assistant
    7. Database Templates
    8. LAB 2: Creating Oracle Databases
    9. LAB 2 Solutions: Creating Oracle Databases
  3. Basic Database Administration
    1. A Brief Roadmap
      1. Basic Database Administration
      2. Oracle Networking
      3. Instance Management
      4. Storage Management
      5. Oracle Security
      6. Schema Objects
      7. Backup And Recovery
      8. Oracle Advisors
      9. Problem Resolution
      10. Software Management
      11. Automated Storage
    2. Database Management Using EMDE
    3. Environmental Variables
    4. Accessing Enterprise Manager Database Express
      1. Enterprise Manager Database Express Access for Non-DBA Users
    5. Database Administration with Other Tools
    6. LAB 3: Basic Database Administration
    7. LAB 3 Solutions: Basic Database Administration
  4. Oracle Networking
    1. Oracle Networking Overview
    2. The Oracle NET Listener
    3. Making a Connection
      1. Using Easy Connect
      2. Using Local Naming
    4. Using NET Manager
    5. Controlling the Listenerl>
      1. Starting and Stopping the Listener
      2. Securing the Listener
    6. Troubleshooting Networking
    7. Lab 4: Oracle Networking
    8. Lab 4 Solutions: Oracle Networking
  5. Instance Management
    1. Managing the Oracle Instance
      1. Needed Vocabulary
    2. Getting the Database Up
    3. Changing Parameters
    4. Background Processes
    5. Other Processes
    6. Controlling Memory Usage
    7. The Startup Process
    8. Startup Nomount
    9. Startup Mount
    10. Startup/Startup Open
    11. Startup Restrict/Startup Open Restrict
    12. Startup Force
    13. The Shutdown Process
    14. Shutdown/Shutdown Normal
    15. Shutdown Transactional
    16. Shutdown Immediate
    17. Shutdown Abort
      1. The Overall Shutdown Process
      2. Using Services For Startup/Shutdown
    18. Memory Management
    19. Alternative Architectures
      1. Real Application Clusters
      2. Pluggable Databases
    20. Lab 5: Instance Management
    21. Lab 5 Solutions: Instance Management
  6. Storage Management
    1. The Basic Logical Structures
      1. The Block
      2. The Extent
      3. The Segment
      4. The Tablespace
      5. The Database
    2. The Physical Structures
      1. More About Control Files
      2. More About Online Redo Logs
      3. More About Archived Redo Logs
      4. More About Rollback Segments
      5. What Types Of Tablespaces Are There?
      6. Tablespace Status
      7. Default Tablespace Type
      8. Changing Tablespace Size
      9. Tablespace Properties
      10. Encrypted Tablespaces
      11. Why Add Tablespaces?
    3. Using EMDE for Storage Management
    4. Changing Tablespace and Other Alerts
    5. Managing Space within Tables and Indexes
    6. Switching Log Files
    7. Undo Retention
    8. Reviewing Undo Information
    9. The Undo Advisor
    10. Changing Undo Tablespace Size
    11. Lab 6: Storage Management
    12. Lab 6 Solutions: Storage Management
  7. Oracle Security
    1. Creating User Accounts
      1. Application Schemas
      2. Automatically Created Accounts
    2. Types Of Privileges
    3. About Roles
    4. Predefined Roles
    5. Viewing Roles in Enterprise Manager Database Express
    6. Creating Roles in Enterprise Manager Database Express
    7. Dropping a Role
    8. Admin and Grant Options
    9. SYSDBA/SYSOPER Details
    10. User Account Administration
    11. Considerations Regarding Password Case Sensitivity
    12. Profiles and Password Policies
    13. Other Security Features
      1. Auditing
      2. Fine Grained Auditing
      3. The Virtual Private Database
      4. Oracle Label Security
      5. Oracle Database Vault
      6. Oracle Data Redaction
    14. Lab 7: Oracle Security
    15. Lab 7 Solutions: Oracle Security
  8. Schema Objects
    1. Schema Objects
      1. Object Naming
      2. Fully Qualified Naming
      3. Aliases
      4. Object Control
      5. Table Management
      6. Column Attributes
      7. Available Datatypes
      8. Large Object Enhancements
      9. Column Constraints
      10. Partitioning
      11. Table Storage Attributes
      12. Table Compression
      13. Accessing Table Information
      14. Creating A Table
      15. Adding Columns
      16. Dropping Columns
      17. Adding Constraints
      18. Disabling Constraints
    2. Loading Data
      1. Field Delimited Data
      2. Comma Delimited Data
      3. SQL Developer Import
      4. SQL Developer Export
    3. About Indexes
      1. Index Creation
    4. Views
      1. Permission Control within Views
    5. Stored Procedures
    6. Other Objects
      1. Materialized Views
      2. Synonyms
      3. Sequences
      4. Database Links
    7. Lab 8: Schema Objects
    8. Lab 8 Solutions: Schema Objects
  9. Backup and Recovery
    1. Overview/Key Concepts
    2. Users for Backup
    3. The Fast Recovery Area
    4. The RMAN Repository
    5. Database Configuration
    6. RMAN Configuration
    7. Block Change Tracking
    8. Oracle Secure Backups
    9. Oracle Suggested Backup Strategy
    10. Scheduling Backups
    11. Backup Validation and Other RMAN Maintenance
    12. Restore Validation
    13. The Report Command
    14. The List Command
    15. Oracle Advised Recovery
    16. User-Directed Recovery
    17. Flashback Table
    18. Flashback to before Drop
    19. Flashback Database
    20. Manual Restore and Recover
    21. The Recovery Catalog
    22. Backup Management
    23. Monitoring FRA Space Usage
    24. Oracle Advised Recovery
    25. Lab 9: Backup And Recovery
    26. Lab 9 Solutions: Backup And Recovery
  10. Oracle Advisors
    1. Proactive Monitoring
      1. The Automatic Database Diagnostic Monitor
    2. Monitoring the Database with EMDE
    3. Using the Performance Hub
      1. The Summary Tab
      2. The RAC Tab
      3. The Activity Tab
      4. The Workload Tab
      5. The Monitored SQL Tab
      6. The ADDM Tab
      7. The Current ADDM Findings Tab
      8. The Database Time Tab
      9. The Resources Tab
      10. The System Statistics Tab
      11. Workload Repository Reports
      12. Modifying Automatic Snapshot Settings
    4. Using Other Advisors
      1. SQL Tuning Advisor Details
      2. The Automatic SQL Tuning Advisor
      3. SQL Access Advisor
      4. Running Memory Advisors
    5. Real Application Testing
    6. Database Replay
    7. SQL Performance Analyzer (SPA)
    8. Lab 10: Oracle Advisors
    9. Lab 10 Solutions: Oracle Advisors
  11. Problem Resolution
    1. Overview
    2. The Resolution Process
    3. Lab 11: Problem Resolution
    4. Lab 11 Solutions: Problem Resolution
  12. Software Management
    1. Patch Management
    2. Upgrading The Database
    3. Edition-Based Redefinition
    4. Removing Oracle Software
  13. Automated Storage
    1. Automatic Storage Management Overview
    2. The ASM Instance
    3. Disks, Disk Groups and Failure Groups
    4. Creating and Dropping Disk Groups
    5. Adding and Dropping Disks
    6. ASM Backups
  14. Hardening the Database
    1. Eliminating Single Points of Failure
    2. Hardening Data Files
    3. Hardening the Control Files
    4. Hardening the Redo Logs
    5. Adding Redo Log Groups
    6. Hardening the Archived Redo Logs
    7. Hardening the Peripheral Files
    8. Hardening the Backups
    9. Hardening the Fast Recovery Area
    10. Lab 14: Hardening The Database
    11. Lab 14 Solutions: Hardening The Database
  15. OS Backup and Recovery
    1. Why Use the Operating System?
    2. Closed Backups in Noarchivelog Mode
    3. Closed Restore in Noarchivelog Mode
    4. Open Backups in Archivelog Mode
    5. Restoring in Archivelog Mode
    6. Recovery in Archivelog Mode
    7. Incomplete Recovery
    8. Lab 15: OS Backup and Recovery
    9. Lab 5 Solutions: OS Backup and Recovery
  16. Advanced Recovery Manager
    1. Configuring the Recovery Catalog
    2. Running Scripts in RMAN
    3. Creating Scripts in the Catalog
    4. Lab 16: Advanced Recovery Manager
    5. Lab 16 Solutions: Advanced Recovery Manager
  17. Data Pump
    1. Using Data Pump
      1. Command Line Syntax
      2. Using Interactive Mode
      3. Reattaching
      4. Data Pump Import Options
      5. EXPDP Examples
      6. IMPDP Examples
    2. Enterprise Manager Database Express and Data Pump
    3. The Data Pump Driver
    4. Data Dictionary Views
    5. Lab 17: Data Pump
    6. Lab 17 Solutions: Data Pump
  18. Advanced Security
    1. DBMS_RLS
      1. Implementation Tasks
      2. Our Example Scenario
      3. The Policy Package
      4. The Dynamic Predicate Package
      5. Creating the Context And The Trigger
      6. Using DBMS_RLS
      7. Exempting Policies
    2. DBMS_FGA
    3. Controlling Column Access with Virtual Columns
    4. Lab 18: Advanced Security
    5. Lab 18 Solutions: Advanced Security
  19. Shared Server
    1. Initialization Parameters
    2. Enabling Shared Servers
    3. Dispatcher Configuration
    4. Data Dictionary Views
    5. Configuring the Client for Shared Server
    6. Lab 19: Shared Server
    7. Lab 19 Solutions: Shared Server
  20. Logminer
    1. Logminer Basics
    2. DBMS_LOGMNR
    3. DBMS_LOGMNR.ADD_LOGFILE
    4. DBMS_LOGMNR.START_LOGMNR
    5. DBMS_LOGMNR. END_LOGMNR
    6. DBMS_LOGMNR.MINE_VALUE
    7. DBMS_LOGMNR.COLUMN_PRESENT
    8. DBMS_LOGMNR_D
    9. DBMS_LOGMNR_D.BUILD
    10. DBMS_LOGMNR_D.SET_TABLESPACE
    11. Supplemental Logging
    12. LOGMINER Use Summary
    13. Using LOGMINER
    14. Using Enterprise Manager Database Express with LOGMINER
    15. Lab 20: LOGMINER
    16. Lab 20 Solutions: LOGMINER

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.