1. Tell me something about yourself? 2.What is difference between method and constructor? 3. what is big O notation in java? 4.How many types of joins are there in SQL?
Sql Data Analyst Interview Questions
2,215 sql data analyst interview questions shared by candidates
Most complex / satifying project / work you did.
1. If month inbetween jan and jul then 2022 else 2023. What function used to find and how? 2. Analytical functions example 3. Challenges faced in previous project
Mostly they covered all SQL concepts
Interviewer gave two tables and asked number of rows after inner, left outer, right outer joins
about clustering.
SQL Server , Service packs , cluster , alwayson, nirroring
Difference between rank and dense rank
Q: What is views and Materialized views.
To explaining about day to day activities
Viewing 901 - 910 interview questions