Learn Infra Technology from Industry Experts
Start now, get a better job in 3 months.
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.
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!
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
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...
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",...
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,...
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...
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...
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 || ',' ||...
Create an EC2 Instance with 2 Security Groups and Output values
Here we are going to implement how to dynamically get the latest AMI ID from AWS using Terraform Datasource concept and then create the EC2 Instance. We will also create 2 resources which is nothing but VPC-SSH and VPC-Web security group resources so that those can be...
Create a Static Webserver using EC2 Instance in Terraform
Terraform Provider Block # Terraform Block terraform { required_version = "~> 1.0.11" required_providers { aws = { source = "hashicorp/aws" version = "~> 3.0" } } } #Provider Block provider "aws" { region = "us-east-1" } Terraform Resource Block resource...
Create an EC2 Instance with hard coded AMI ID
Terraform Settings block terraform { #required Terraform Version required_version = "~> 1.0.11" #Required Providers and their versions required_providers { aws = { source = "hashicorp/aws" version = "~> 3.21" } } #Remote Backend for storing Terraform state in S3...
Oracle RAC Interview Questions
For more exciting blogs on Oracle, please click the LINK 1. Where are the Clusterware files stored on a RAC environment? The Clusterware is installed on each node (on an Oracle Home) and on the shared disks (the voting disks and the CSR file) 2. Where are the...