Call
whatsapp
8089080088 | 9447387064 | 9847003556
info@trinitytechnology.in
9447387064 | 9847003556
8089080088
Home | About Us | Software Development
IT Training | Placement | Contact Us | Location
HOME Oracle

Oracle provides a range of industry-leading on-premise and cloud-based solutions to meet the data management requirements from small and medium sized businesses to large global enterprises. These include the latest generation of the world's most popular database, Oracle Database 18c.

Overview of Oracle Grid Architecture

Grid computing is a new IT architecture that produces more resilient and lower cost enterprise information systems. With grid computing, groups of independent, modular hardware and software components can be connected and rejoined on demand to meet the changing needs of businesses.

The grid style of computing aims to solve some common problems with enterprise IT: the problem of application silos that lead to under utilized, dedicated hardware resources, the problem of monolithic, unwieldy systems that are expensive to maintain and difficult to change, and the problem of fragmented and disintegrated information that cannot be fully exploited by the enterprise as a whole.

Benefits of Grid Computing Compared to other models of computing, IT systems designed and implemented in the grid style deliver higher quality of service, lower cost, and greater flexibility. Higher quality of service results from having no single point of failure, a robust security infrastructure, and centralized, policy-driven management. Lower costs derive from increasing the utilization of resources and dramatically reducing management and maintenance costs. Rather than dedicating a stack of software and hardware to a specific task, all resources are pooled and allocated on demand, thus eliminating under utilized capacity and redundant capabilities. Grid computing also enables the use of smaller individual hardware components, thus reducing the cost of each individual component and providing more flexibility to devote resources in accordance with changing needs.

 

Grid Computing

The grid style of computing treats collections of similar IT resources holistically as a single pool, while exploiting the distinct nature of individual resources within the pool. To address simultaneously the problems of monolithic systems and fragmented resources, grid computing achieves a balance between the benefits of holistic resource management and flexible independent resource control. IT resources managed in a grid include:

  • Infrastructure: the hardware and software that create a data storage and program execution environment

  • Applications: the program logic and flow that define specific business processes

  • Information: the meanings inherent in all different types of data used to conduct business

ORACLE SYLLABUS

SQL

Retriving data using the SQL select statement]

Restricting and sorting data

Using single row function to customize output.

Reporting aggregated data using the grout function.

Displaying data from multiple tables –I

Displaying data from multiple tables-II

Using sub queries to solve problems

Using set operators

Manipulating data

Using DDL statements to create and manage tables

Creating other schema objects

Managing objects with data dictionary

Controlling User access

Managing schema objects

Manipulating large data sets

Generating report by grouping related data

Managing data in different time zones

Retrieving data using sub queries

Hierarchical retrieval

Regular expression support 

 

PL/SQL

Introduction

Declaring Variables

Writing Executable Statements

Interacting with Oracle Server

Writing Control Structures

Working with Composite Data Types

Writing Explicit Cursors

Writing Implicit Cursors

Handling Exceptions

Creating Procedures

Creating Functions

Managing Subprograms

Creating Packages

More Package concepts

Oracle supplied Packages

Manipulating Large Objects

Creating Database Triggers 

 More Trigger concepts

Managing Dependents

Admin I

Introduction

Installing the Oracle Database Structure

Creating an Oracle Instance

Managing the Oracle Instance

Managing Database Storage Structure

Oracle managed file(OMF)

Creating a table space

Administering security

Managing Schema Objects

Types of Indexes

Managing Data and Concurrency

Locking Mechanism

Managing Undo Data 

 Implementing Oracle Database Security

Configuring the Oracle Network environment

Proactive Maintenance

ADDM

Performance Management

Backup and Recovery Concept

Hot Backup

Cold Backup

Hands on practice

Performing Database Backups

Performing Database Recovery

Performing Flashback

Hands on practice

Flashback version query

Moving Data

Oracle Data pump

 Admin II:

Introduction

Oracle managed files

Configuring recovery manager

Using recovery manager

RMAN backup types

Hands on practice

Recovering from non critical loses

Database recovery

Types of incomplete recovery

Flashback

Dealing with database corruption

Hands on practice

Monitoring and managing memory

Automatic shared memory management

Automatic performance management

Automatic workload repository

Managed schema objects

Hands on practice

Clusters

Managing storage

Automatic storage management

ASM disk group

Portioning a disk

Managing resources

Automatic task with scheduler 

Database security

Transparent data encryption

Using globalization support

Hands on practice

 

 

 

 

Trinity Software Technologies
1st & 2nd Floor, Radheyam Tower, Gandhari Amman Kovil Road
Pulimood, Trivandrum.
Call: 9447387064 | 9847003556 | 0471-2335855 | 8089080088 | 0471-2334855
BSc Project, Msc Project, Btech Project, Mtech Project, MCA Project, Application Project, IEEE Project, PHP Project, ASP.Net Project, Java/J2EE Project, Python Project, Django Project, Angular Project, IOT Project, Internship in PHP, Internship in .Net, Internship in Java/J2EE, Internship in Networking, Internship in Ethical Hacking, Internship in Linux