8.jpg) |
| ### ORACLE 11G DBA ONLINE TRAINING ### |
|
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 :
13 |
Training Center / Institute Name :
keen IT Technologies Pvt. Ltd. |
About the Institute :
Keen IT Technologies is a leading global consulting and IT services company, specialized in SAP FICO,TIBCO,CCNA,SHAREPOINT,BW,BI,ABAP,SAS,TESTINGTOOLS,JAVA,MS DOTNET,IBM MAINFRAMES,PEGA,Oracle Apps & Datawarehousing space that offers a wide array of solutions for a range of key verticals and horizontals. Starting from the strategy consulting right through to implementing IT solutions for clients, operates through this entire space.We offer online training on SAP FICO,TIBCO,CCNA,SHAREPOINT,BW,BI,ABAP,SAS,PEGA,Oracle Apps,Data warehousing and Networking. Also we provide projects for B.Tech,MCA and MBA students
|
Trainings :
Online
|
Fees :
NEGOTIBLE
|
Batch Timing :
FLEXIBLE
|
About Training Center :
Keen IT Technologies is one of the Leading Software Training center is Hyderabad. We provide Online training. We offer Quality training in the latest IT Technologies by Real Time Experienced Faculty with excellent course materials. Courses offered SAP (All Modules), Oracle Apps Functional and Technical, Testing tools, Data warehousing. Attend free demo classes to Experience the Quality of our Training. We also offer Fast track and Weekend training.
|
Address / Colony:
Plot No: 133 Near Anjaneya Swami Temple, Sarada Nagar, Vanasthlipuram Hyderabad – 500070.
Sarada Nagar |
City :
Hyderabad |
Contact Person :
Mr.srinivas |
Phone No:
040-20063292 |
| www.keentechnologies.com |
Contact Institute
(This Institute got
0 email Responses so far)
|
Student /
Training Center
