SQL and UNIX TRAINING IN CHENNAI

Program Contents:

Sql Syllabus

1. Introduction
2. Clauses
3. Syntax and semantic check
4. Order by
5. Column alias
6. Concat
7. Distinct
8. Dual
9. Logical and relational
10. Single row functions
11. Number
12. Character
13. Date
14. Data type
15. General functions
16.Pseudo columns
17. Level
18. Control statements
     - case decode
19. Set operators
20. Joins
21. Group functions
22. Analytical functions
23. Subquery
24. Constraints
25. Ddl
26. TCL
27. Dml
28. View and Mview
29. Data dictiona

Production Support Syllabus

Program Contents:

1. What is Production support? 3
      1.1 Characteristics of Production support engineer 3
      1.2 What’s under Production support umbrella 3
2. Difference between incident and request: 4
3. Incident management: 5
      3.1 Who will create the incident? 5
4. What is priority? 5
5. What is SLA 6
6. What is the approach to resolve the incident 7
      6.1 Scenario 1 (reroute to different team) 9
      6.2 Scenario 2 (planned downtime and maintenance time) 10
      6.3 Scenario 3 ( Access Request) 10
      6.4 Scenario 4: (reports generate using sql) 11
      6.5 Scenario 5 (file transfer) 11
      6.5.1 Scenario 5.1 (file transfer) 12
7. Can you tell your table names: 13
8 Problem management : 13
      8.1 Scenario for problem management 2: 14
9. What happens when you get a P1 Incident in a SHIFT 15
10. Change management: 16
11. Tell me about yourself 18
12. About Project (E-mart SPG) 19
13. Shift Timing: 19
14. IT Jargon Words 20
15. Do’s and Don’ts in office 20
      15.1 Do’s: 20
      15.2 Don’t: 20
16. Frequently asked questions during Interview scheduling 20
17. Hierarchy level of our project and team members 22

Unix Syllabus

Program Contents:

1.manipulating directories(mkdir, rmdir, cd)
2.manipulating files(touch, cat, tac)
3.List files(ls along with options)
4.more and less
5.WC(Word Count)
6.Sort(assecding or descending order)
7.clear
8.date, cal
9.sed
10.find
11.copy file and folders
12.Rename/move
13.cut
14.cmp
15.diff
16.vi
17.grep, egrep, fgrep, zgrep
18.head
19.tail
20.uniq
21.mail and SMTP
22.Kill
23.ftp(File Transfer Protocal)
24.scp(Secure copy)
25.ssh
26.chmod, chown, chgrp
28.History
29.otp
30.PS -ef
31.awk
32.crontab
33.Zombie process
34.hard link and soft link
35.locate
36.du and df
37.man
38.uname
39.paste
40.split
41.inode--start command
42.pwd
43.telnet
43.$?, $0, $1, $$, $!
44.uptime
45.who
46.whoami
47.Compress and uncompress(gzip,gunzip,bzip2,bunzip2)
48.Combaining multiple indepandent into single command usinf ; &&
49.Combining multiple dependent command into single command using |
50.tr command
51.umask
52.DB connection
53.free
54.netstat, stat