Scripting skills will add lot of value to Oracle DBA’s. It will help DBA’s to reduce performing recurring tasks, schedule jobs, monitoring, Automating and much more. This course will train you with good real time examples which demonstrates how an Oracle DBA activities can be simplified and managed easily.

Get hands-on real time experience on Oracle Database environment now.

  • Simple and easy to understand.
  • Meet industry standards.
  • Learn and practice it yourself.

System requirements:

  • Laptop/Desktop with at least 3GB RAM.
  • Minimum of Dual Core processor.
  • 40 GB of disk space.

Training details:

  • 14 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Demo Video:

 

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

Introduction to SHELL Scripting

Pre-requisites

1.BASH SCRIPT BASICS

1.1 Shell programs

1.2 Executing commands

1.3 Building blocks

1.4 Creating and running script

1.5 Debugging scripts

2.BASH ENVIRONMENT

2.1 Initialization

2.2 Variables and characters

2.3 Expansions and aliases

2.4 Regular expressions

2.5 grep examples

2.6 Pattern matching

3.GNU

3.1 Interactive editing

3.2 Non interactive editing

3.3 AWK programming

3.4 AWK  print program

3.5 AWK variables

4.CONDITIONS & INTERACTIVE SCRIPTS

4.1 IF clause

4.2 Advnaced IF usage

4.3 CASE statements

4.4 Display user messages

4.5 User input

5.REPETITIVE TASKS & VARIABLES

5.1 FOR loop

5.2 WHILE loop

5.3 UNTIL loop

5.4 I/O redirection

5.5 Break and continue

5.6 Menu making

5.7 Variables

5.8 Operations on variables

6.FUNCTIONS & SIGNALS

6.1 Signals

6.2 Traps

6.3 Functions

6.4 Common shell features

6.4 Differing shell features

7.TOOLS DEVELOPMENT for DBA’s

7.1 Storage check tool

7.2 Backups tool

7.3 Refresh tool

7.4 User creation tool