soft skills and multiple scenario based questions
Sql Data Analyst Interview Questions
2,215 sql data analyst interview questions shared by candidates
Some technical questions are confusing but also because the interviewer doesn't know the answer either in detail and they only have some sort of "script" in paper
Table joins
One real-life application of my SQL knowledge to bring a solution to a problem.
2 rounds of interview with one is tech and other is manager round. Both of them almost Easy to Mid level and manageable. 2 rounds of interview with one is tech and other is manager round. Both of them almost Easy to Mid level and manageable.
Define Normalization in Sql. What is the need for it
About past experience and technologies I know
difference between udf and stored proc
Conceptos básicos de sql y unix/linux.
what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc
Viewing 1541 - 1550 interview questions