Oracle Certification Training

Syllabus of Oracle Certification Online Training Course

• 1. Retrieing Data Using the SQL SELECT Statement
• 2. Restricting and Sorting Data
• 3. Using Single-Row functions to customize output
• 4. Reporting aggregated data using the group functions
• 5. Displaying data from multiple tables
• 6. Using sub queries to sole queries
• 7. Using the set operations
• 8. Manipulating data
• 9. Using DDL statements to create and manage tables
• 10. Managing objects with data dictionary
• 11. Controlling user access
• 12. Managing scheme objects
• 13. Managing large data sets
• 14. Generating reports by grouping related data
• 15. Managing data in different time zones
• 16. Retrieing data using sub queries
• 17. Hierarchical retrieal

• 1. Architecture
• 2. Installing the Oracle database software
• 3. Creating an Oracle database
• 4. Managing the Oracle instance
• 5. Managing database storage structures
• 6. Administering user security
• 7. Managing schema objects
• 8. Managing data and concurrency
• 9. Managing undo data
• 10. Implementing Oracle database security
• 11. Configuring the Oracle network enironment
• 12. Proactie maintenance
• 13. Performance management
• 14. Backup and recoery concepts
• 15. Performing database backup
• 16. Performing database recoery
• 17. Performing flashback moing data

• 1. This hands-on course will teach you to effectively plan, install, configure, administer, query, troubleshoot and manage Oracle Databases.
• 2. The course will prepare students for the Oracle exams, as well as deliver a foundation in the real world application of their database skills.

• 1. This course is designed for individuals with generic database knowledge.

• 1. Oracle Server
• 2. SGA
• 3. Datafiles
• 4. Background Processes

• 1. Database Configuration Assistance
• 2. Database Templates

• 1. Oracle Enterprise Manager

• 1. Tablespaces
• 2. Datafiles
• 3. Tempfiles

• 1. System Accounts
• 2. Application Accounts
• 3. Database Roles

• 1. Tables
• 2. Indexes
• 3. Views
• 4. Synonyms

• 1. Insert
• 2. Update
• 3. Delete
• 4. Database Packages
• 5. Database Procedures

• 1. Flashback Query

• 1. Automatic Workload Repository
• 2. Automatic Database Diagnostic Monitor

• 1. Memory Advisors

• 1. RMAN
• 2. Open database Backup
• 3. Closed database Backup

• 1. Open Database Recovery
• 2. Closed Database Recovery

• 1. Data Pump
• 2. SQL*Loader

• 1. Define projection, selection, and join terminology
• 2. Select all columns using a wildcard notation from a table
• 3. Write a query containing the arithmetic operators
• 4. Create a character expression with the concatenation operator
• 5. Using the iSQL*Plus Environment
• 6. SQL statements versus iSQL*Plus commands

• 1. Limit rows using a selection
• 2. Using the WHERE clause to retrieve specific rows
• 3. Using the comparison conditions in the WHERE clause
• 4. Use the LIKE condition to compare literal values
• 5. List the logical conditions AND, OR, NOT
• 6. Describe the rules of precedence for the conditions
• 7. Sort rows with the ORDER BY clause

• 1. Show the differences between single row and multiple row SQL functions
• 2. Categorize the character functions into case manipulation and character manipulation types
• 3. Use the character manipulation functions in the SELECT and WHERE clauses
• 4. Explain and use the DATE and numeric functions

• 1. Describe and categorize the group functions
• 2. Use the group functions
• 3. Utilize the DISTINCT keyword with the group functions
• 4. Describe how nulls are handled with the group functions
• 5. Create groups of data with the GROUP BY clause
• 6.Group data by more than one column
• 7. Avoid illegal queries with the group functions
• 8. Exclude groups of data with the HAVING clause

• 1. Identify Types of Joins
• 2. Retrieve Records with Natural Joins
• 3. Use Table Aliases to write shorter code and explicitly identify columns from multiple tables
• 4. Create a Join with the USING clause to identify specific columns between tables
• 5. Use the ON clause to specify arbitrary conditions or specify columns to Join
• 6. List the Types of Outer Joins LEFT, RIGHT, and FULL
• 7. Generating a Cartesian Product

• 1. List the syntax for sub queries in a SELECT statements WHERE clause
• 2. List the guidelines for using sub queries
• 3. Describe the types of sub queries
• 4. Execute single row sub queries and use the group functions in a sub query
• 5. Identify illegal statements with sub queries
• 6. Execute multiple row sub queries

• 1. Write INSERT statements to add rows to a table
• 2. Copy rows from another table
• 3. Create UPDATE statements to change data in a table
• 4. Generate DELETE statements to remove rows from a table
• 5. Use a script to manipulate data
• 6. Save and discard changes to a table through transaction processing
• 7. Show how read consistency works
• 8. Describe the TRUNCATE statement

