Learn Infra Technology from Industry Experts

Start now, get a better job in 3 months.

Training
Certification

Certification

Become a certified expert with our various Certification modules available. Open up better job prospects for yourself. Get hired by the top MNCs in India.

Blog

Start Learning for FREE

Check out our blog for awesome articles on Database, Cloud and more. Get started with basic tips and tricks. It’s  100% free and it always will be!

YouTube

Check Out Our YouTube Channel

Get free video lessons, walkthroughs, and demos on our YouTube channel. It’s totally free and meant for complete beginners.

Check Out Our Latest Posts

Oracle ASM Interview Questions

1. What init.ora parameters does a user need to configure for ASM instances? Oracle ASM offers these initialization parameters.  The main parameters for ASM include asm_diskgroups, asm_diskstring, asm_power_limit and asm_preferred_read_failure_groups. ...

read more

Terraform Blogs

1. Create an EC2 Instance with hard coded AMI ID 2. Create a Static Webserver using EC2 Instance in Terraform 3. Create an EC2 Instance with 2 Security Groups and Output values 4. Create Multi AZ RDS using Terraform 5. Restore RDS from existing snapshot using Terraform

read more

Export Import Datapump Basic Commands

For more exciting blogs on Oracle, please click the LINK 1. EXCLUDING TABLE PARTITIONS JOB_NAME=INFRA_EXPORT DIRECTORY=DUMP_DIR DUMPFILE=Schema_%U.dmp LOGFILE=Schema.log SCHEMAS=INFRA EXCLUDE=table_data:"IN ('INFRA_KEY_2005Q1','INFRA_KEY_2005Q2')" FILESIZE=100G...

read more

RMAN Basic Commands

For more exciting blogs on Oracle, please click the LINK 1. Crosscheck and delete expired archive logs RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all;   2. Delete archive logs keeping just a days...

read more

Tablespace Commands

For more exciting blogs on Oracle, please click the LINK 1. Checking tablespace size col "Tablespace" for a22 col "Used MB" for 99,999,999 col "Free MB" for 99,999,999 col "Total MB" for 99,999,999 select df.tablespace_name "Tablespace", totalusedspace "Used MB",...

read more

Create Multi AZ RDS using Terraform

In this post, we will create Multi AZ RDS using Terraform RDS Engine/Version : MySQL 5.7 We will also see how to provide an existing VPC security group using Terraform while creating the RDS. We will just post the configuration files over here. For more details,...

read more

MySQL Upgrade from 5.6 to 5.7

In this post we will see how to upgrade MySQL Database Instance from MySQL 5.6 to MySQL 5.7 NOTE : If you are planning to upgrade in a Master-Slave Environment, please upgrade all Slave Environments first before upgrading Master Server database. Please stop the Slave...

read more

MySQL upgrade from 5.7 to 8.0.21

In this post, we will see how to upgrade your MySQL database from 5.7 to 8.0.21 version NOTE : If you are planning to upgrade in a Master-Slave Environment, please upgrade all Slave Environments first before upgrading Master Server database. Please stop the Slave...

read more

Daily Commands in Oracle

For more exciting blogs on Oracle, please click the LINK 1. Kill Multiple Inactive sessions in Oracle BEGIN FOR r IN (select sid,serial# from v$session where username='user' and status'INACTIVE') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' ||...

read more

Learn Ansible

 

Learn AWS

Learn AWS

Learn AWS