UNIX/LINUX and Shell Scripting

Faculty profile:

Real time professionals with 15+ years of experience.

Duration:

25 Hours

 Audience:

Database Administrators, Support Engineers

 Software needed on student PC:

Linux OS on laptop or desktop and Oracle Database 11g

 Course Objectives:

The objective of the course is to provide the basics of UNIX/LINUX OS, various commands, data manipulation with commands, scheduling jobs, gathering system performance, Oracle basics for developer including managing tables, indexes, data loading, query plan, db statistics, gather db performance statistics

Course Topics:

Introduction to UNIX

  • What is UNIX?
  • Connecting to local and remote servers.
  • Logging in/Logging out.
  • The Architecture, Kernel and Shell.
  • Files systems.
  • File structure and Directories.
  • Basic Directory Terms.
  • Devices and file systems.
  • Portioning and formatting disks.

UNIX/LINUX Commands

  • ls, cp, rm, mv, cat, more, head, tail, pwd, cd, mkdir, rmdir, touch, man, cut.

UNIX/LINUX Editors

  • Editor modes
  • Create and save files.
  • Open and modify files.
  • Copy / cut / paste.
  • Copying the contents.
  • Search inside file.

Commands for finding files and text within files

  • find, grep, which, sort, sed commands, cut, pushing process to background and foreground.

Commands for Decompress files

  • tar, gunzip, bunzip2.

Commands for Compress files

  • tar, gzip, bzip.

Commands for starting and stopping

  • startx, shutdown, reboot.
  • init – run levels.

Commands for User and group Administration

  • groupadd, useradd, passwd, who, whoami, ,su and exit.

Commands for processes

  • ctrl+z, ctrl+c, ps and kill.

Commands for Networking

  • hostname, ifconfig, ping, traceroute and netstat.

Commands for System Information – Admin level

  • uname, cp, df, du, lspci, lsusb, free and top.

Remote connections, ftp and others

  • Sftp and ssh.

Job scheduling

  • Crontab.

Gathering System performance statistics

  • Top.
  • vmstat.
  • iostat.
  • sar.
  • mpstat.
  • netstat.
  • Identifying processes using high CPU and Memory.

  Shell Scripting

  • What is UNIX Scripting?
  • Basic shell scripts.
  • Working with IF conditions.
  • Working with Input Arrays.
  • Working with CASE.
  • Validate input and run loops.
  • WHILE LOOP Example.
  • UNTIL LOOP Example.
  • FOR LOOP Example.
  • How to connect to Oracle database from shell scripts?
  • How to run Oracle SQL scripts from shell?
  • Functions.

Oracle Basics for Developers

  • What is schema.
  • What is tablespace.
  • What is temp and UNDO tablespace.
  • Oracle data types and constraints.
  • Tables, Indexes, GTT, Materialized view, Views, Synonyms and Sequences, External Tables, Partitioned tables and indexes.
  • user_views.
  • Checking DB at the OS level.
  • Oracle Network configuration (Client configuration).
  • SQLLDR.
  • EXPDP/IMPDP.
  • SQL joins.
  • Generating Explain Plan.
  • Oracle Optimizer Statistics.
  • Locking in Oracle.
  • Data Deletion, Altering tables, Updating Tables.