• 1. List the main database objects and describe the naming rules for database objects
• 2. Explain the different types of constraints
• 3. Show resulting exceptions when constraints are violated with DML statements
• 4. Create a table with a sub query
• 5. Describe the ALTER TABLE functionality
• 6. Remove a table with the DROP statement and Rename a table

• 1. Categorize simple and complex views and compare them
• 2. Create a view
• 3. Retrieve data from a view
• 4. Explain a read-only view
• 5. List the rules for performing DML on complex views
• 6. Create a sequence
• 7. List the basic rules for when to create and not create an index
• 8. Create a synonym

• 1. Controlling User Access
• 2. System versus Objects Privileges
• 3. Using Roles to define user groups
• 4. Changing Your Password
• 5. Granting Object Privileges
• 6. Confirming Privileges Granted
• 7. Revoking Object Privileges

• 1. Using the ALTER TABLE statement
• 2. Adding a Column
• 3. Modifying a Column
• 4. Dropping a Column, Set Column UNUSED
• 5. Adding, Enabling and Disabling Constraints
• 6. Creating Function-Based Indexes
• 7. Performing FLASHBACK operations
• 8. External Tables

• 1. Using the MERGE Statement
• 2. Performing DML with Sub queries
• 3. Performing DML with a RETURNING Clause
• 4. Tracking Changes in DML

• 1. Using date and time functions
• 2. Identifying TIMESTAMP Data Types
• 3. Differentiating between DATE and TIMESTAMP
• 4. Performing Conversion Operations

• 1. Sub query Overview
• 2. Using a Sub query
• 3. Comparing several columns using Multiple-Column Sub queries
• 4. Defining a Data source Using a Sub query in the FROM Clause
• 5. Returning one Value using Scalar Sub query Expressions
• 6. Performing ROW by-row processing with Correlated Sub queries
• 7. Reusing query blocks using the WITH Clause

• 1. Oracle Database Architecture Overview
• 2. ASM General Architecture
• 3. Creating an ASM Instance
• 4. Using Enterprise Manager to Manage ASM Users
• 5. ASM Storage Concepts
• 6. The ASMCMD Utility
• 7. ASM Scalability and Performance
• 8. Configuring for Recoverability

• 1. Typical Backup and Recovery Tasks
• 2. Oracle Backup and Recovery Solutions
• 3. Using Recovery Manager (RMAN)
• 4. Using a Flash Recovery Area
• 5. Flash Recovery Area Space Management
• 6. Using the RMAN Recovery Catalog

• 1. Storing Information in the Recovery Catalog
• 2. Registering a Database in the Recovery Catalog
• 3. Recovery Catalog Resynchronization: Concepts
• 4. Using RMAN Stored Scripts
• 5. Backing Up and Recovering the Recovery Catalog
• 6. Using a Virtual Private Catalog
• 7. Configuring Backup Specifications

• 1. Configuring Persistent Settings for RMAN
• 2. Using Enterprise Manager to Configure RMAN Settings
• 3. Control File Auto-backups
• 4. Managing Persistent Settings
• 5. Configuring Devices for Backup
• 6. Configuring and Allocating Channels for Use in Backups
• 7. Configuring Backup Optimization
• 8. Creating Backups

• 1. Creating Backup Sets & Image Copies
• 2. Creating a Whole Database Backup
• 3. RMAN Backup Types
• 4. Monitoring Block Change Tracking
• 5. Creating Duplex Backup Sets
• 6. Archival Backups: Concepts
• 7. Encrypting Backups
• 8. Performing User-Managed Backup and Recovery

• 1. Causes of File Loss
• 2. Critical Versus Non-critical
• 3. Recovering from a TEMPFILE Loss
• 4. Re-creating Indexes
• 5. Recovering from a Lost Index Tablespace
• 6. Authentication Methods for Database Administrators
• 7. Recovering a Read-Only Tablespace
• 8. Using RMAN to Perform Recovery

• 1. Performing Recovery Using Enterprise Manager
• 2. Recovery Using Incrementally Updated Backups
• 3. Perform a Fast Switch to Image Copies
• 4. Restoring and Recovering the Database on a New Host
• 5. Performing Disaster Recovery
• 6. Using RMAN to Duplicate a Database

• 1. Creating a Duplicate Database
• 2. Creating an Initialization Parameter File for the Auxiliary Instance
• 3. Allocating Auxiliary Channels
• 4. Understanding the RMAN Duplication Operation
• 5. Using EM to Clone a Database
• 6. Cloning a Running Database
• 7. Performing Tablespace Point-in-time Recovery

