|
|
| ORACLE 11G DBA ONLINE TRAINING @ KEEN IT TECHNOLOGIES |
8.jpg) |
|
Oracle 11G DBA
|
INTRODUCTION TO ORACLE DBA
- What is DBA ?
- Why a Company needs a DBA?
- Roles & Responsibilities
of DBA
- Oracle Architecture
- Physical and Logical Phase of
Database
- Types of files(Control file,
Redolog file and Datafile)
- Different types of Datafiles
- Instance
- SGA(System Global Area) and
Background Process
|
|
DATABASE CREATION
- Different Startup Modes
- Different Shutdown Modes
- Types of Database Creation
- Manual Method of Creation
|
|
TABLESPACE MANAGEMENT
- Introduction to Table space
- Types of Table space(BIG
& SMALL)
- Temporary Table space
- Altering/Renaming a Table
space
- Renaming a data file
- Temporary Groups
- Table space Encryption(11g)
|
|
STORAGE PARAMETERS
- What are segments?
- What are extents?
- What is Blocks?
- Oracle Blocks
- Estimation of Extents
- Dictionary Managed Table
space
- Locally Managed Table space
- Storage Parameters(Initial,
Next, Min Extents, Xtents, Pctincrease)
|
|
USER MANAGEMENT
- Who are Database Users?
- Why to create a User?
- Creation of Users
- Assigning Privileges
- Creating and granting Roles
- Allocating table space Quotas
to Users
- Assigning default table space
for the Users
- Setting Profiles for the
Users
- Levels of Authentication
- Schema Management(11g)
- Security(11g)
|
|
UNDO MANAGEMENT
- What is Undo?
- Why Undo required?
- Pending offline status
- Brief idea about Rollback
segments
- Flashback Features
- Flashback Table
- Flashback query
- Flashback Version query
|
|
SPFILE & OMF
- What is spfile?
- Difference between spfile and
pfile
- Advantages of spfile
- What is OMF?
- Advantages of OMF
- Files conventions of OMF
|
|
NETWORKING IN ORACLE
- Introduction to Oracle
Networking
- Network default location
- Editing Network file
- Introduction to Database
Links
- Types of Database Links
- Introduction to Materialized
views
- Advantages of Materialized
view
- Refresh Modes
|
·
Should you require any further information please do not
hesitate to contact us
Email id: trainings@keentechnologies.com
·
website
URL:http://www.keentechnoligies.com
|
Number of Views :
14 |
Training Center / Institute Name : Keen IT Technologies Pvt. Ltd. |
About the Institute :
Keen IT Technologies, started by a group of Trainers and HR Specialists team is truly a pioneer in the field of Training on different technologies with a proven track record of successfully undertaking Corporate, and Online Trainings with brilliant and qualitative professionals Trainers in multifarious positions in the ever-expanding arena of Information Technology ( IT ) in India. We have a large and elaborate list of corporate clients in Indian Market. Keen IT Technologies plans to expand to other major happening cities in India in the near future to provide its services to a larger clientele and play a significant and participative role in the revolutionary emergence of India as the forerunner of IT in the world
|
Trainings :
Online
|
Fees :
negotible
|
Batch Timing :
flexible
|
About Training Center :
Keen IT Technologies, started by a group of Trainers and HR Specialists team is truly a pioneer in the field of Training on different technologies with a proven track record of successfully undertaking Corporate, and Online Trainings with brilliant and qualitative professionals Trainers in multifarious positions in the ever-expanding arena of Information Technology ( IT ) in India. We have a large and elaborate list of corporate clients in Indian Market. Keen IT Technologies plans to expand to other major happening cities in India in the near future to provide its services to a larger clientele and play a significant and participative role in the revolutionary emergence of India as the forerunner of IT in the world
|
Address / Colony: Plot No: 133
Near Anjaneya Swami Temple,
Sarada Nagar, Vanasthlipuram,
Hyderabad – 500070.
saradanagar |
City : Hyderabad |
Contact Person : Mr.srinivas |
Phone No: 040-20063292 |
| http://www.keentechnologies.com |
Contact Institute
(This Institute got
0 email Responses so far)
|