bradley-n-miller-david-l-ranum-problem-solving-with-2011.pdf
4.2 MB
Problem Solving with Algorithms and Data Structures Using Python
Brad Miller, 2013
Brad Miller, 2013
Dynamic SQL, 2nd Edition.pdf
10.8 MB
Dynamic SQL
Edward Pollack, 2019
Edward Pollack, 2019
Learn C Programming, 2nd Edition (Jef.).pdf
15 MB
Learn C programming
Jeff Szuhay, 2022
Jeff Szuhay, 2022
Learning Kotlin.pdf
1.3 MB
Learning Kotlin
Stack Overflow contributors
Stack Overflow contributors
👍1
Dynamic_Programming_for_Coding_Interviews_A_Bottom.pdf
42 MB
Dynamic Programming for Coding Interviews
Kamal Rawat Meenakshi , 2017
Kamal Rawat Meenakshi , 2017
Graphs and Networks .pdf
6.9 MB
Graphs and Networks
S. R. Kingan, 2022
S. R. Kingan, 2022
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