Shiksha Tarang has once again come up with the ORACLE DBA Training...!!! To get you to be the fore runner of the Show... Comprehend the web and master the techniques to –
All of this and more for the Oracle Database in the firm you hope to find yourself in! In other words to fine tune your senses to face the world head on!
To do this you should have:
Who can take up the Oracle DBA course?
Oracle DBA - Beginning:
• What is Database Administration?
• Requirements of Database Administration in a Company
• Responsibilities and Roles of a Database Administrator.
• Oracle’s Structural Design
• Objective and Logical Phase of the Database
• Class of the files (Control, Redo Log and Data Files)
• Diverse Data Files
• SGA – System Global Area and the Back ground Process.
Formation of the Database:
• Diverse Start up Modes
• Various Shut down Modes
• Types of Database Design
• Non automatic Method of Creating the Database.
Managing the Table Space:
• Introduction to the Table Space
• Table Space – types - (Big and Small)
• Momentary Table Space
• Shift or Rename a Table Space
• Rename a Data File
• Transitory Groups
• Table Space Encryption (11g)
Storing the Variables:
• What are Segments?
• What is an Extent?
• How are Blocks used and What are they?
• The Oracle Blocks
• Assessment of the Extents
• Manage the Table space through Locally or Dictionary wise.
• Storage Parameters include - Initial, Min Extents, Next, Pctincrease and Xtents)
• Database Users – who are they?
• Demand to create a User
• Making of the Users
• Passing 0n the Privileges
• Granting and Creating the Roles
• Dispensing Table Space to the Users
• Issuing standard Table Space to the Users.
• Fixing the Profiles of the Users
• Levels of Validation
• Schema Management (11g)
• Defence (11g)
Undo the Management:
• What is Undoing and Why is it Indispensible?
• Offline Status being Pending
• Concise discussion on Roll back segments
• Flash back Features
• Flash back Table
• Flash back query
• Flash back Version Query
SP File and OMF:
• What is SP file?
• Distinction between the SP File and P File
• Compensation of SP File
• What is OMF?
• Benefits of OMF
• File conventions of OMF
• Oracle Networking- Introduction
• Default location of the Network
• Edit the Network File
• Preface - Database Links
• Database Links and its Types
• Prologue to the Materialized Views
• Rewards of Materialized View
• Revival of the Modes
REDO-LOG & CONTROLFILE MANAGEMENT
• Redo Log’s Introduction
• Status of the Redo Logs
• A conglomerate of the Redo Log Files
• Re-create the Control File
• Rename the Database
• And finally Multiplex the Control File
• Mysteries of the logical backup unravelled
Why Shiksha Tarang?
Shiksha Tarang is the place where people get to learn the aspects of becoming a True Blue Oracle Database Administrator. Here it is a step by step training methodology, so as to enable the novice in the Administration field to learn from the baby steps! The course has been specially designed by the Experts to give that edge to the Shiksha Tarang students!!!
Moreover the Career is always on the brighter side of the road... as many companies try to clinch the best talent around.... So the average pay is between Rs.176, 314/- to Rs.958, 719/- annually.
Are you now waiting for someone to come by and invite you? Remember if you have the zeal then Impossible will itself say that I’m Possible!!!
Not reviewed yet