 |
 |
|
|
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.
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.
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
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
