Linux & Unix Training

This impeccable Linux & Unix Training Course is exclusively designed for starters as well as for experienced professionals.

Linux & Unix Training Plans

	PLAN A	PLAN B
Course Description	Linux & Unix Basics	PL-SQL, Linux & Unix
Total Duration	2 Weeks	7 Weeks
File Creation and Displaying
Shell Functions
PIPES AND FILTERS
Shell Programming
Pipes and filters in Unix?
VI editor and How it works
Connecting Oracle to Shell
Database Fundamentals, LINUX Basics
SQL Basics with DDL, DML, SELECT
SQL Basics with DCL, TCL Commands
Writing Sub Queries, Nested Queries
Basics of Stored Procedures, Functions
Parameterized Queries and Controls
Error Handling and Event Handling
Stored Procedures , Programming Level 2
Stored Procedures , Programming Level 3
Control Structures and Loops, Packages
Lock Management and Concurrency
Advanced Control Structures - Level 1
Advanced Control Structures - Level 2
Real-time Project [Banking Domain]
Real-time Project with Complete Solution
Resume with Real-time Project FAQs
Total Course Fee	INR 3000	INR 7000

Linux & Unix Training Schedules :

	Timings (IST)	Demo Date	Start Date
Schedules for Linux & Unix
1	12:30 PM - 1:30 PM	Sept 23rd	Sept 24th	Register
2	5:30 PM - 6:30 PM	Oct 3rd	Oct 4th	Register
Schedules for PL-SQL
1	6:45 AM - 7:45 AM	Sept 13th	Sept 14th	Register
2	8:00 AM - 9:00 AM	Sept 24th	Sept 25th	Register
3	10:15 AM - 11:15 AM	Oct 8th	Oct 9th	Register
4	3:00 PM - 4:00 PM	Sept 17th	Sept 18th	Register
5	6:30 PM - 7:30 PM	Oct 3rd	Oct 4th	Register
6	9:00 AM - 11:00 AM (wk)	Oct 1st Week		Register

Linux and Unix Training Highlights

✔ Daily Tasks	✔ Weekly Interviews	✔ Real-time Project
✔ Resume Guidance	✔ Certification Guidance	✔ Placement Services

Linux & Unix Training Course Contents:

Brochure Download

Register Today

Module 1 Applicable For Plan A, B	Module 2: Applicable For Plan A, B
Chapter 1 - INTRODUCTION Basics of computer applications Unix Course Introductions Pre-requisites Unix or Linux Course Summary What is Unix system? Why do we use Unix? What is Unix and its features? Where Unix is used? What is the use of in Unix?	Chapter 6 - Shell Programming I Introduction to Shell Scripts Shell Features Programming Language Constructs Basics of Shell Set and Unset a variable Displaying – using echo Using Expr Getting input – using read Header file of shell script Sample Shell script program
Chapter 2 - File Creation and Displaying Creating files – using > symbol Redirection – using >> symbol Redirecting Input – using < symbol Displaying Files – cat, more Piping – using \| symbol Word Count Sorting a file Removing duplicates Transliteration Using Head and Tail command in files	Chapter 7 - Conditional & Looping Statement Using if statement Using if –else statement Using Nested if statement Using ‘While’ Loop Using ‘Until’ Loop Using ‘For’ Loop Using CASE Background Processing
Chapter 3 : Files Handling Creating directory Moving files to directories Copying files to directories Changing directory Removing files and directories Special Files – . and .. Creating Aliases Using Aliases Ownership, Permissions, and Dates	Chapter 8 - Shell Functions - Shell Programming II How to create functions Passing parameters to a function Returning a value from a function Using a return code in a function Generating the file list in a shell function Using an array to store all line counts Count only files we own Calling a function in file Calling a function in another file
Chapter 4 - PIPES AND FILTERS Introduction to Pipes and Filters Usage of sort and grep Filters Usage of Other Filters What are pipes and filters in Unix? What are the use of pipes and filters in Linux? What is filter in Unix with example? What is pipes in Linux with example? How do pipes work UNIX? What is named pipe in UNIX? Grep Command,Sort command,pg and more command egrep command and fgrep commmand Displaying selected characters – using cut Displaying selected fields – using delimiters Displaying selected files – using paste	Chapter - 9 Scheduler Scheduling a job – using ‘Crontab’ Scheduling a job – using ‘at’ Which scheduling policy is adopted by Linux? What is the scheduling algorithm used in Linux? How do I schedule a cron job? How do I run a cron job every 5 minutes? How does Linux scheduler work? How do I know if a cron job is running?
Chapter 5 - Introduction to vi editor What is the VI editor? Command mode, Insert mode Starting the vi editor vi Editing commands Moving within a file Saving and Closing the file What does vi command do in Linux? How do I save in vi editor? What are the vi editor commands? How does vi editor work in Unix? How do I run a .sh file in Linux? How do I enter command mode in vi? What is the significance of the vi editor in Linux? How do you find in vi?	Chapter 10 - Database Connectivity Connecting Oracle to Shell Running SQL queries from Shell Script How do I find the version of Linux database? How connect oracle server Linux? How do I start a database in Linux? How do I connect to Oracle database? What is meant by database connectivity? How is database connectivity useful? Connecting Locally with the SQL Command Line Starting the SQL Command Line from a Terminal Session

