SQL/UNIX
HTML/CSS
10 days
SQL(Oracle)
25 days
UNIX
25 days
Real time Projects/Process
15 days
Resume preparation
15 days
Total
90 Days
HTML/CSS
10 days
SQL(Oracle)
25 days
UNIX
25 days
Real time Projects/Process
15 days
Resume preparation
15 days
Total – 90 Days
SQL SYLLABUS
Chapter 1: Introduction to SQL
- Introduction Database
- Understanding DBMS vs RDBMS
- Gone through SQL Standards
- Sub languages of SQL
- About SQL*Plus and use of developer tool
- Datatypes in Oracle
- Operators in Oracle
- Understanding Schema design and objects
Chapter 2: Data Retrieval Techniques
- How to use select statement in different ways to retrieve records?
- Working with Column alias
- Working with Table alias
- Data filtering and sorting with in single table
- Clauses and its types in oracle
- Where clause
- Having clause
- From clause
- Group by clause
- Order by clause
- Using clause
- Constraint clause
- For update clause
Chapter 3: Working With DDL Commands
- Table creation using CREATE statement
- Creating table from another table
- Dropping a table using DROP command
- Altering the column of a table
- Modifying the column datatype in a table
- Renaming the column of a table
- Renaming an entire table
- Using truncate command
- Difference between Delete and Truncate command
Chapter 4: Working With DML Commands
- How to copy data from one table to another table?
- How to copy the structure alone from a table?
- Different types of inserting row to an existing table
- Updating any value of with in a record using UPDATE command
- Deleting a particular record from a table
- Using merge & insert all command [Implementation of Project 1 ]
Chapter 5: Integrity Constraints
- How to declare column level constraints?
- How to declare row level constraints?
- How to add constraints to an existing table?
- Types of integrity constraints
- Not null
- Unique key
- Primary key
- Referential integrity
- Check integrity
- How to enable and disable constraints?
- How to get information about constraints?
Chapter 6: Built In Functions
- Understanding Single row functions
- How to use single row functions using dummy table?
- Types of single row functions
- String functions
- Date functions
- Mathematical functions
- Conversion functions
- Special functions
- Analytical functions
- Working with multi row functions
Chapter 7: Data Aggregation
- Working with aggregate function
- Count()
- Sum()
- Max()
- Min()
- Avg()
- Working with group by clause
- Working with having clause
- Difference between WHERE and HAVING clause
Chapter 8: Importance of JOIN
- Understanding joins and its uses
- Types of joins
- Equi join
- Non – equi join
- Self join
- Outer join
- Left & Right outer join
- Full outer join
- Cross join [Implementation of Project 3]
Chapter 9: Set Operators and Pseudo Columns
- How to use set operators in a single table content?
- Working with set operator types
- UNION
- UNION ALL
- INTERSECT
- MINUS
- Working with pseudo columns using the following
- ROWID
- ROWNUM
Chapter 10: Sub Queries
- Importance of sub queries
- Using different types of sub queries
- Single row sub queries
- Multi row sub queries
- Nested queries
- Multi column sub queries
- Correlated sub queries
- Using inline views and scalar queries
Chapter 11: Database Transaction and Security
- Working with data query language using TCL
- Working with data control language commands
- Use of commit and rollback
- Use of save point and set transaction
- How to give system privileges to a user?
- How to invoke and revoke object privileges?
Chapter 12: Design of Schema Objects
- Creating and working with Views
- Working with Synonyms
- Creating Index
- Working with in materialized view
UNIX SYLLABUS
Chapter 1
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.Kill
22.ftp and SFTP(File Transfer Protocal)
23.scp(Secure copy)
24.ssh
25.chmod, chown, chgrp
26.History
27.otp
28.PS -ef
Chapter 2
29.awk
30.crontab
31.Zombie process
32.hard link and soft link
33.locate
34.bg and fg
35.du and df
36.man
37.uname
38.paste
39.split
40.inode–start command
41.pwd
42.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.netstat, stat
54.bg and fg
55.jobs
56.at command
57.Cron schduling
Unix shell scripting
Unix / Linux – Shell Scripting
Unix / Linux – What is Shell?
Unix / Linux – Using Variables
Unix / Linux – Special Variables
Unix / Linux – Using Arrays
Unix / Linux – Basic Operators
Unix / Linux – Decision Making
Unix / Linux – Shell Loops
Unix / Linux – Loop Control
Unix / Linux – Shell Substitutions
Unix / Linux – Quoting Mechanisms
Unix / Linux – IO Redirections
Unix / Linux – Shell Functions
Unix / Linux – Manpage Help
Schduling tool
Autosys
UI based Job schduling
Command based schduling
SDLC – Software development Life cycle
Waterfall Model
Agile- we are following
Agile Ensures Parallel processing – Advantages of Agile model
Product backlog
Sprint Backlog
JIRA
GIT
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
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.