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.