Enquiry

  Submit

Database - Oracle

software development Applications,Production support and training

Courses

Oracle DB 19c SQL Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Oracle DB 19c SQL Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Oracle DB 19c SQL Training Certificate

Oracle DB 19c SQL Course Contents

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using Set Operators
  • Managing Tables Using DML Statements in Oracle
  • Introduction to Data Definition Language in Oracle
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, and Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data Using Advanced Queries
  • Managing Data in Different Time Zones

Courses

Oracle DB 19c PL/SQL Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Oracle DB 19c PL/SQL Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Oracle DB 19c PL/SQL Training Certificate

Oracle DB 19c PL/SQL Course Contents

  • Introduction
  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Using SQL Statements Within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Introducing Stored Procedures and Functions
  • Creating Procedures
  • Creating Functions
  • Debugging Subprograms
  • Creating Packages
  • Working with Packages
  • Using Oracle-Supplied Packages in Application Development
  • Using Dynamic SQL
  • Creating Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Design Considerations for the PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies

Courses

Forms and Reports Course Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Forms and Reports Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Forms and Reports Course Training Certificate

Forms and Reports Course Contents

  • Introducing Oracle Forms Developer and Forms Services
  • Creating Forms Modules
  • Working with Data Blocks and Frames
  • Working with Input Items
  • Working with Non Input Items
  • Working with Windows and Canvases
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run-Time Messages and Alerts
  • Query Triggers
  • Validation
  • Navigation
  • Transaction Processing
  • Writing Flexible Code
  • Sharing Objects and Code
  • Using WebUtil to Interact with the Client
  • Introducing Multiple Form Applications

Oracle Reports Course

  • Basic Concepts
  • Visual Index
  • Practical’s

Courses

Oracle 19c DBA Course at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Oracle 19c DBA Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Oracle 19c DBA Course Certificate

Oracle 19c DBA Course Contents

  • Introduction
  • Exploring Oracle Database Architecture
  • Oracle Database Management Tools
  • Managing the Database Instance
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Managing Database Storage Structures
  • Managing Space
  • Managing Undo Data
  • Managing Data Concurrency
  • Implementing Oracle Database Auditing
  • Backup and Recovery: Concepts
  • Backup and Recovery: Configuration
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Database Maintenance
  • Managing Performance
  • Managing Performance: SQL Tuning
  • Using Database Resource Manager
  • Using Oracle Scheduler to Automate Tasks
  • Appendix A: Working with Oracle Support

Courses

Oracle Database 19c - RAC Administration Workshop at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Oracle Database 19c - RAC Administration Workshop, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Oracle Database 19c - RAC Administration Workshop Certificate

Oracle Database 19c - RAC Course Contents

  • Grid Infrastructure: Overview
  • RAC Databases Overview and Architecture
  • Installing with Configuring Oracle RAC
  • Oracle RAC Administration
  • Upgrading and Patching Oracle RAC
  • Managing Backup and Recovery for RAC
  • Managing High Availability of Service
  • High Availability for Connections and Applications
  • Multitenant Architecture and RAC
  • Quality of Service Management

Courses

Oracle Database 19c - Data Guard Administration Workshop at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Oracle Database 19c - Data Guard Administration Workshop, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Oracle Database 19c - Data Guard Administration Workshop Certificate

Oracle Database 19c - Data Guard Course Contents

  • Data Guard Components
  • Data Guard Transport Method
  • Differences between Failover and Switchover
  • Data Guard Framework
  • Data Guard Broker Configuration
  • Defining Gap Resolution
  • Defining Protection Modes
  • Operating System Requirements
  • Manually Creating a Physical Standby Database
  • Physical Standby Database and Cloud Control
  • Logical Standby Database
  • Using Cloud Control to Create a Logical Database
  • Backup Methods and Data Guard
  • Flashback Database and Data Guard
  • Backing up in a Data Guard Environment
  • Data Guard and Failover
  • Cloud Control and Failover
  • Data Guard and Switch Over
  • Cloud and Switch Over
  • Define Fast Start Failover
  • Failover Client
  • Define a Snapshot Standby Database
  • Oracle Active Data Guard
  • Managing Data Guard Components
  • Upgrading databases with Data Guard

Courses

Oracle Golden Gate 19c at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Oracle Golden Gate 19c Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Oracle Golden Gate 19c Certificate

Oracle Golden Gate 19c Course Contents

  • Oracle GoldenGate Architecture
  • Installing Oracle GoldenGate Microservices Architecture
  • Installing Oracle GoldenGate Classic Architecture
  • Preparing the Environment
  • Configuring the Extracts
  • Oracle GoldenGate Microservices Architecture: Distribution Server and Receiver Server
  • Configuring Initial Load
  • Configuring Replicate
  • Managing Extract Trails and Files
  • Oracle GoldenGate Parameters
  • Data Selection and Filtering
  • Data Transformation and Configuration Options
  • Oracle GoldenGate Microservices Architecture: Performance Metrics Server
  • Database Sharding Support
  • Replication Lag Management
  • Invisible Column Support

Courses

Apps DBA Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Apps DBA Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Apps DBA Training Certificate

Apps DBA Course Contents

  • Introduction to ERP
  • Introduction to Oracle E-Business Suite
  • Oracle E-Business Suite R12.2 Architecture
  • Creating and Installing R12.2 Staging Areas
  • Essential Files and File System in R12.2
  • R12.2 Administration
  • AppsDBA FMW Concepts - WebLogic
  • Patching in AppsDBA –ADOP
  • APPS DBA Online Patching (ADOP)
  • AD Utilities
  • AutoConfig - DB & Apps Tier
  • HTTP Server changes in22x
  • EBS R12.2 Cloning (DB & Apps Tier)
  • Password Management
  • Change management in22x
  • Concurrent Managers
  • Workflow Management
  • System Administration
  • Performance Tuning and Troubleshooting
  • Upgrading Oracle Apps

Courses

Performance Tuning Course Training at MIGHTY INFOTECH

MIGHTY INFOTECH, in-depth Performance Tuning Course Training Course, We offers with 100% placement in top CMM Level. We provide hands-on training and live projects and Performance Tuning Course Training Certificate

Categories

Frequently Asked Questions

FAQ

Why should I learn this course from MIGHTY INFOTECH?
  • Individual Attention
  • 100% placement support
  • Experienced faculties
  • Liberal fees structure
  • We are following globally accepted syllabus
Is online Software Development and Software Testing courses training available in MIGHTY INFOTECH Technologies?
  • Both classroom and online Software Development and Software Testing courses training are available at MIGHTY INFOTECH Technologies Training Centre Chennai.
How about the placement assistance in MIGHTY INFOTECH?
  • Almost every student who is studying here are getting placed.
  • We offers grooming section for our students with our experts for getting idea on how to attend an interview.

All Courses

Our Clients