ChromeIS Pvt. Ltd. is proud to be a Microsoft Partner!

Oracle 19c

A.I, Cloud Security, Agnostic

Overview of the Training Course

Oracle professionals, both business and systems professionals, who wish to achieve various Oracle certification exams and need a “how to” guide to acquire the knowledge of SQL are primary target of this course.

For non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL can also be benefited.

This course will be helpful for developers, database administrators, Web server administrators, System administrators, Implementation specialists, Data center support engineers, Senior application designers and developers.

After this course an attendee will be able to:

  • Fundamentals: Install & Configure, Normalization
  • Designing, Implement and Manage Databases, Transaction Logs & Database Snapshots
  • Create Tables, UDTs, Triggers, Views, Stored Procedure & Functions
  • Implement Constraints, Triggers, Indexes & User Defined Data Types, Full-Text search
  • Working With Data Using Transact-SQL And Management Studio
  • Managing XML data in SQL Server, Implementing HTTP Endpoints, Service Broker Components
  • Implement database security, permissions, configure Linked Servers & Import/Exporting, Data using Linked Servers
  • Implementing Database Mirroring & Log Shipping
  • Manage Complex Multi-Step Jobs with SQL Server Agent
  • Manage XML Data & Implement HTTP End-Point
  • Administer Databases (Backup, Restore & Replication)
  • Design Transactions that Maximize Concurrency and Minimize Contention
  • Implementing High Availability and Disaster Recovery, Performance Tuning, Monitoring
  • Analyze and fix Performance Problems using SQL Server 2016 Tools for Accordion.
  • Understanding Data Warehousing & Data Mining and Introduction To Business Intelligence And Reporting
This course course has been divided into 3 parts
Part 1: SQL Fundamentals

Part 1: SQL Fundamentals

The 1st Part provides an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.

  1. Volume 1
    1. Relational Databases & SQL
    2. Choosing a SQL & PL/SQL Interface
    3. Building a Select Statement
    4. Restricting Data with the Where Clause
    5. Sorting Data with the Order by Clause
    6. Using the Set Operators
    7. Summary Functions
    8. Using Sub-Queries
    9. Aggregating Data within Groups
    10. Build Simple SQL Plus Reports
    11. Use Data Definition Language to Create and Manage Tables
    12. Use Data Manipulation Language to Manipulate Data
    13. Appendix A
  2. Volume 2
    1. SQL99 Join Techniques
    2. Enhancing Groups with Rollup and Cube
    3. Using the Case Expression SQL Functions: Character
    4. SQL Functions: Numeric
    5. SQL Functions: Date
    6. Database Objects: Relational Views
    7. Database Objects: Data Dictionary Storage
    8. Database Objects: Indexes
    9. Database Objects: Other Objects
    10. Database Objects: Security
    11. Data Integrity Using Constraints
    12. Managing Constraint Definitions
    13. Advanced SQL Plus Reports
    14. Optional – Advanced SQL Plus Reports
    15. Optional – Building SQL Plus Scrips
    16. Optional – SQL Plus Session Control
Part 2: Oracle Administration I

Part 2: Oracle Administration I

Primary objectives of this course include:

  1. Installation and Upgrade Volume
    1. Configuration of the Linux and MS Windows, anticipation of a database installation
    2. Server class installation, verify configuring of Oracle Enterprise edition
    3. Database administrator interface options, Enterprise Manager, command-line SQL*Plus, and terminal console SSH
    4. Upgrade, Un/De-installation and Patching
  2. Volume A
    1. Manually Starting & Stopping Database Services & components
    2. Exploring the Oracle Database Architecture: General
    3. Exploring the Oracle Database Architecture: Instance Memory
    4. Exploring the Oracle Database Architecture: Instance Processes
    5. Creating an Oracle Database
    6. Management of database files
    7. Enabling Transparent Data Encryption
    8. Manage Databases Storage Structures: TableSpaces
    9. Manage Database Storage Structures: Advanced TableSpaces
    10. Manage Database Storage Structures: Data Files & Temp Files
    11. Managing Undo Data
  3. Volume B
    1. Network Environment: Oracle Net Services
    2. Network Environment: Oracle Shared Servers
    3. Security: Implementing Database Security
    4. Security: Administering User Security
    5. Moving Data: SQL Loader
    6. Moving Data: Export & Import
    7. Advanced self-tuning and self-management capabilities, Oracle-Managed
      Files, database Advisors and other components of the Management Framework.
    8. Database Maintenance & Performance Monitoring
    9. Managing Concurrency & Locks
    10. Backup and Recovery Concepts and Configuration
    11. OS specific considerations for Linux and MS Windows Server.
