Shell Scripting For Daily Struggle Oracle Dba'S

shell scripting

What you'll learn

Learners can be able to get hands on experience on shell scripting

Learners get confidence to use shell scripting skills in real time scenarios

Learners can apply the techniques in their workplace

Learners can get an understanding of shell script in DBA perspective

Requirements

A laptop with good specifications and Internet connection

Description

Practice makes perfect !I like to pronounce the term shell scripting and the benefit it gives for automate any tasks and save sleepless nights for any Oracle DBA's.If you want to tap your brain's potential and think more creative on doing a human task into a machine managed task, then this course can help you in many ways.You may not be a perfect coder or programmer, but that does not matter. Automating tasks can be done by anyone provided, they should be curious to learn and explore a lot. Since the native ground for most oracle systems is unix or linux, learning this skill add's additional value to the DBA's and isolate from the masses.Modern Oracle engineers must streamline and automate regular, repetitive processes. With responsibilities ranging from system setup and maintenance to interacting with functional users to capacity planning, the more productive DBAs can concentrate on other crucial activities, the less time they have to spend on boring things like examining logs and checking for free space.There are a number of commercial options for automating jobs, however many of the greatest tools for managing services, automating routine administrative duties, and executing complex tasks are already present in Linux and Unix systems. In today's market, DBA's should be good at at least one scripting skills which can be shell.Every organization add a requirement for oracle dba to have shell scripting in its job posting.Some organization specifically hire DBA's for their shell scripting skills due to requirements and lack of automation in new or upcoming projects.Not only, shell scripting helps you in terms of job perspective but also to ease your day from spending loads of time for a non productive labor task into self driving mode.I will help you to learn the method of catching a fish rather than catching a fish and lend it to you.By the end of the course, you should be able to create your own shell script and can automate any problem statement.Trust me, you get used to it and rock it.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Software Installation

Lecture 2 Install Lab

Lecture 3 OEL 8.2 installation

Lecture 4 Configuration of files

Lecture 5 Database Software Installation

Section 3: Create Our First Script!

Lecture 6 Create First Shell Script

Section 4: Different Shells Overview

Lecture 7 Different types of shells

Section 5: Variables Basics

Lecture 8 What is Variable ?

Lecture 9 Environment Variables to be set

Lecture 10 Variable Declaration Guidelines

Section 6: Performing Calculations in Shell

Lecture 11 Arithmetic Operations using expr

Section 7: Finding patterns of text or number

Lecture 12 Find patterns from text in shell

Section 8: Control Statements

Lecture 13 Decision making in shell

Section 9: Loops

Lecture 14 FOR loop

Lecture 15 WHILE loop

Oracle DBA