Module 1

Applicable For Plan A, B

Module 2:

Applicable For Plan A, B

Chapter 1 - INTRODUCTION

Basics of computer applications
Unix Course Introductions
Pre-requisites
Unix or Linux Course Summary
What is Unix system?
Why do we use Unix?
What is Unix and its features?
Where Unix is used?
What is the use of in Unix?

Chapter 6 - Shell Programming I

Introduction to Shell Scripts
Shell Features
Programming Language Constructs
Basics of Shell
Set and Unset a variable
Displaying – using echo
Using Expr
Getting input – using read
Header file of shell script
Sample Shell script program

Chapter 2 - File Creation and Displaying

Creating files – using > symbol
Redirection – using >> symbol
Redirecting Input – using < symbol
Displaying Files – cat, more
Piping – using | symbol
Word Count
Sorting a file
Removing duplicates
Transliteration
Using Head and Tail command in files

Chapter 7 - Conditional & Looping Statement

Using if statement
Using if –else statement
Using Nested if statement
Using ‘While’ Loop
Using ‘Until’ Loop
Using ‘For’ Loop
Using CASE
Background Processing

Chapter 3 : Files Handling

Creating directory
Moving files to directories
Copying files to directories
Changing directory
Removing files and directories
Special Files – . and ..
Creating Aliases
Using Aliases
Ownership, Permissions, and Dates

Chapter 8 - Shell Functions - Shell Programming II

How to create functions
Passing parameters to a function
Returning a value from a function
Using a return code in a function
Generating the file list in a shell function
Using an array to store all line counts
Count only files we own
Calling a function in file
Calling a function in another file

Chapter 4 - PIPES AND FILTERS

Introduction to Pipes and Filters
Usage of sort and grep Filters
Usage of Other Filters
What are pipes and filters in Unix?
What are the use of pipes and filters in Linux?
What is filter in Unix with example?
What is pipes in Linux with example?
How do pipes work UNIX?
What is named pipe in UNIX?
Grep Command,Sort command,pg and more command
egrep command and fgrep commmand
Displaying selected characters – using cut
Displaying selected fields – using delimiters
Displaying selected files – using paste

Chapter - 9 Scheduler

Scheduling a job – using ‘Crontab’
Scheduling a job – using ‘at’
Which scheduling policy is adopted by Linux?
What is the scheduling algorithm used in Linux?
How do I schedule a cron job?
How do I run a cron job every 5 minutes?
How does Linux scheduler work?
How do I know if a cron job is running?

Chapter 5 - Introduction to vi editor

What is the VI editor?
Command mode, Insert mode
Starting the vi editor
vi Editing commands
Moving within a file
Saving and Closing the file
What does vi command do in Linux?
How do I save in vi editor?
What are the vi editor commands?
How does vi editor work in Unix?
How do I run a .sh file in Linux?
How do I enter command mode in vi?
What is the significance of the vi editor in Linux?
How do you find in vi?

