oracle [email protected]
TRANSCRIPT
![Page 2: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/2.jpg)
Oracle Database is the first database designed for enterprise grid computing
Commonly referred to as Oracle RDBMS
SDL (Software Development Liboratories) developed the original version of the Oracle software in 1977
The purpose of a database is to store and retrieve related information with most flexible and cost effective way
About Oracle
![Page 3: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/3.jpg)
A DBMS has the following elements: Kernel code This code manages memory and storage for
the DBMS. Repository of metadata This repository is usually called a
data dictionary. Query language This language enables applications to
access the data.
![Page 4: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/4.jpg)
A relational database is a database that conforms to the relational model. The relational model has the following major aspects:
Structures Well-defined objects store or access the data of
a database. Operations Clearly defined actions enable applications to
manipulate the data and structures of a database.
Integrity rules Integrity rules govern operations on the data
and structures of a database.
![Page 5: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/5.jpg)
An RDBMS distinguishes between the following types of operations:
Logical operationsIn this case, an application specifies what content is required.
Physical operations In this case, the RDBMS
determines how things should be done and carries out the operation.
The relational model is the basis for a relational database management system (RDBMS)
![Page 6: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/6.jpg)
Enterprise Edition: Offers all features, including superior performance and security, and is the most robust
Standard Edition: Contains base functionality for users that do not require Enterprise Edition’s robust package
Express Edition (XE): The lightweight, free and limited Windows and Linux edition
Oracle Lite: For mobile devices
Oracle DB editions are hierarchically broken down as
![Page 7: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/7.jpg)
Oracle 11G Course content:-
1.Introduction.
o Identify the oracle product o Describe the basic concept of a relational database
2.Installing oracle database 11g software.
o System requirements. o Red hat Linux Installation o Install software with the Oracle Universal Installer
on Linux Platform
Contents of Oracle
![Page 8: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/8.jpg)
3.Create an oracle database.
o Oracle Database Architecture o Oracle instance architecture o Oracle Read Consistency and Concurrency
4.Controlling the database.
o Start and stop the agent o Start and stop the enterprise manager
database console o Start and stop the listener o Startup and shutdown the database
![Page 9: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/9.jpg)
5.Database Creation.
o Manual o Database Configuration
Assistant(DBCA)
6.Storage Structures.
o Defining the table spaces and data files o Create table spaces o Manage table spaces o Obtain table space information
![Page 10: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/10.jpg)
7.File Management.
o Control File Management o Redo Log File Management o Parameter File Management o Obtain table space information
8.Administering users .
o Create and manage database user accounts o Create and manage roles o Grant and revoke privileges o Control resource usage by using Profiles
![Page 11: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/11.jpg)
9.Oracle Net Services.
o Understand Oracle Net concepts o Use Oracle Net Manager to create and configure
listeners o Use the listener control utility to control the Oracle
Net Listener o Use the Oracle Net Manager to configure client
and middle-tier connection o Use TNSPING to test Oracle Net connectivity
10.Managing schema objects.
o Create and modify tables o Define constraints o View the attributes of a table o View the contents of a table o Create indexes and views
![Page 12: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/12.jpg)
11.Oracle Backup & Recovery (User Managed).
o Introduction o Design, Testing, Implementation Strategies o Offline(cold)/Online(hot) backups o Performing Complete Recovery o Performing Incomplete Recovery
12.Oracle Backup & Recovery (System Managed: RMAN).
o Introduction o RMAN Architecture o Configuration o Setting up Catalog o Online/Offline Backup using RMAN o Backups Options O Incremental Backups, o Scripts, o Complete Recovery
![Page 13: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/13.jpg)
O Incomplete Recovery o Table Space Point in Time Recovery (TSPITR) o Disaster Recovery o Recovery of Corrupted DB-Blocks
13.Cloning.
o RMAN o Manual
14.Logical Backup & Restore.
o Introduction Data pump (expdp, impdp) Utilities o Exporting/Importing Tables o Exporting/Importing Schemas o Exporting/Importing Table space o Exporting/Importing Database o Transportable Table space within & across the database
and platforms.
![Page 14: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/14.jpg)
15.High Availability(HA).
o Database Patch Management Introduction o Applying Interim and Patch set Patches o Patch History & Documentation
16.Log Miner.
Contents Reading / Extracting the Content of Redo
Logs (Online/archived) for recovery or auditing purpose
![Page 15: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/15.jpg)
17.Flashback.
o Introduction o Configuration o Flashback Query/Table/Drop/Database o Flashback Version Query o Creating Restore Points
18.Automatic Storage Management.
o Introduction Data pump (expdp, impdp) Utilities o Exporting/Importing Tables o Exporting/Importing Schemas o Exporting/Importing Table space o Exporting/Importing Database o Transportable Table space within & across the database
and platforms
![Page 16: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/16.jpg)
Salient Features of Embedded Systems :
80% hands on / practical classes. Real time Scenarios / Project Exposure. Limited no of students per batch. Corporate Training Atmosphere Week end Batches to suit Professional. Placement Assistance which includes1. Resume Preparation 2. Individual Counselling3. Offline Support, which includes email queries and assignments.4. Association with people who are working for more than 20
Companies who may provide interviews . Backup Classes. Provision to come for one mor batch.
![Page 17: ORACLE oracle.bng@rockfortnetworks.com](https://reader036.vdocuments.us/reader036/viewer/2022083008/56649e905503460f94b94b72/html5/thumbnails/17.jpg)