• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

This training program is designed to prepare the students for Oracle SOA Suite Developer. The Oracle SOA Suite11g Implementation training provides relevant insight to current and prospective implementers of SOA. Participants will learn how to develop and implement solutions using SOA Suite 11g that will drive their customers organizations to make better decisions, take informed actions, and run more-efficient business processes.


Duration : 30 hours


Fee: 299


Job Trends


Who Should Learn?
Fresh Engineering Graduates
Prerequisite

This certification training course does not presume or require any prior knowledge or prerequisites. However, basic knowledge of salesforce concepts be an added advantageous. We are recommending that students should have following: To be an administrative professional Should possess clear knowledge and grasp of salesforce concepts knowledge on SQL, HTML and JavaScript should be an added advantage

Delivery Methodology
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Class Delivery
Live Interactive classes with expert

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Oracle 12c Administration

Oracle 12c: New Features for DBA

Required Prerequisites:

Oracle Database: Introduction to SQL
Good knowledge of Oracle Database Administrator 11g

Basics of Multitenant Container Database (CDB)

  • Benefits of the multitenant architecture
  • Differences between the root container and pluggable database containers
  • Structure of the root
  • Structure of Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx views
  • Configuring and Creating CDB and PDBs
  • Tools: DBCA and SQL*Plus

Configuration and creation of CDB

  • Exploring the Structure (CDB_xxx views and EM)
  • Tools used: DBCA and SQL*Plus and EM Database Express
  • Create a new PDB from PDB$SEED
  • Create a PDB from a non-CDB
  • Plug in an unplugged PDB

Managing CDB and PDBs

  • Connect to CDB as administrator
  • Connect to a PDB using a service name
  • Start up a CDB
  • Open / Close a PDB (SQL*Plus)
  • Open / Close all PDBs
  • Shut down a CDB
  • Change PDB state

Managing Tablespaces, Common and Local Users, Privileges and Roles

  • Create permanent tablespaces in the root and PDBs
  • Manage common and local schemas and users in the root and PDBs
  • Manage system and object privileges to common and local grantees granted "commonly" or "locally"
  • Manage common and local roles granted "commonly" or "locally"

Managing Backup / Recovery / Flashback

  • Backup a whole CDB
  • Backup a PDB
  • Recover CDB from redo log files, control files, undo datafiles loss
  • Recover PDB from PDB datafiles loss
  • Flashback at CDB level

Online Datafile Move and Automatic Data Optimization

  • Automatic movement and compression
  • Compression levels and types
  • Policy declaration: simple declarative SQL extension
  • Customized automated action execution with user-defined function
  • Customized schedule with DBMS_ILM package

In-Database Archiving

  • Challenges of old data in tables and 11g solutions
  • In-database archiving new solutions
  • Use ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Temporal Validity versus Temporal History (Transaction Time of FDA)
  • New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR
  • New SQL temporal data type

Auditing Enhancements

  • Review of 11g R2 audit trail implementation
  • Overview of the Unified Audit Trail
  • Enabling the Unified Audit Trail
  • Creating a separate tablespace for the unified audit trail
  • Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
  • Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
  • Creating audit policies

Privileges Enhancements

  • Implementing Separation of Duty for Database Administration Tasks
  • Using Database Privilege Analysis
  • Overview of Database Privilege Analysis
  • Granting the CAPTURE_ADMIN role to enable management of privilege captures
  • Creating and starting/stopping privilege captures
  • Viewing privilege profile data
  • Querying DBA_PRIV_CAPTURES
  • Explaining the purpose of the default ORA$DEPENDENCY profile

Oracle Data Redaction

  • Overview of Oracle Data Redaction
  • Types of Masking Policies
  • Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Managing Masking Policies
  • Best practices for defining policy expressions
  • Understanding Masking of Statements Containing Subqueries
  • Viewing Information About Masking Policies by Querying REDACTION_POLICIES and
  • REDACTION_COLUMNS

General RMAN New Features and FDA Enhancements

  • Making Database Connections With RMAN
  • Using the SYSBACKUP Privilege
  • Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
  • Backing up and Restoring Very Large Files
  • Creating Multisection Backups
  • Table Level Recovery
  • Duplication of Database.

ADR and Network Enhancements

  • ADR file types
  • New File types
  • New File locations
  • New command for ADRCI

Resource Manager and Other Performance Enhancements

  • Manage resources between PDBs
  • Manage resources within a PDB
  • Manage resources with CDB and PDBs plans
  • Automated maintenance tasks
  • Current Architecture: Unixmultiprocess / one thread, NT/Windows one process / multithread
  • New Architecture: Multiprocess / MultiThread

Index and Table Enhancements

  • Multiple indexes on the same set of columns as long as some characteristic is different
  • Create table with INVISIBLE columns
  • Support for invisible columns
  • Describe online redefinition supports
  • Describe the Advanced Row Compression
  • Using the following DDL statements in an online manner

Use Case

Certificate

Certificate
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?