java_interview.pdf
501.6 KB
𝗝𝗮𝘃𝗮 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗔𝗻𝗱 𝗔𝗻𝘀𝘄𝗲𝗿𝘀 𝗶𝗻 𝟰𝟱 𝗽𝗮𝗴𝗲𝘀✍️ 🎯
Frequently asked SQL interview questions for Data analyst role-
1 - Order of execution of SQL query?
2 - Order of writing SQL query?
3 - All types of joins and questions on their outputs?
4 - Explain all window functions and difference between them?
5 - What is stored procedure?
6 - Difference between stored procedure & Functions in SQL?
7 - What is trigger in SQL?
8 - Difference between where and having?
1 - Order of execution of SQL query?
2 - Order of writing SQL query?
3 - All types of joins and questions on their outputs?
4 - Explain all window functions and difference between them?
5 - What is stored procedure?
6 - Difference between stored procedure & Functions in SQL?
7 - What is trigger in SQL?
8 - Difference between where and having?
Important things to focus in Excel for interview(Data Analyst) -
Lookups - (Vlookup, Xlookup, Hlookup)
Pivot table
Conditional Formatting
Formulas like - index match, Sumifs, countifs, avg, minifs, maxifs, concatenate, len, left, right, Counta, countblank... etc. with multiple sheet references
Practice Custom formula creation
Data validation
Visualization with excel (not mandatory but prefered)
Macros and How to create macros in excel?
Lookups - (Vlookup, Xlookup, Hlookup)
Pivot table
Conditional Formatting
Formulas like - index match, Sumifs, countifs, avg, minifs, maxifs, concatenate, len, left, right, Counta, countblank... etc. with multiple sheet references
Practice Custom formula creation
Data validation
Visualization with excel (not mandatory but prefered)
Macros and How to create macros in excel?
👍1
Tips to get interview scheduled as a fresher apart from resume strengthening - :
- Never stop applying for suitable roles.
- Make your profile strong on different job platforms like linkedin, naukri, instahyre... etc. And keep updating your profiles on these platforms on daily basis and don't stop applying.
- Directly ask to managerial level people of that company where you are applying for referral in linked in.
- Never stop applying for suitable roles.
- Make your profile strong on different job platforms like linkedin, naukri, instahyre... etc. And keep updating your profiles on these platforms on daily basis and don't stop applying.
- Directly ask to managerial level people of that company where you are applying for referral in linked in.
Hello everyone,
For everyone who is preparing for their interviews make sure to check out this platform - https://visit.preplaced.in/s6x
They have huge list of mentors that help students get job. Plus their placement rate has been around 72%.
All the best.
For everyone who is preparing for their interviews make sure to check out this platform - https://visit.preplaced.in/s6x
They have huge list of mentors that help students get job. Plus their placement rate has been around 72%.
All the best.
www.preplaced.in
Preplaced: ddSupercharge your career with 1:1 Long Term Mentorship
Imagine the world's best mentors taking complete responsibility of your career goals
👍1
If you are looking forward to learn Java , checkout Riddhi Dutta's channel:
https://youtube.com/@rite2riddhi
He has put Free Java Tutorial Courses(One Shot Video) on Entire Collection Framework(very helpful for DSA prep) ,
A complete course on Multithreading and Concurrency
Functional Programming and Lambdas.
https://youtube.com/@rite2riddhi
He has put Free Java Tutorial Courses(One Shot Video) on Entire Collection Framework(very helpful for DSA prep) ,
A complete course on Multithreading and Concurrency
Functional Programming and Lambdas.
Shrayansh (SDE at Paypal) taking a session on how to crack your dream job.
Session aj hai from 8pm to 9pm
(Free for everyone)
Make sure to join, Jo sb log paise lekr samjha rahe yaha free mein sikhne ko milega😂😂
https://links.acciojob.com/41obyRa
Session aj hai from 8pm to 9pm
(Free for everyone)
Make sure to join, Jo sb log paise lekr samjha rahe yaha free mein sikhne ko milega😂😂
https://links.acciojob.com/41obyRa
Junior Devops interview Experience **********
1. What is web server, what is the the difference between Apache n nginix , describe their working mechanism.
2. What are the meaning of different error codes such as 202, 404, 501.
3. Elaborate different EC2 purchasing options.
4. How AWS lambda works.
5. describe AWS IAM user, groups and roles.
6. How we can set up a proper VPC.
7. Describe how we can create S3 bucket and how we can store objects on it.
8. Why we use code commit , code deploy and code build, how we integrate all of them?
9. Though we can use all of above then what is the use of code pipeline?
10. What is IAC, describe Terraform workflow.
11. Elaborate tf init, plan, validate , apply and destroy.
12. What are attributes and arguments in Terraform?
13. What is tr taint?
14. Difference between docker and kubernetes?
15. Elaborate deployment, replica set.
16. Describe k8s services and ingress.
17. Do you know RBAC, can you explain it.
18. What is the difference between ansible and Terraform.
19. Write a playbook for Apache and nginix installation.
20. What is cloud computing and what do you mean by virtualization?
21. Difference between virtualization and containerization.
22. Do you know Python, what is list comprehension mechanism in python?
23. Difference between deep copy and shallow copy in python.
24. Writing some logic in python.
25. Write a deployment manifest for k8s.
26. Why you want to join this company.
27. What is the roles n responsibilities.
28. Some questions related to projects.
29. can you describe SDLC .
30. Difference between agile methodologies and DevOps methodology.
31. One question related to shell scripting.
32. 2-3 questions of Jenkins: what is ci/cd, and others i forgot.
33. difference between application and network load balancer.
1. What is web server, what is the the difference between Apache n nginix , describe their working mechanism.
2. What are the meaning of different error codes such as 202, 404, 501.
3. Elaborate different EC2 purchasing options.
4. How AWS lambda works.
5. describe AWS IAM user, groups and roles.
6. How we can set up a proper VPC.
7. Describe how we can create S3 bucket and how we can store objects on it.
8. Why we use code commit , code deploy and code build, how we integrate all of them?
9. Though we can use all of above then what is the use of code pipeline?
10. What is IAC, describe Terraform workflow.
11. Elaborate tf init, plan, validate , apply and destroy.
12. What are attributes and arguments in Terraform?
13. What is tr taint?
14. Difference between docker and kubernetes?
15. Elaborate deployment, replica set.
16. Describe k8s services and ingress.
17. Do you know RBAC, can you explain it.
18. What is the difference between ansible and Terraform.
19. Write a playbook for Apache and nginix installation.
20. What is cloud computing and what do you mean by virtualization?
21. Difference between virtualization and containerization.
22. Do you know Python, what is list comprehension mechanism in python?
23. Difference between deep copy and shallow copy in python.
24. Writing some logic in python.
25. Write a deployment manifest for k8s.
26. Why you want to join this company.
27. What is the roles n responsibilities.
28. Some questions related to projects.
29. can you describe SDLC .
30. Difference between agile methodologies and DevOps methodology.
31. One question related to shell scripting.
32. 2-3 questions of Jenkins: what is ci/cd, and others i forgot.
33. difference between application and network load balancer.
🔥1🤩1