|
Provided by: vAnzwer Technologies Oracle AdministrationDatabases and SQL |
 |
Overview
--------
In this intensive course, you will be introduced to the architecture of the Oracle11g Server.
In hands on exercises participants will learn to create and start up a database, enrol users, implement basic security measures and perform backup and recovery.
You will also learn how to manage logical and physical storage structures and manage access to data in the database by granting privileges to individual users.
Course Outline
--------------
ORACLE ARCHITECTURE
a Databases : Tablespaces and Data Files
a Database Structures: Schemas, Clusters, Hash Clusters, Segments, Extents, Blocks, etc.
a Instances :Internal Memory Structures: SGA, PGA
Process Structures: SMON, PMON, DBWR, LGWR, RECO, CKPT, ARCH, LCKn, Dnnn, Snnn
a Redo Log File Structure
a Control File Structure
a Start up and Shut down of the Database.
a Creating Databases,
DATABASE MANAGEMENT
a Creating, Managing Tablespaces and Segments
a Locally Managed Tablespaces
a Automatic segment- space management
a Management of the Oracle Server
a Multiple block sizes
a Dynamic SGA
a Server parameter file
a Default temporary tablespace
a Oracle managed files
a Managing Rollback Segments:
a Automatic undo management
a Flashback Query
DATABASE SECURITY
a Creating/ Revoking Users, User Profiles, Managing Roles, Password Protection, Managing Privileges.
a Database Auditing : Enable/ Disable, Login Audits, Action Audits and Object Audits
a Fine-grained auditing
DATABASE TUNING
SQL Statement Tuning
Optimizer modes
Hints
Plan stability and stored outlines
SQL tuning diagnostic tools
Interpret results from SQL tuning diagnostic tools
Tuning using 11g Advisors a
Tuning the SGA
Backup and Recovery
Export/ Import, Cold/ Hot Backups
Recovery from Instance Failure and Media Failure.
Backup and Recovery using RMAN.( Recovery Manager)
Recovery Manager (RMAN) Configuration
Creation of the catalog
Backup using RMAN
Recovery using RMAN
Contact
-------
Reena
09900105132 | 080-2529 7815
info@meritforge. com
Bangalore
--------
In this intensive course, you will be introduced to the architecture of the Oracle11g Server.
In hands on exercises participants will learn to create and start up a database, enrol users, implement basic security measures and perform backup and recovery.
You will also learn how to manage logical and physical storage structures and manage access to data in the database by granting privileges to individual users.
Course Outline
--------------
ORACLE ARCHITECTURE
a Databases : Tablespaces and Data Files
a Database Structures: Schemas, Clusters, Hash Clusters, Segments, Extents, Blocks, etc.
a Instances :Internal Memory Structures: SGA, PGA
Process Structures: SMON, PMON, DBWR, LGWR, RECO, CKPT, ARCH, LCKn, Dnnn, Snnn
a Redo Log File Structure
a Control File Structure
a Start up and Shut down of the Database.
a Creating Databases,
DATABASE MANAGEMENT
a Creating, Managing Tablespaces and Segments
a Locally Managed Tablespaces
a Automatic segment- space management
a Management of the Oracle Server
a Multiple block sizes
a Dynamic SGA
a Server parameter file
a Default temporary tablespace
a Oracle managed files
a Managing Rollback Segments:
a Automatic undo management
a Flashback Query
DATABASE SECURITY
a Creating/ Revoking Users, User Profiles, Managing Roles, Password Protection, Managing Privileges.
a Database Auditing : Enable/ Disable, Login Audits, Action Audits and Object Audits
a Fine-grained auditing
DATABASE TUNING
SQL Statement Tuning
Optimizer modes
Hints
Plan stability and stored outlines
SQL tuning diagnostic tools
Interpret results from SQL tuning diagnostic tools
Tuning using 11g Advisors a
Tuning the SGA
Backup and Recovery
Export/ Import, Cold/ Hot Backups
Recovery from Instance Failure and Media Failure.
Backup and Recovery using RMAN.( Recovery Manager)
Recovery Manager (RMAN) Configuration
Creation of the catalog
Backup using RMAN
Recovery using RMAN
Contact
-------
Reena
09900105132 | 080-2529 7815
info@meritforge. com
Bangalore
Related Software Programs or Products: Oracle 11g Database
Related Awards, Degrees or Certifications: Oracle DBA, OCP, OCA
Related Jobs or Careers: Oracle DBA
|
|
||||||||||||||||||
Training
Provided by vAnzwer Technologies
Oracle Administration
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic
database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a
conceptual understanding of the Oracle database architecture and how its components work and interact with one
another. You will also learn how to create an operational database and properly manage the various structures in an
effective and efficient manner including performance monitoring, database security, user management, and
backup/ recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is
designed to prepare you for the corresponding Oracle Certified Associate exam. This course counts towards the
Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or
instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and
Knowledge Center courses DO NOT meet the Hands-on Requirement.
Learn To:
Install the Database
Back up and Recover Data
Administer Users
Transport Data between Databases
Manage Data
Configure the Network
database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a
conceptual understanding of the Oracle database architecture and how its components work and interact with one
another. You will also learn how to create an operational database and properly manage the various structures in an
effective and efficient manner including performance monitoring, database security, user management, and
backup/ recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is
designed to prepare you for the corresponding Oracle Certified Associate exam. This course counts towards the
Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or
instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and
Knowledge Center courses DO NOT meet the Hands-on Requirement.
Learn To:
Install the Database
Back up and Recover Data
Administer Users
Transport Data between Databases
Manage Data
Configure the Network
About The Training Provider: vAnzwer Technologies
vAnzwer Technologies - MeritForge Infotech is a corporate training solution provider for middleware, database, Datawarehousing, Business Intelligence, ERP, CRM, Content Management and MDM products. Our strengths include
1. High quality training delivery
2. Solid relationship with a large pool of Freelance trainers
3. Competitive pricing
Please contact info at meritforge. com for further queries
info...
