Our Oracle DBA Training in Bangalore aims to teach beginners and employees.
term can be defined as trademark of RDBMS. We are the Best Oracle DBA Training Institute in
Bangalore in-terms of syllabus and expert teaching. Oracle rapidly converging all IT required
solutions like middleware, storage and OS by acquiring leading core pioneers and technology
players in market. It is providing very strong and unique supports to customers. Still now oracle
has acquired around 40 companies and expands its wings around 90% on RDBMS and ERP
tools and services and related technologies. Oracle DBA is a leading and demanding skill-sets
in IT as well highly paid jobs since the role need to be handling the backbone of organization’s
vital data management at large scale.
Upcoming Batches:,
New batches commencing soon…. Flexible timings between 7am to Evening 8pm on all days
Monday to Saturday, Sunday Half day.
We are NI Anaytics India and covering Oracle DBA course at unique level in all aspects
Technical as well real time oriented. Our core ideology is to nurture each Oracle DBA aspirants
should be much strong in concepts as well must be opt in handling real time issues. Our faculty
has extensive year’s hands on experience in oracle installation, upgrade, data guard and RAC
installation and strong knowledge in real time issues handling and consultant area..
Training will be conducted by real time DBA consultants working in Top IT companies who can
make subject understandable practically at student level. Our trainers having more than 6-7
years of DBA experience and ready to share knowledge with students looking for career growth
As DBA.
ORACLE 11g DBA SYLLABUS
ORACLE ARCHITECURAL COMPONENTS
DATABASE COMPONENTS
- Pre requisites for Oracle DBA
- 1. UNIX OS Basics will be taught
- 2. SQL Basics necessary will be covered
- Introduction to Oracle DBA
- Oracle DBA Fundamentals
- a) Storage Devices
- Physical Structure
- Logical Structure
- b) Memory Structure
- System Global Area
- Program Global Area
- c) Process Structure
- User Process
- Server Process
- Background Process
CREATING A DATABASE
- Installation of Oracle 11g on Linux / windows Machine
- Creating a Database Using a Command Line & DBCA
- MANAGING TABLESPACES AND DATAFILES
- Creating & altering Tablespace
- Offline and Online Tablespace
- Read write & Read only mode Table space
- Resizing a Data file Manually
- Adding a Data file to the Table space
- Creation of Big file Table space
- Configuration of default Table space
- Renaming a Table space
- How to reuse a Data file
- Renaming (Moving) a Data file
- Oracle Managed Files(OMF)
- Multiple Block Size at Table space level
- Drop a Table space
- Enabling Automatic Extension of Data file
- Creation of Temporary Table space & groups
- Types of Table space
- a) Dictionary Managed
- b) Locally Managed
- Segment Management
- Extent Management
- Difference Between System Table space and Non System Table space
MANAGING DATABASE USERS PRIVILEGES & ROLES
- Creating a new user
- Alter and Drop existing database users
- User Quota's
- Obtaining user information
- Lock and unlock user accounts
- System Privileges
- Granting System Privileges
- Revoking System Privileges
- Object Privileges
- Advantages of Roles
- Creating the Roles
- Assigning Roles to users
- Establishing Default Roles
- Removing Roles from user
- Creation of Database Profiles
MANAGING ONLINE REDOLOG FILES
- Creation of log members and groups
- Dropping log members and groups
- structure of Redo log files
- How Redo log files work
- How to switch log sequence manually
- Purpose of checkpoints
- Resizing online Redo log files
ARCHIVE LOG MANAGEMENT
- Changing the Database from no Archive mode to Archive mode
- Specify Multiple Archive mode
- Configuration of Multiple Archive Destination
- Archive file format
MANTAINING CONTROL FILES
- Control File Contents
- Multiplexing the control files by using PFILE(INIT.ora)
- Creation of Backup Control file
MANAGING ROLLBACK SEGMENT AND ONDO SEGMENTS
- Creating and Maintaining Rollback segments & Undo segments(Online/Offline)
- Types of Undo segments
- a) System b) Non system
- Automatic Undo Management
- How to switch undo Tablespace to pending offline
BACKUP AND RECOVERY
- Understanding Backups
- Physical Backups
- Online, Offline, Hot & Cold BackupsBackups, Restore and Recovery Scenario’s with complete, incomplete, instance a & media recovery.
- Recovery loss of Non System data files
- Recovery loss of System data file.
- Recovery loss of Undo data file.
- Recovery loss of Redo log file.
- Recovery loss of control files by using back up control files
- Recovery loss of data files without having back up
- Recovery damaged database while online back up.
Logical Backups
- Full Database Level
- User Level
- Table level by using exp, imp
Oracle Data Pump
- Introduction to data Pump
- Advantages of data pump.
- Logical backups using expdp and impdp tools.
CONFIGURATION OF SQLNET PROTOCOL FOR CLIENT/ SERVER ADISTRUBUTED
DATABASE ENVIRONMENT:
- Simple Network
- Complex Network
- Configuration Oracle Net Protocol.
- Configuration of TNSNAMES.ORA at client machine by using NETCA
- Configuration of LISTENER.ORA at server.
- Creating Database Links & materialized views for distributed databases.
CONFIGURATION OF DISPATCHERS, DEDICATED SERVER PROCESSES & SHARED SERVER PROCESSES
PERFORMANCE TUNING:
Overview of tuning (theory only)
- Database level
- Buffer Tuning
- Tuning the S.G..A Components
- a)Database buffer
- b)Log buffer
- c)Shared pool size
- Table caching
- Enable Oracles parallel Query Option
Application Tunings(practical)
- TKPROF, Explain Plan and SQL Trace
- SQL Net Protocol Tuning
- Configure of multiple DB writers
- Drop a Table & Recovery from bin by using Flashback Mode
- Dynamic SGA
- Configuration of stat pack for reports
- Configuration of AWR, ASH, ADDM, ASMM reports
PARTITIONING TABLES
Creation of Range, Hash, Composite and List Partitioning
CONFIGURATION OF ASM
MANAGING INDEX TABLESPACE
At the end of session CV preparation, Interview questions, Placement Guidance will be provided. As NI
Analytics India is manpower sourcing company providing manpower fresher to experienced in Oracle and
other technology across india we can support our students well for Placements in Reputed IT companies
and MNC’s.
For more information Demo class , Admission, New batches Please contact 9535024636 /
9916806516, Email: enquiry@nianalyticsindia.com
