✅ Round-Wise Prep Plan
🔹 1. Aptitude Test (Quants + Reasoning + English)
🔸 Topics to Cover:
Percentages, Profit & Loss, Time & Work, Averages
Seating arrangement, directions, puzzles
Syllogisms, blood relations, number series
Synonyms, antonyms, reading comprehension
🔸 Resources:
IndiaBix
GeeksforGeeks Aptitude
[RS Aggarwal Aptitude Book (PDF or hardcopy)]
🔸 Practice: 10–15 questions daily for 7 days
🔹 2. Technical Test (SQL, OOPs, DSA)
🔸 Important SQL Concepts:
Joins (inner, left, self)
Group By, Having, Order By
Subqueries & Nested Queries
Window Functions (ROW_NUMBER, RANK)
Normalization (1NF to 3NF), Indexing
📌 Practice Queries:
sql
Copy
Edit
-- Q: Find 2nd highest salary from employee table
SELECT MAX(salary) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);
🔸 OOP Concepts:
Inheritance, Polymorphism, Encapsulation, Abstraction
Real-life examples (e.g., Animal -> Dog/Cat classes)
Java/C++/Python class syntax
🔸 DSA Topics (for light MCQs):
Arrays, Strings, Sorting (bubble, selection)
Recursion basics
Stack/Queue concepts
🔹 3. Technical Interview Prep
This is the most crucial round. You’ll be grilled on:
✅ SQL
You must be fluent in writing SQL queries on paper or in editor
Sample Qs:
Write a query to fetch top 3 highest-paid employees per department
Normalize a flat table into 2NF
