[demo_space height=”10px”]

[two_third]

[fancy_box title=”Overview of the Training Course”]

[dropcap1 color=”pumpkin”]O[/dropcap1]racle 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.[/fancy_box]

[/two_third]

[one_third_last]

[image lightbox=”true” src=”/wp-content/uploads/2019/03/oracle_cover_1024x768.jpg”]

[/one_third_last]

[divider style=”thin” margin=”60px 0 40px 0″]

[tabs type=”horizontal”]

[tab title=”Course Objective” tabcolor=”” textcolor=””]

[demo_space height=”20px”]

[fancyheading heading=”h4″]After this course an attendee will be able to:[/fancyheading]
[list style=”style1″ color=”orange”]

• 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

[/list]

[/tab]

[tab title=”Course Outline” tabcolor=”” textcolor=””]

[demo_space height=”20px”]

[two_third]

[fancyheading heading=”h5″]This course course has been divided into 3 parts[/fancyheading]

[demo_space height=”20px”]

[accordion-wrap animation=”bounce”]

[accordion title=”Part 1: SQL Fundamentals” icon=”icon-thumbs-up” active=”false”]

[fancyheading heading=”h4″]Part 1: SQL Fundamentals[/fancyheading]

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.

[list style=”bullet1″ color=”green”]

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

[/list]

[demo_space height=”20px”]

[/accordion]

[accordion title=”Part 2: Oracle Administration I” icon=”icon-thumbs-up” active=”false”]

[demo_space height=”10px”]

[fancyheading heading=”h4″]Part 2: Oracle Administration I[/fancyheading]

Primary objectives of this course include:

[list style=”bullet1″ color=”green”]

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.

[/list]

[demo_space height=”20px”]

[/accordion]

[accordion title=”Part 3: Oracle Administration II” icon=”icon-thumbs-up” active=”false”]

[demo_space height=”20px”]

[fancyheading heading=”h4″]Part 3: Oracle Administration II[/fancyheading]

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.

[list style=”bullet1″ color=”green”]

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.

[/list]

[/accordion]

[/accordion-wrap]

[/two_third]

[/tab]

[tab title=”Schedule” tabcolor=”” textcolor=””]

[demo_space height=”10px”]

[icons style=”square” size=”large” color=”#e6567a” bordercolor=”#e6567a” icon=”icon-bullhorn”]

[demo_space height=”10px”]

[/tab]

[tab title=”Register Online” tabcolor=”” textcolor=””]

[demo_space height=”10px”]

[one_half]

[callout bgcolor=”#e6e6e6″ buttonlink=”https://my.chromeis.com/cart.php?a=add&pid=53″ linktarget=”_blank” color=”greensea” buttontext=”Register!” buttonsize=”medium” style=”border”]

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

[demo_space height=”20px”]

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

[demo_space height=”20px”]

[/callout]

[/one_half]

[one_half_last]

[fancy_box title=”Premium toppings, because we’re different” titlebgcolor=”#1abc9c” titlecolor=”#ffffff” textcolor=”#ffffff” boxbgcolor=”#2c3e50″ ribbon=”03″]

[list style=”bullet1″ color=”green”]

• 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

[/list]

[/fancy_box]

[/one_half_last]

[demo_space height=”10px”]

[/tab]

[/tabs]

[divider style=”thin” margin=”60px 0 40px 0″]

[two_third]

[accordion-wrap animation=”bounce”]

[accordion title=”Course Project” icon=”icon-thumbs-up” active=”false”]
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.
[/accordion]
[accordion title=”Training Philosophy” icon=”icon-thumbs-up” active=”false”]
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
[/accordion]

[accordion title=”Certifications and Reward” icon=”icon-thumbs-up” active=”false”]
[fancyheading heading=”h4″]Aim for following certifications:[/fancyheading]

[demo_space height=”10px”]

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

[demo_space height=”10px”]

[fancyheading heading=”h4″]You should be prepared to pass for below exams:[/fancyheading]

[demo_space height=”10px”]

1Z0-809:     

[demo_space height=”10px”]

[/accordion]

[accordion title=”Program Fee and Discount” icon=”icon-thumbs-up” active=”false”]

[fancyheading heading=”h4″]Various ways to save money[/fancyheading]

[demo_space height=”10px”]

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)

[demo_space height=”10px”]

[/accordion]
[/accordion-wrap]

[/two_third]

[one_third_last]

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

[button link=”https://my.chromeis.com/submitticket.php” color=”orange” size=”medium” fullwidth=”false”]Contact Us![/button][/one_third_last]