• 1. Tablespace Point-in-Time Recovery: Architecture
• 2. Understanding When to Use TSPITR
• 3. Determining the Tablespaces for the Recovery Set
• 4. Using Enterprise Manager to Perform TSPITR
• 5. Understanding TSPITR Processing
• 6. Troubleshooting RMAN TSPITR
• 7. Monitoring and Tuning RMAN

• 1. Monitoring RMAN Sessions
• 2. Interpreting RMAN Message Output
• 3. Using the DEBUG Option
• 4. Tuning RMAN
• 5. RMAN Multiplexing
• 6. Comparing Synchronous and Asynchronous I/O
• 7. Tape Subsystem Performance Rules
• 8. Using Flashback Technology

• 1. Transactions and Undo
• 2. Guaranteeing Undo Retention
• 3. Preparing Your Database for Flashback
• 4. Flashback Drop and the Recycle Bin
• 5. Using Flashback Technology to Query Data
• 6. Possible Workflow
• 7. Flashback Transaction Wizard
• 8. Using Flashback Database

• 1. Enabling Row Movement on a Table
• 2. Flashback Database Architecture
• 3. Configuring Flashback Database
• 4. Performing Flashback Database Using EM
• 5. Flashback Database Considerations
• 6. Flashback Data Archive
• 7. Diagnosing the Database

• 1. Location for Diagnostic Traces
• 2. Viewing the Alert Log Using Enterprise Manager
• 3. The Support Workbench and Oracle Configuration Manager
• 4. Create a Service Request
• 5. Package and upload diagnostic data to Oracle Support
• 6. Incident Packaging Configuration
• 7. Health Monitor Overview & Data Recovery Advisor
• 8. Managing Memory

• 1. Automatic Memory Management Overview
• 2. Oracle Database Memory Parameters
• 3. Auto Memory Parameter Dependency
• 4. Automatic Shared Memory Management: Overview
• 5. Automatic PGA Memory Management
• 6. Using the Memory Advisor to Size the SGA
• 7. Memory Tuning Guidelines for the Library Cache
• 8. Managing Database Performance

• 1. Performance Planning & Performance Tuning Methodology
• 2. Instance Tuning
• 3. Troubleshooting and Tuning Views
• 4. Automatic Workload Repository
• 5. SQL Tuning & SQL Advisors
• 6. Using the SQL Tuning Advisor
• 7. SQL Access Advisor: Overview
• 8. Using the Segment Advisor

• 1. Proactive Tablespace Monitoring
• 2. Thresholds and Resolving Space Problems
• 3. Monitoring Tablespace Space Usage
• 4. Shrinking Segments
• 5. Space Reclamation with ASSM
• 6. Automatic Segment Advisor
• 7. Minimum Compatibility Level
• 8. Managing Resources

• 1. Database Resource Manager Concepts
• 2. Accessing Resource Plans
• 3. Default Maintenance Resource Manager Plan
• 4. Creating Consumer Groups
• 5. Resource Allocation Methods for Resource Plans
• 6. Resource Allocation Methods for Resource Plans
• 7. Monitoring the Resource Manager
• 8. Automating Tasks with the Scheduler

• 1. Key Components and Steps
• 2. Creating an Event-Based Schedule
• 3. Creating Complex Schedules
• 4. Creating Job Chains
• 5. Creating Job Chains
• 6. Administering the Scheduler

• 1. Job Classes
• 2. Windows
• 3. Prioritizing Jobs Within a Window
• 4. Remote Jobs
• 5. Installing the Scheduler Agent
• 6. Dictionary Views Supporting Remote Jobs
• 7. Globalization

• 1. What Every DBA Needs to Know
• 2. Understanding Unicode
• 3. Database Character Sets and National Character Sets
• 4. Language- and Territory-Dependent Parameters
• 5. Linguistic Searching and Sorting
• 6. Case- and Accent-Insensitive Search and Sort
• 7. NLS Data Conversion with Oracle Utilities

• 1. Overview of the Oracle Database 12c
• 2. Overview of the Oracle Cloud
• 3. Relational database concepts
• 4. Database administration tasks

• 1. Overview of the Oracle database architecture
• 2. The Oracle database instance
• 3. Oracle Database memory structures
• 4. Process architecture and structures
• 5. Server and client processes
• 6. The Oracle database storage architecture
• 7. Connect to the Oracle database instance

• 1. Administrative tools available to a DBA
• 2. Use SQL*Plus in Oracle to manage a database instance
• 3. Use SQL Developer to manage a database instance
• 4. Administer the database using Enterprise Manager (EM)
• 5. Overview of the Enterprise Manager framework
• 6. Access Enterprise Manager Database Express
• 7. The Enterprise Manager Database Express Home Page
• 8. Enterprise Manager Cloud Control
• 9. Initialization parameter files

