LINUX & DBA COMBO

LINUX & DBA COMBO ONLINE TRAINING

A Linux and DBA (Database Administrator) combo refers to the strategic combination of the Linux operating system with the role of a Database Administrator. The Linux and DBA combo is highly favored in organizations where databases play a critical role in business operations. It enables DBAs to effectively manage and optimize databases on a stable and secure Linux platform.

3594 Satisfied Learners

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

100% Placement Guarantee for the Right Candidate

10+ Years Real Time Experienced Trainers

Learn from Industry Experts, Hands-on labs

Flexible Options: online, instructor-led, self-paced

14+ Years of Industry Recognitions

1 Lakh+ Students Trained

50,000+ Students Placed

Guaranteed 5+ Interview Calls

Top MNCs - Associated with 800+ Recruiters

Free Internship Project & Certification

Monthly Job Fair - Virtual as well as Physica

5000+ Reviews & Ratings

 

 

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

Our Courses

Drop A Query

    Enquire Now


    Enquire Now









      This will close in 0 seconds

      Enquire Now & Get 10% Off!

      (Our Team will call you to discuss the Fees)

        This will close in 0 seconds

        Enquire Now









          X
          Enquire Now

          Enquire Now & Get 10% Off!

          (Our Team will call you to discuss the Fees)

             

             

            logo

            Get a Call Back from Our Career Assistance Team

                Enquire Now