Chapter 10 - Database Connectivity

Connecting Oracle to Shell
Running SQL queries from Shell Script
How do I find the version of Linux database?
How connect oracle server Linux?
How do I start a database in Linux?
How do I connect to Oracle database?
What is meant by database connectivity?
How is database connectivity useful?
Connecting Locally with the SQL Command Line
Starting the SQL Command Line from a Terminal Session

Module 1: Basic SQL Applicable For Plan A, B	Module 2: SQL & PL SQL Applicable For Plan A, B	Module 3: Adv PLSQL Applicable For Plan B
CHAPTER 1 : INTRODUCTION TO DBMS What is Data and Information? Purpose of Data Management File and File System For Data Storage Disadvantages of File Data Management Database : Purpose, Basic Terminology Advantages of Database for Data Storage Possible Operations on the Database Database Models – Hierarchical Model Network Model and Relational Model Introduction to DBMS Introduction to RDBMS Database Design Most Popular RDBMS Products History, Real-time Database Examples (LIVE)	CHAPTER 7 : CONSTRAINTS & KEYS Importance of Data Integrity Working with Integrity constraints Types of Integrity Constraints Domain Integrity Constraint and Usage Entity Integrity Constraints and Usage Referential Integrity Constraint and Usage Check Constraints and Usage NOT NULL Constraint, UNIQUE Constraint PRIMARY KEY Constraint and Usage FOREIGN KEY Constraints and Relations Column Level & Table Level Constraints Adding Constraints to Tables, User_Constraints Enabling - Dropping Constraints, Self Referential Integrity Disabling Constraints on Tables	CHAPTER 13 : PL/SQL – (CONTROL STRUCTURE) - Level I Simple If, If..Else. Nested If..Else Statements Ladder, Selection, Simple Case Statements GOTO Label and EXIT Statements in PL/SQL Iterations in PL/SQL, Simple LOOP, WHILE FOR LOOP and NESTED LOOPS in PLSQL PL/SQL Select statements SQL within PL/SQL, Composite Data Types Cursor Variables and Management in PL/SQL Implicit & Explicit Cursors and Attributes Cursor with Parameters and Nested LOOPs Cursors with Sub Queries, Reference Cursors Implicit Cursors,Explicit Cursor Parameterized Cursors,Ref Cursors REF Cursors
CHAPTER 2: ORACLE INSTALLATION Oracle 2018 Installation Guidance Oracle 2012 Installation Installation Pre-Requisites and Precautions Oracle Sql Developer Oracle Sql Command prompt Oracle Versions and Editions Comparisions Connect Sql Developer Tool Creating a new User Grant permission Lock and Unlock User Account How to Reset User Account Password SQL* Plus How to Establish the Oracle Connection Default System user in Oracle Default Sysdba user in Oracle	CHAPTER 8 : QUERIES & JOINS Need for Joins and Table Comparisons SET Operations on Tables and Joins Join Types : Equi Join, Simple Join Inner Join and Query Conditions Cross Join (Cartesian Join), Conditions Join syntax - Sql syntax and Ansi Syntax Non-Equi Join and Self Join Outer Joins – Types, Advantages and Usage Cross Joins – Advantages and Limitations Self Joins, Merge Joins and Sub Queries Using Aliases in Joins and Conditions Using Inner Self Joins with HAVING JOINS and GROUP BY Queries	CHAPTER 14: ADVANCED PL/SQL - 1 Procedures in PL/SQL: STORED PROCEDURE PROCEDURES @ Parameters (IN, OUT, IN OUT) POSITIONAL Notation and NAMED Notation Procedure with Cursors and Sub Queries ALTER and DROP of Stored Procedures Functions in PL/SQL: Real-time Usage User Defined Functions, Nested Functions Using Functions in SQL Statements Working with Procedures and Functions Comparing Stored Procedures and Functions Using SPs with Table Value Functions Using SPs for Dynamic SQL Statements Loops and Table Variables in SQL Programs Merge, NVL2(), NULLIF(), COALESCE() CASE & Temporary /Global Tables
CHAPTER 3: INTRODUCTION TO RDBMS Features of RDBMS Advantages of RDBMS E.F Codd Rules for RDBMS Normalization Concepts & Process Client Server Communication Oracle Corporation Products RDBMS from Other Vendors: Microsoft, IBM,etc Oracle Versions about SQL & SQL*PLUS Database Types: OLTP and OLAP Databases Real-world Advantage of OLTP & OLAP Why a database is called as Relational Database Model Database Entites and Attributes Applicative use of RDBMS Databases	CHAPTER 9 : VIEWS, SYNONYMS,SEQUENCES VIEWS IN ORACLE, Understanding Views & Use Relational Views and Standard Views SIMPLE VIEWS and COMPLEX VIEWS in PLSQL Column Definitions in VIEWS Using VIEWS for DML Operations Forced Views, CHECK Constraints in Views Creation of READ ONLY VIEWS - Realtime Use TOP-N Analysis, (Indexed) Materialized Views SequenWorking ces, with Synonyms What is the Use of Synonym in Oracle? Difference between View and Synonym in Oracle When should Table Synonyms be used? Public Synonym and Private Synonyms All_Synonyms and Dba_Synonyms System Tables Creating Index Tables – Purpose	CHAPTER 15 : ADVANCED PL/SQL - 2 Cross Tab Views using Pivot/Unpivot Operators Follows Clause and READONLY Tables IN-LINE VIEWS. Manipulations with Triggers Purity Levels in Oracle - with Examples User_Source Dictionary Table Packages Creating PACKAGE Specifications with PLSQL PACKAGE Body - Examples with Big Data Tables Private and Public Objects in PACKAGE Types of Exceptions: User Defined Exceptions EXCEPTIONS in PL/SQL with Real-time Event Handling and Error Handling Techniques Important Error Code Values in PL/SQL RAISE_APPLICATION_ERROR Procedure
CHAPTER 4 : SQL LANGUAGE COMMANDS Structured Query Language (SQL) Basics What is SQL? What Can SQL do? Possible Operations with SQL Data Definition Language (DDL) Data Retrieval Language (DRL) Data Manipulation Language (DML) Transaction Control Language (TCL) Database Security and Privileges (DCL) Rules of SQL Queries and Statements Real-world applicative uses of SQL Creating Users and Tables Table Data Inserts and Validations Oracle Data Types DDL Commands with Examples CREATE, ALTER, TRUNCATE,DROP,RENAME Learn the DESCRIBE command to display the table structure DML Command DRL Commands Operators INSERT, UPDATE, DELETE Statements Difference between Truncate and Delete commands SELECT Statements with Multiplier SQL Comments Single Line Comments & Multi Line Comments WHERE Keyword for Query Conditions	CHAPTER 10 : SUB QUERIES, NESTED QUERIES Sub Queries in Real-world Dynamic Conditions with Sub Queries Sub Queries and Nested Sub Queries How does oracle Execute Nested Sub Queries? Inner Select and Outer Select Queries Usage of Sub Queries with WHERE, HAVING Impact of Having Clause in Sub Queries Select Nth Highest salary Select Duplicate Records Delete Duplicate Records Advantages of Oracle Sub Query Subquery in the Select Clause Examples Subquery in the From Clause Examples Display Odd Rows in a table Display Even Rows in a table Execution of Correlated Sub Queries in SQL IN, ANY SOME, ALL Operators in Sub Queries PAIR WISE and NON PAIR WISE in Sub Queries Single Row Subquery & Multiple Row Subquery Multiple Column Subquery UnCorrelated Subquery Difference between Correlated and Non-Correlated Subquery How does Oracle Execute Correlated Subquery? NULLs and Correlated Sub Queries in SQL	CHAPTER 16 : ADVANCED PL/SQL - 3 Pragma_Autonomous_Transaction() with SPs Returning into clause, Bulk Collect For All, Definer/Invoker Rights & Usage About Flash Back Queries, Dynamic SQL Flash Back Command, Purge Command Regular Expressions in PLSQL What is the Recycle Bin? How to Delete RecycleBin Table? How to Delete Recycle Bin? SQL Loader - Flat file into Oracle table Abstract Datatypes DML Error Logging and Virtual Columns Types of Triggers, Row Level Triggers Statement Level Triggers, DML Triggers DDL Triggers and Schema Level Triggers Using OLD & NEW References, Trigger Auditing Enabling / Disabling Triggers, Dropping Triggers Triggers in PL/SQL and Data Manipulations Using Memory Tables in Triggers DML and DDL Events with Triggers Compound Triggers, New data types Working with LARGE Tables in PLSQL New: EXTRACT(), Autonomous Transaction Pragma Exception_init in oracle
CHAPTER 5.SQL SPECIAL OPERATORS SET, AND, OR, NOT, IN Special Operators – IN (NOT IN) BETWEEN (NOT BETWEEN), Arithmetic and Logical Operators Understand Operator Precedence UNION, UNION ALL, INTERSECT, MINUS LIKE (NOT LIKE), IS NULL (IS NOT NULL) Understanding DCL and TCL Commands Transaction Concepts in Databases with SQL Transaction Types and Uses Commit and Rollback Operations Nested Transactions with Savepoints Database Read Consistency with SQL DDL and DML Operations with Transactions	CHAPTER 11: LOCKS in ORACLE TABLES Open Transactions and Lock Concepts Lock Types and Locking Mechanism Row Level Locks for Table Data Access Table Level Locks and Query Blocking Shared Lock and Real-time Use Shared Update Lock and Real-time Use Exclusive Lock and Real-time Use DeadLock : Detection, Prevention, Avoidance Implicit Locking Concepts in Oracle with PLSQL How to check howmany locks are occured? LOCK Hints and Query Blocking What is row exclusive lock in Oracle? What is lock in SQL? What are different types of locks?	CHAPTER 17: OBJECT TECHNOLOGY – Level I Object Technology and Applicative Use OOPS-Object Instances, Creation of Objects Creating User Defined Data Types Creating Object Tables in Oracle Inserting rows in Table using Object Retrieving data from Object Based Tables Calling a Method, Indexing Abstract Data type Attributes in PLSQL Advantages of Collections Ref Cursor (Dynamic Cursor), Weak Ref Cursor Strong Ref Cursors and Nested Tables Associative Arrays, VARRAYS/VARYING arrays Creating tables using Nested Tables Inserting, Updating & Deleting Nested, Table Records
CHAPTER 6: GROUPING QUERY RESULTS Identify Distinct Values in Tables Group Function or Aggregate function Group By Syntax Group By Operations in Queries Having Clause of DRL Statements Aggregate Functions with Group By Order By Clause and Group By SQL Group By Statement Query Execution Order with Group By Arithmetic Functions,Character Function Date & Time Functions,String Function Conversion Functions,Analytical Function Rank(), Dense_Rank(),Row_Number() NVL(),NVL2(), NullIF(),Coalesce()	CHAPTER 12 : PERFORMANCE (QUERY) TUNING Indexes - Definition and Architecture B Tree Concept in Indexes Clustered and Non clustered Indexes Primary Key and Clustered Index Unique Key and Non Clustered Indexes Simple Index, Rebuild Index Materialized Views - Indexed Views Composite Index, Function Based Index User_indexes System Table Range Partitions and Hash Partition Partion “VALUES LESS THAN “ Clause List Partition and Composite Partition Parallel Query Process with Partitions Performance Tuning Advantages	CHAPTER 18: OBJECT TECHNOLOGY – Level II Perform a Basic Search using the REGEXP_LIKE function patterns using the REGEXP_INSTR function Extract Substrings using the REGEXP_SUBSTR function Replace Patterns Using the REGEXP_REPLACE Invisible Columns in Oracle Database 12c What is fetch in SQL? Can we use limit in Oracle? What is offset in Oracle? Is PL SQL object oriented? What is Oracle object type? What is object type in Oracle PL SQL? Is Oracle object oriented database? What is PL SQL in Oracle? What is Oracle constructor?