SQL AND UNIX TRAINING IN CHENNAI
SQL SYLLABUS
Introduction
Clauses
Syntax and semantic check
Order by
Column alias
Concat
Distinct
Dual
Logical and relational
Single row functions
Number
Character
Date
Data type
General functions
Pseudo columns
Level
Control statements - case decode
Set operators
Joins
Group functions
Analytical functions
Subquery
Constraints
Ddl
TCL
Dml
View and Mview
Data dictiona
PRODUCTION SUPPORT SYLLABUS
What is Production support
- Characteristics of Production support engineer
- What’s under Production support umbrella
incident and request
- Difference between incident and request
Incident management
- Who will create the incident?
priority
- What is priority?
SLA
- What is SLA
What is the approach to resolve the incident
- Scenario 1 (reroute to different team)
- Scenario 2 (planned downtime and maintenance time)
- Scenario 3 ( Access Request)
- Scenario 4: (reports generate using sql)
- Scenario 5 (file transfer)
- Scenario 5.1 (file transfer)
table names
- Can you tell your table names
Problem management
- Scenario for problem management
P1 Incident in a SHIFT
- What happens when you get a P1 Incident in a SHIFT
Change management
- Change management
Tell me about yourself
- Tell me about yourself
E-mart SPG
- About Project (E-mart SPG)
Shift Timing
- Shift Timing
IT Jargon
- IT Jargon Words
Do’s and Don’ts in office
- Do’s
- Don’t
Interview Questions
- Frequently asked questions during Interview scheduling
project and team members
- Hierarchy level of our project and team members
UNIX SYLLABUS
Chapter 1
- manipulating directories(mkdir, rmdir, cd)
- manipulating files(touch, cat, tac)
- List files(ls along with options)
- more and less
- WC(Word Count)
Chapter 2
- Sort(assecding or descending order)
- clear
- date, cal
- sed
- find
Chapter 3
- copy file and folders
- Rename/move
- cut
- cmp
- diff
Chapter 4
- vi
- grep, egrep, fgrep, zgrep
- head
- tail
- uniq
Chapter 5
- mail and SMTP
- Kill
- ftp(File Transfer Protocal)
- scp(Secure copy)
- ssh
Chapter 6
- chmod, chown, chgrp
- History
- otp
- PS -ef
- awk
Chapter 7
- crontab
- Zombie process
- hard link and soft link
- locate
- du and df
Chapter 8
- man
- uname
- paste
- split
- inode–start command
Chapter 9
- pwd
- telnet
- $?, $0, $1, $$, $!
- uptime
- who
Chapter 10
- whoami
- Compress and uncompress(gzip,gunzip,bzip2,bunzip2)
- Combaining multiple indepandent into single command usinf
- Combining multiple dependent command into single command using |
- tr command
Chapter 11
- umask
- DB connection
- free
- netstat, stat
Take the First Step Towards a Brighter Future
Don't miss out on the opportunity to enhance your skills and secure a promising career. Enroll in our training programs today and take advantage of our job placement services.