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
🔹FREE DATA ANALYSIS COURSE 🔹
📌 𝗠𝗮𝘁𝗵 𝗮𝗻𝗱 𝗦𝘁𝗮𝘁𝗶𝘀𝘁𝗶𝗰𝘀
Intro to Statistics: Making Decisions Based on Data – Udacity https://lnkd.in/emBKtR6q
Statistics: The Science of Decisions – Udacity https://lnkd.in/etZb3RRs
Statistical Learning – Stanford University https://lnkd.in/e652ZdQq
Statistics and probability – Khan Academy https://lnkd.in/eev_vMmD
📌 𝗘𝘅𝗰𝗲𝗹
Introduction MS Excel Simplilearn https://lnkd.in/eNqNjzD6 PDF-https://lnkd.in/d_N7YKGf
Microsoft Excel: Online Tutorial for Beginners – Chandoo https://lnkd.in/eVkxeEFd
Microsoft Excel Tutorial for Beginners – Free Code Camp https://lnkd.in/eUnezzab
📌 𝗦𝗤𝗟
Introduction to SQL – Simplilearn https://lnkd.in/escuGm4T PDF –https://lnkd.in/gYe2iyFy
Introduction to SQL – SQL Bolt https://sqlbolt.com/
Learn SQL – CodeAcademy https://lnkd.in/eaABTh5C. PDF-https://lnkd.in/gZQWKX4D
SQL for Data Analysis – Udacity https://lnkd.in/eSifcBY4
📌 𝗧𝗮𝗯𝗹𝗲𝗮𝘂
Tableau Tutorials For Beginners – Alex The Analyst https://lnkd.in/ewe3CCrn
Learn Tableau Desktop for Accurate Business Analysis https://lnkd.in/eg2xXkEY
Kickstarting Tableau https://lnkd.in/eAHBHmTk
A Comprehensive Guide to Start Learning Tableauhttps://lnkd.in/evGbrj2n
Data Visualization in Tableau – Udacity https://lnkd.in/eHKRA8rd
📌 𝗣𝘆𝘁𝗵𝗼𝗻
Intro to Programming with Python – Kaggle https://lnkd.in/enNiTktY
Python Tutorials – Free Code Camp https://lnkd.in/esaAjvsY
Learn Pandas – Kaggle https://lnkd.in/eC6VPUzM
12 Beginner Python Projects – Free Code Camp https://lnkd.in/eprN5CZU
📌 𝗠𝗮𝘁𝗵 𝗮𝗻𝗱 𝗦𝘁𝗮𝘁𝗶𝘀𝘁𝗶𝗰𝘀
Intro to Statistics: Making Decisions Based on Data – Udacity https://lnkd.in/emBKtR6q
Statistics: The Science of Decisions – Udacity https://lnkd.in/etZb3RRs
Statistical Learning – Stanford University https://lnkd.in/e652ZdQq
Statistics and probability – Khan Academy https://lnkd.in/eev_vMmD
📌 𝗘𝘅𝗰𝗲𝗹
Introduction MS Excel Simplilearn https://lnkd.in/eNqNjzD6 PDF-https://lnkd.in/d_N7YKGf
Microsoft Excel: Online Tutorial for Beginners – Chandoo https://lnkd.in/eVkxeEFd
Microsoft Excel Tutorial for Beginners – Free Code Camp https://lnkd.in/eUnezzab
📌 𝗦𝗤𝗟
Introduction to SQL – Simplilearn https://lnkd.in/escuGm4T PDF –https://lnkd.in/gYe2iyFy
Introduction to SQL – SQL Bolt https://sqlbolt.com/
Learn SQL – CodeAcademy https://lnkd.in/eaABTh5C. PDF-https://lnkd.in/gZQWKX4D
SQL for Data Analysis – Udacity https://lnkd.in/eSifcBY4
📌 𝗧𝗮𝗯𝗹𝗲𝗮𝘂
Tableau Tutorials For Beginners – Alex The Analyst https://lnkd.in/ewe3CCrn
Learn Tableau Desktop for Accurate Business Analysis https://lnkd.in/eg2xXkEY
Kickstarting Tableau https://lnkd.in/eAHBHmTk
A Comprehensive Guide to Start Learning Tableauhttps://lnkd.in/evGbrj2n
Data Visualization in Tableau – Udacity https://lnkd.in/eHKRA8rd
📌 𝗣𝘆𝘁𝗵𝗼𝗻
Intro to Programming with Python – Kaggle https://lnkd.in/enNiTktY
Python Tutorials – Free Code Camp https://lnkd.in/esaAjvsY
Learn Pandas – Kaggle https://lnkd.in/eC6VPUzM
12 Beginner Python Projects – Free Code Camp https://lnkd.in/eprN5CZU
lnkd.in
LinkedIn
This link will take you to a page that’s not on LinkedIn
👍1
FREE Masterclass on how to crack your next SDE interviews with an SDE expert!
Join this session by industry expert Mayank Rastogi who is in the domain for the last 3 years and get your doubts clear 1:1
Register - https://visit.preplaced.in/7eo
Join this session by industry expert Mayank Rastogi who is in the domain for the last 3 years and get your doubts clear 1:1
Register - https://visit.preplaced.in/7eo
www.preplaced.in
Preplaced: India's Top Job Prep, Career Mentorship Platform
Top career mentorship platform in India! With Preplaced, you get 1:1 expert guidance from industry experts for your placement preparation journey.
Coding Interview ⛥
FREE Masterclass on how to crack your next SDE interviews with an SDE expert! Join this session by industry expert Mayank Rastogi who is in the domain for the last 3 years and get your doubts clear 1:1 Register - https://visit.preplaced.in/7eo
Soon all the sessions will be paid, it’s best opportunity to join and ask all your doubts 🚀🚀