Covers each topics with Real Time Examples . Covers More than 250+ Real Time Scenarios which is divided into Admin 1 (Basic) + Admin2 + 12C (which is why we called it a combo course). Trainer from Real Time Industry .This is completely hands-on training , which covers 70% Practical And 30% Theory .Specail attention / session for interview preparation after the course is done.We give examples and exposure to real time scenarios to make sure all the candidate will get at least 5+ Year experience knowledge in Oracle DBA after attending this course.Covers 11G +12C topics in Details from the very basic to advanced level . Complete OCA and OCP Exam Preparations.Appear for OCA/OCP Certification Exam at any time After the course . At your convenient time , you can book and appear for exam at our place as we are Pearson certified institute.
Duration of Training : 60 hrs
Batch type : weekdays /weekends/ Customized Batches
Mode of Training: Offline / Online / Corporate Training
Projects Given : 2 Projects minimum
Trainer Profile : Experienced Faculty from IT Industry
Projects | Assignment | Scenarios and Used Case Studies
Learn to install Linux with relevant packages.
1) Understand HDD partitioning
2) Primary Verses Extended Partitioning
3) Physical Volumes / Logical Volumes / Luns
Understanding RAID / Storages / DNS / DHCP / iscsi utilities
1) Different levels of Raid
2) Installation of configuration of DNS.
3) Installation and configuration of DHCP
4) tgtd and iscsi utilities
Installing 11g and 12c Oracle Software
1) Install and configure 11g and 12c Oracle Database Software
Creating 11g and 12c databases (manual)
1) Creating 11g Database and 12c Database manually
11g and 12c Architecture.
1) Thorough understanding of 11g and 12c architecture
Oracle Administration and management.
1) starting databases
2) understanding control files / redo log files / archive files
3) understanding Server parameter file and password files
4) Automatic memory management
5) Different components in SGA and PGA
Tablespaces / segments / extents and blocks
1) Dictionary managed versed locally managed tablespaces.
2) Automatic Segment space management
3) Understanding Segments / extents and blocks
4) Block utilization parameters
5) Understanding row chaining and migration
6) Different block Sizes
12c Multitenant Database concepts and new features
1) Understanding multitenant architecture
2) Overviews of Pluggable databases
Oracle networking and shared process overview
1) Configuring and maintaining listeners
2) Configured Dispatchers and Shared servers
3) Understanding tnsnames.ora / sqlnet.ora and Ez Connect
ASM overview and benefits
1) Complete Overview of ASM
2) Understand the need of ASM
3) ASM instance parameters
Rman and conventional Backup / Recovery
1) Defining backup strategy
2) Complete understanding of RMAN and conventional backups
Rman and Conventional Cloning
1) Cloning database using conventional methods
2) Cloning database using rman
Applying patches
1) Different types of Patches
2) How to apply patch to database
Database upgrade
1) Upgrade Database from 11g to 12c
2) Coverting 12c noncdb to 12c pluggable database
Physical and logical Standby/ Data guard
1) Configure physical standby database
2) Understanding logical and snapshot standby database
Oracle Shell Scripting overview.
1) understanding cronjob
2) writing basic scripts
AWR reports / ADDM reports / ASH report
1) Understand how to read the AWR / ADDM / ASH reports
Sql loader / external tables
1) Using sql loader to load data into tables
2) External tables and its benefits
Partitioning concepts
1) Understanding different types of partitioning
2) Creating and altering partitions
expdp / impdp backups
1) Taking logical backups using expdp
2) Data pump usage and scenarios
Tracing utilities ( oradebug / sql trace / tkprof ) and sql tuning
1) Using utilities for tracing
2) How to read SQL explain plan
3) SQL performance considerations
Loss of a Control File
Loss of a Redo Log File
Loss of a Data File in NOARCHIVELOG Mode
Loss of a Noncritical Data File in ARCHIVELOG Mode
Loss of a System-Critical Data File in ARCHIVELOG Mode
Oracle Recovery Manager
Oracle Recovery Catalog maintenance
Backups using Oracle Recovery Manager
Recovery using Oracle recovery manager
Database Cloning using RMAN
Tablespace Point in time recovery
Incomplete recovery
Locks
Locking Mechanism
Data Concurrency
DML Locks
Enqueue Mechanism
Lock Conflicts
Possible Causes of Lock Conflicts
Detecting Lock Conflicts
Resolving Lock Conflicts
Deadlocks
Performance Monitoring
Performance Monitoring
Monitoring Methodologies
Database and Instance Metrics
Data Dictionary Metrics
Optimizer Statistics
Schedule Optimizer Statistics Collection
Dynamic Performance Views
Viewing Metric Information
Reacting to Performance Issues
Reacting to Performance Issues
Server Generated Alerts
Thresholds
Setting Thresholds
Baseline Measurements
Tuning and Diagnostic Advisors
SQL Tuning and Access Advisors
Memory Advisors
Segment Advisor
Automatic Workload Repository (AWR)
Managing the AWR
Automatic Database Diagnostic Monitor (ADDM)
1. VMware Install
2. Linix Installation
3. Networking (Neat)
4. OS user create , group , password
5. File share from windows os to Linux os
6. Oracle Installation
7. Database Create
8. NETCA,NETMGR
a. Listener
i. Lsnrctl utility
b. Services
9. SGA
10. User Management
11. Profile
12. Roles
13. Tablespace
a. Create,drop,alter tablespace
b. Create datafiles
c. Small datafile
d. Big datafile
e. Quota
f. Tablespace online , offline
g. Default tablespace
h. Extent management
i. Memory allocation
14. Undo Management
15. Database Startup types
16. Database Shutdown types
17. Physical files
18. Backup, Restore and Recovery
a. Physical Backup
i. Cold Backup
ii. Hot Backup
b. Data Pump
i. Exp,Imp
ii. Impdp, Expdp
c. RMAN
19. Flashback
1 .Oracle Database Architecture
Databases and instances overview
Multitenant architecture
Sharding architecture
Architecture diagram on the OHC
Physical storage structures
Logical storage structures
Logical and physical storage structures
Data storage-segments, extents, blocks
Types of segments
Deferred segment creation
Block structure
Tablespaces and datafiles
Processes
Memory structures
Overview of Oracle Net Services
Overview of the Listener
Dedicated and shared server processes
2. Creating and Administering an Oracle Database
Use the Database Server Architecture lesson of the Oracle Database Architecture module
Connecting to an Oracle Database instance
Overview of Oracle Database tools
Prepare to create the database
Determine the character set to be used
Create a Multitenant Oracle Database (CDB)
Using DBCA in silent mode
Create a Multitenant Oracle Database (CDB)
Shut down the database instance and start the database instance/open the database
Open and close PDBs
Investigating Initialization Parameter Files
Viewing Initialization Parameters by Using SQL*Plus
Modifying Initialization Parameters by Using SQL*Plus
Viewing Diagnostic Information
3. Configuring and Administering Oracle Net Services
CourseLab
Use the Oracle Net Services Architecture lesson of the Oracle Database Architecture module.
Naming methods
Define service names so users can connect to the database
19c Easy Connect Syntax Improvements (76634-2)
Create listeners
Configure listeners for dynamic or static service registration
Implement failover and load balancing features
Configure shared server architecture
Implement session multiplexing and access control features
Configure the cman.ora file on the Oracle Connection Manager computer.
Configure the clients with the protocol address of the Oracle Connection Manager listener.
Configure the database server for session multiplexing.
Configure the cman.ora File to set up Oracle Database Cloud Traffic Manager.
4. Creating and Administering Pluggable Databases
Create PDBs from seed
Clone a regular PDB
Unplug and plug or clone a non-CDB
Unplug and plug a regular PDB
Perform hot cloning
Perform near-zero downtime PDB relocation
Create and use a proxy PDB
Use DBCA to clone and relocate PDBs, and duplicate CDBs
Change PDB mode
Modify PDB settings
Rename a PDB service
Drop a PDB
5. Creating and Managing Database Storage
Use the Database Storage Structures lesson of the Oracle Database Architecture module.
Create tablespaces to store database objects
Implement Oracle Managed Files (OMF)
View tablespace information
Drop a tablespace
Increase the size of the database (add datafiles, extend tablespaces, etc.)
Move or rename datafiles
Proactively monitor and manage tablespace space usage
Define default permanent tablespaces
Define a default temporary tablespace for a PDB
Save space by using compression
Reclaim wasted space from tables and indexes by using the segment shrink functionality
Manage resumable space allocation
Configure undo retention
Enable and disable temporary undo
Use local undo
6.Managing Users and Securing the Database
Create database users
Create common users in the CDB root and application root
Create local users in regular PDBs and application PDBsAssign quota to database users
Authentication
Oracle-defined schema only accounts
Provide users with access to the database (privileges/roles)
Create common roles in the CDB root and application root
Create local roles in regular PDBs and application PDBs
Grant privileges/roles commonly in the CDB root and application root
Grant privileges/roles locally in regular PDBs and application PDBs
Create profiles to control user security and resource utilization
Create common profiles in the CDB root and application root
Create local profiles in regular PDBs and application PDBs
Audit the use of the database (objects, privileges, etc.)
Audit actions in the CDB and PDBs
7. Loading and Transporting Data
Load data (Data Pump, SQL*Loader)
Utilities to load/maintain data in the database
Use SQL*Loader to load data
Use SQL*Loader with PDBs
Use Data Pump to transport (move) data
Move data from one database to another database
Use Data Pump with PDBs
Use the full transportable export/import feature to move an entire database to a different database instance
Use the transportable tablespaces feature to move a set of tablespaces between databases
Use the transportable tables feature to move a set of tables, partitions, and sub-partitions between databases
Use external tables as a data source
8. Managing Automated Maintenance Tasks
Overview of automated maintenance tasks
Overview of maintenance windows
Configure automated maintenance tasks
Enable and disable maintenance tasks
Create a maintenance window
Modify a maintenance window
Remove a maintenance window
Reduce or increase resource allocation to the automated maintenance tasks
9. Monitoring and Tuning Database Performance
Performance management activities
Performance planning
Performance tuning methodology
Automatic performance tuning features (AWR, ADDM, advisors)
PDB-level ADDM
Monitor database instance performance
Monitor database errors and alerts to prevent, detect, and solve problems (alert log, trace files, server-generated alerts)
Set metric thresholds
Monitor locks and wait events
Configure memory management
Set optimizer statistics preferences
Identify and tune SQL statements that are using the most resources
Tune a workload
Manage automated tuning tasks
+91 8882400500
I had undergone oracle DBA course under Chetan sir's Guidance an it was a very good learning experience overall since they not only provide us with theoretical knowledge but also conduct lot of practical sessions which are really fruitful and also the way of teaching is very fine clear and crisp which is easier to understand, overall I had a great time for around 2 months, they really train you well.also make it a point to clear all your doubts and provide you with clear and in-depth concepts hence hope to join sometime again
I have completed Oracle DBA 11g from Radical technology pune. Excellent trainer (chetna gupta). The trainer kept the energy level up and kept us interested throughout. Very practical, hands on experience. Gave us real-time examples, excellent tips and hints. It was a great experience with Radical technologies.
Linux learning with Anand sir is truly different experience... I don't have any idea about Linux and system but Anand sir taught with scratch...He has a great knowledge and the best trainer...he can solve all your queries related to Linux in very simple way and giving nice examples... 100 to Anand Sir.
I had a wonderful experience in Radical technologies where i did training in Hadoop development under the guidance of Shanit Sir. He started from the very basic and covered and shared everything he knew in this field. He was brilliant and had a lot of experience in this field. We did hands on for every topic we covered, and that's the most important thing because honestly theoretical knowledge cannot land you a job.
I have recently completed Linux course under Anand Sir and can assuredly say that it is definitely the best Linux course in Pune. Since most of the Linux courses from other sources are strictly focused on clearing the certification, they will not provide an insight into real-world server administration, but that is not the case with Anand Sir's course. Anand Sir being an experienced IT infrastructure professional has an excellent understanding of how a data center works and all these information is seamlessly integrated into his classes.
1. Basic user account management (creating, modifying, and deleting users).
2. Password resets and account unlocks.
3. Basic file system navigation and management (creating, deleting, and modifying files and directories).
4. Basic troubleshooting of network connectivity issues.
5. Basic software installation and package management (installing and updating software packages).
6. Viewing system logs and checking for errors or warnings.
7. Running basic system health checks (CPU, memory, disk space).
8. Restarting services or daemons.
9. Monitoring system performance using basic tools (top, df, free).
10. Running basic commands to gather system information (uname, hostname, ifconfig).
1. Intermediate user account management (setting permissions, managing groups).
2. Configuring network interfaces and troubleshooting network connectivity issues.
3. Managing file system permissions and access control lists (ACLs).
4. Performing backups and restores of files and directories.
5. Installing and configuring system monitoring tools (Nagios, Zabbix).
6. Analyzing system logs for troubleshooting purposes.
7. Configuring and managing software repositories.
8. Configuring and managing system services (systemd, init.d).
9. Performing system updates and patch management.
10. Monitoring and managing system resources (CPU, memory, disk I/O).
1. Advanced user account management (LDAP integration, single sign-on).
2. Configuring and managing network services (DNS, DHCP, LDAP).
3. Configuring and managing storage solutions (RAID, LVM, NFS).
4. Implementing and managing security policies (firewall rules, SELinux).
5. Implementing and managing system backups and disaster recovery plans.
6. Configuring and managing virtualization platforms (KVM, VMware).
7. Performance tuning and optimization of system resources.
8. Implementing and managing high availability solutions (clustering, load balancing).
9. Automating system administration tasks using scripting (Bash, Python).
10. Managing system configurations using configuration management tools (Ansible, Puppet).
1. Learning basic shell scripting for automation tasks. 2. Understanding file system permissions and ownership. 3. Learning basic networking concepts (IP addressing, routing). 4. Learning how to use package management tools effectively. 5. Familiarizing with common Linux commands and utilities. 6. Understanding basic system architecture and components. 7. Learning basic troubleshooting techniques and methodologies. 8. Familiarizing with basic security principles and best practices. 9. Learning how to interpret system logs and diagnostic output. 10. Understanding the role and importance of system backups and restores.
1. Advanced scripting and automation techniques (error handling, loops).
2. Understanding advanced networking concepts (VLANs, subnetting).
3. Familiarizing with advanced storage technologies (SAN, NAS).
4. Learning advanced security concepts and techniques (encryption, PKI).
5. Understanding advanced system performance tuning techniques.
6. Learning advanced troubleshooting methodologies (root cause analysis).
7. Implementing and managing virtualization and cloud technologies.
8. Configuring and managing advanced network services (VPN, IDS/IPS).
9. Implementing and managing containerization technologies (Docker, Kubernetes).
10. Understanding enterprise-level IT governance and compliance requirements.
1. Designing and implementing complex IT infrastructure solutions. 2. Architecting and implementing highly available and scalable systems. 3. Developing and implementing disaster recovery and business continuity plans. 4. Conducting security audits and vulnerability assessments. 5. Implementing and managing advanced monitoring and alerting systems. 6. Developing custom automation solutions tailored to specific business needs. 7. Providing leadership and mentorship to junior team members. 8. Collaborating with other IT teams on cross-functional projects. 9. Evaluating new technologies and making recommendations for adoption. 10. Participating in industry conferences, workshops, and training programs.
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
Abu Dhabi
(Our Team will call you to discuss the Fees)
(Our Team will call you to discuss the Fees)