Part 3: Oracle Administration II

Part 3: Oracle Administration II

This part brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise.

  1. Volume A: Advanced Database Administration
    1. Managing Memory
    2. Managing Storage & The Segment Advisor
    3. Globalization to support multi-lingual, currencies, time zones and countries.
    4. Diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure, Database Instance Health monitor and the Support Workbench to capture and process fault data.
    5. Diagnosing Database Problems
    6. Recovery Concepts
    7. Configuring the database to recover from a wide variety of failures. This includes configuring redo log files and the Flash or Fast Recovery Area.
    8. Oracle Flashback Technology
    9. Recover from user errors, database failures, including Flashback Data Archive and Flashback Transaction Backout as part of the Oracle Total Recall technology.
    10. Flashback Database & Flashback Data Archive
  2. Volume B: Resource Manager & Scheduler
    1. Managing Resources
    2. Automating Tasks with the Scheduler (Basic)
    3. Automating Tasks with the Scheduler (Advanced)
    4. Managing Database Performance
    5. Automatic database management, monitoring and tuning facilities.
    6. Automatic management of storage space and memory resources within the database
    7. Role of the Segment Advisor and Memory Advisors.
  3. Volume C: RMAN Backup & Recovery
    1. Instance Recovery
    2. Configuring RMAN
    3. Backup with RMAN
    4. RMAN Management with EM
    5. User-Managed Recovery Operations
    6. Recovery with RMAN
    7. Using the RMAN Recovery Catalog
    8. Database Duplication & Cloning
    9. Advanced RMAN Capabilities
    10. Transporting TableSpaces
    11. Recovering From Corruption with Data Recovery Advisor
    12. Resuming database operations when facing failures in storage space allocation and errors.
    13. Setting metric and alert thresholds for proactive database monitoring.
    14. Using deferred segment creation to improve performance and establish efficient use of space.

I’m in. Get me registered for next session!

We’ve got you covered with 100% moneyback guarantee, if:

  1. Should you wish to opt out 2 weeks before progam starts!
  2. We decide to cancel the program

Premium toppings, because we're different

  • Secure “unlimited free for life” revisions for this course by paying just 20% extra when you sign up.
  • Buy CHROMEIS premium exam for additional $10
Course Project
Participants will develop a commercial level distributed database with help of their trainer. They will also plan & implement its replication on multiple servers as well as backup & restoration of the database.
Training Philosophy
Around 24 contact hours
Training contents have been developed by Industry professionals
Detailed discussions and experience sharing. Case studies from across industries
Interactive sessions, promoting inquisitive audience
Self assessment assignments
Certifications and Reward

Aim for following certifications:

OCP:        Oracle Certified Programmer
CHROMEIS    Certificate of Attendance of subject training
CHROMEIS    Certified Oracle Certified Professional (subject to passing CHROMEIS quiz)

You should be prepared to pass for below exams:

1Z0-809:     

Program Fee and Discount

Various ways to save money

10% discount:      on a group of at least 2 participants
25% discount:      on a group of 4 participants with early registration
50% discount:      (if you've previously taken this course from us)

Other Question?

Please contact us and our 24X7 team will be happy to answer your queries.
You can also call (03)-111-000-229 or drop email to trainings @ chromeis.com

Contact Us!