• 1. Overview of network configuration
• 2. Oracle Net Listener configuration and management
• 3. Oracle Net naming methods
• 4. Tools for configuring and managing the Oracle network
• 5. Using the Net Configuration Assistant
• 6. Configure client connections with Net Manager
• 7. View listener configuration
• 8. Start and stop the Oracle listener
• 9. Use TNSPING to test Oracle Net connectivity
• 10. Connect to the database
• 11. Configure Net Services with Enterprise Manager

• 1. Overview of data storage
• 2. The database block
• 3. Overview of tablespaces and datafiles
• 4. Use Enterprise Manager to view the storage structure of the database
• 5. Create and alter tablespace commands
• 6. Temporary tablespaces
• 7. Create and manage datafiles
• 8. Use OMF
• 9. Drop tablespaces and datafiles

• 1. Predefined database administration accounts
• 2. User accounts
• 3. Create a user account
• 4. User authentication
• 5. Change a user's password
• 6. Manage a user account
• 7. Drop a user account
• 8. Monitor user information
• 9. Terminate user sessions

• 1. Overview of user profiles
• 2. Profile resource parameters
• 3. Create profile command
• 4. Manage passwords with profiles
• 5. Control resource usage with profiles
• 6. Maintain profiles

• 1. Database access
• 2. Oracle supplied roles
• 3. System and object level privileges
• 4. The grant and revoke commands
• 5. Create, modify and drop roles
• 6. Use predefined roles

• 1. Overview of database security
• 2. Overview of database auditing
• 3. Security compliance
• 4. Standard auditing
• 5. Unified audit trail
• 6. Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
• 7. Configure the audit trail
• 8. Specify audit options

• 1. Levels of locking in Oracle
• 2. Methods used to acquire locks
• 3. Data concurrency
• 4. Possible causes of contention
• 5. DML locks
• 6. Prevent locking problems
• 7. Detect lock contention
• 8. Resolve conflicts

• 1. Undo data overview
• 2. Monitor and administer undo
• 3. Configure undo retention
• 4. Switch undo tablespaces
• 5. Specify the retention period
• 6. Guarantee undo retention
• 7. Retention period for flashback queries
• 8. View undo space information
• 9. Use the undo advisor
• 10. Size the undo tablespace
• 11. Alter an undo tablespace to a fixed size

• 1. Database Maintenance
• 2. View the alert log
• 3. The Automatic Workload Repository
• 4. Statistic levels
• 5. The Automatic Database Diagnostic Monitoring
• 6. Monitor an Oracle database
• 7. Use the Advisors
• 8. Set up notification rules

• 1. Tuning information sources
• 2. Performance monitoring
• 3. Tuning activities
• 4. Performance planning
• 5. Instance tuning
• 6. Performance tuning methodology
• 7. Performance tuning data
• 8. Monitoring performance
• 9. Managing memory

• 1. SQL tuning
• 2. The Oracle Optimizer
• 3. SQL Plan directives
• 4. Adaptive execution plans
• 5. SQL Advisors
• 6. Automatic SQL Tuning results
• 7. Implement automatic tuning recommendations
• 8. SQL Tuning Advisor

• 1. Create directory objects
• 2. Data Pump architecture
• 3. Data Pump data dictionary views
• 4. Data Pump interactive mode
• 5. Data Pump API
• 6. Use Data Pump to export data
• 7. Use Data Pump to import data
• 8. Overview of SQL Loader
• 9. Command line parameters
• 10. Record filtering
• 11. Control file keywords
• 12. Datafiles
• 13. SQL Loader data paths
• 14. External Tables

• 1. Introduction to the Scheduler
• 2. Access Rights
• 3. Scheduler components and workflow
• 4. Create a Job
• 5. Job Classes
• 6. Use time based, event based schedules
• 7. Create an event based schedule
• 8. Oracle Database 12c Administration Training Course

• 1. Overview of the Database Resource Manager
• 2. Use the Resource Manager
• 3. Create Resource Plans
• 4. The default maintenance resource manager plan
• 5. Create Resource Plan Directives
• 6. Allocate resources for Resource Plans

• 1. Overview of space management
• 2. Block space management within segments
• 3. Segment types
• 4. Allocate extents
• 5. Allocate space
• 6. Row chaining and migration
• 7. Create tables without segments

• 1. Oracle backup solutions
• 2. Oracle suggested backup strategy
• 3. Overview of database backup, restore and recover
• 4. Flashback technology
• 5. Types of failure
• 6. Instance recovery
• 7. Tune instance recovery
• 8. The MTTR Advisor
• 9. Media failure
• 10. Configure a database for recoverability

• 1. The Enterprise Manager Support Workbench
• 2. Register for security updates
• 3. Work with Oracle Support
• 4. My Oracle Support integration
• 5. Log Service Requests
• 6. Manage patches
• 7. Apply a patch