LINUX & DBA COMBO Training in Pune/ Online
Courses Included:-
Linux RHCSA + Oracle DBA
Duration of Training : 4 months
Batch type : Weekdays/Weekends
Mode of Training : Classroom/Online/Corporate Training
Why Radical Technologies
LINUX RHEL 8
Get started with Red Hat Enterprise Linux
Describe and define open source, Linux distributions, and Red Hat Enterprise Linux.
Access the command line
Log into a Linux system and run simple commands using the shell.
Manage files from the command line
Copy, move, create, delete, and organize files while working from the bash shell.
Get help in Red Hat Enterprise Linux
Resolve problems by using local help systems.
Create, view, and edit text files
Manage text files from command output or in a text editor.
Manage local users and groups
Create, manage, and delete local users and groups, as well as administer local password policies.
Control access to files
Set Linux file system permissions on files and interpret the security effects of different permission settings.
Monitor and manage Linux processes
Evaluate and control processes running on a Red Hat Enterprise Linux system.
Control services and daemons
Control and monitor network services and system daemons using systemd.
Configure and secure SSH
Configure secure command line service on remote systems, using OpenSSH.
Analyze and store logs
Locate and accurately interpret logs of system events for troubleshooting purposes.
Manage networking
Configure network interfaces and settings on Red Hat Enterprise Linux servers.
Archive and transfer files
Archive and copy files from one system to another.
Install and update software
Download, install, update, and manage software packages from Red Hat and yum package repositories.
Access Linux files systems
Access, inspect, and use existing file systems on storage attached to a Linux server.
Analyze servers and get support
Investigate and resolve issues in the web-based management interface, getting support from Red Hat to help solve problems.
Comprehensive review
Review the content covered in this course by completing hands-on exercises.
Impact on the organization :
This course is intended to develop the skills needed for basic administration and configuration of Red Hat Enterprise Linux. This course introduces key command line concepts and enterprise-level tools, laying the foundation for the rapid deployment of Red Hat Enterprise Linux. The curriculum also introduces the basic administration skills needed for resolving configuration issues and integrating Red Hat Enterprise Linux systems with other existing environments.
This offering lays the foundation for secure user and group administration, and develops skills that allow administrators to use available storage solutions more efficiently and securely. This course is the first of a two-part series that turns a computer professional who knows nothing about Linux into a fully capable Linux administrator.
Red Hat has created this course in a way intended to benefit our customers, but each company and infrastructure is unique, and actual results or benefits may vary.
Impact of this training :
As a result of attending this course, you should be able to perform essential Linux administration tasks, including installation, establishing network connectivity, managing physical storage, and basic security administration.
You should be able to demonstrate these skills:
- Access the command line
- Manage files from command line
- Create, view, and edit text files
- Manage local users and groups
- Monitor and manage Linux processes
- Control services and daemons
- Control access to files with file system permissions
- Analyze and store log files
- Configure and secure the OpenSSH service
- Install and update software packages
- Access Linux file systems
- Manage Linux networking
Recommended next exam or course :
- Red Hat System Administration II (RH134)
- or
- Red Hat System Administration II with RHCSA exam (RH135)
- Course descriptionThe first of two courses covering the core system administration tasks needed to manage Red Hat Enterprise Linux serversRed Hat System Administration I (RH124) equips you with Linux® administration “survival skills” by focusing on foundational Linux concepts and core tasks. You will learn how to apply command-line concepts and enterprise-level tools, starting you on your journey toward becoming a full-time Linux system administrator. This path continues with the follow-on course, Red Hat System Administration II (RH134).This course is based on Red Hat® Enterprise Linux 8.
Course content summary :
- Introduction to the command line
- Managing physical storage
- Install and configure software components and services
- Establish network connections and control firewall restrictions
- Monitor and manage running processes
- Manage and secure files and file systems
- Administer users and groups
- Review the system log files and journal for issues
- Troubleshoot problems and analyze systems with Red Hat Insights
- Remotely manage systems with SSH and the Web Console
Prerequisites for this course :
Basic technical user skills with computer applications on some operating systems are expected.
System Administration II (RH134) –
This module goes deeper into enterprise Linux administration including file systems and partitioning, logical volumes, SELinux, firewalling, and troubleshooting. Attending both Red Hat System Administration I and Red Hat System Administration II can help you in your preparation for the Red Hat Certified System Administrator exam (EX200).
Outline for this course :
- Improve command line productivity
- Run commands more efficiently by using advanced features of the bash shell, shell scripts, and various utilities provided by Red Hat Enterprise Linux.
- Schedule future tasks
- Schedule commands to run in the future, either one time or on a repeating schedule.
- Tune system performance
- Improve system performance by setting tuning parameters and adjusting scheduling priority of processes.
- Control access to files with ACLs
- Interpret and set access control lists (ACLs) on files to handle situations requiring complex user and group access permissions.
- Manage SELinux security
- Protect and manage the security of a server by using SELinux.
- Maintain basic storage
- Create and manage storage devices, partitions, file systems, and swap spaces from the command line.
- Manage logical volumes
- Create and manage logical volumes containing file systems and swap spaces from the command line.
- Implement advanced storage features
- Manage storage using the Stratis local storage management system and use VDO volumes to optimize storage space in use.
- Access network-attached storage
- Use the NFS protocol to administer network-attached storage.
- Control the boot process
- Manage the boot process to control services offered and to troubleshoot and repair problems.
- Manage network security
- Control network connections to services using the system firewall and SELinux rules.
- Install Red Hat Enterprise Linux
- Install Red Hat Enterprise Linux on servers and virtual machines.
Course description :
Focuses on the key tasks needed to become a full-time Linux administrator
Red Hat System Administration II (RH134) builds upon and lends context to the foundational knowledge established in Red Hat System Administration I (RH124). This follow-on course demonstrates more detailed use cases for Red Hat® Enterprise Linux®, preparing you for the Red Hat Certified System Administrator exam (EX200).
This course is based on Red Hat Enterprise Linux 8.
Course content summary :
- Install Red Hat Enterprise Linux using scalable methods
- Access security files, file systems, and networks
- Execute shell scripting and automation techniques
- Manage storage devices, logical volumes, and file systems
- Manage security and system access
- Control the boot process and system services
Audience for this course :
This course is geared toward Windows system administrators, network administrators, and other system administrators who are interested in supplementing current skills or backstopping other team members, in addition to Linux system administrators who are responsible for these tasks:
- Configuring, installing, upgrading, and maintaining Linux systems using established standards and procedures
- Providing operational support
- Managing systems for monitoring system performance and availability
- Writing and deploying scripts for task automation and system administration
Prerequisite(s) for this course :
- Successful completion of Red Hat System Administration I (RH124) is recommended. Experienced Linux administrators seeking to accelerate their path toward becoming a Red Hat Certified System Administrator should start with the RHCSA Rapid Track course (RH199).
ORACLE DBA 11G -12C -19C COMBO
COURSE CONTENT :
ORACLE 11G & 12C :
Linux Installation
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
SCENARIOS :
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
Monitoring and Resolving Lock Conflicts
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
Proactive Maintenance
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)
TOPICS COVERED
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
ORACLE DBA 19C :
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
Learn Linux & DBA Combo – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!
Online Batches Available for the Areas
Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad