Meesho - Business Analyst
Today, I took a test for the role of Business Analyst at Meesho. The test consisted of three questions, with the first two being moderate in difficulty compared to the third. The first two questions were multiple-choice, requiring me to find bugs in the code. However, the third question was significantly more challenging, as it required writing an advanced SQL query, which was something I had never encountered before.
I understand that it's common for startups to set challenging test papers, but I'm looking for advice on how to tackle advanced SQL queries and how to practice them effectively
Other than practising the SELECT, UPDATE, INSERT and DELETE SQLS, which are mainly for common use cases, you can try out other techniques to perform advanced queries. Here are some of the most advanced SQL techniques you can practice to crack the business analyst role, next time.
-
Window Functions: If you want to calculate a “window” of data which is defined by a table’s specific subset, you can use the window functions.
-
Recursive Queries: This technique helps you perform hierarchical or repetitive computations on data organised in a tree- or graph-like style. If you want to calculate the estimated cost of a string of interconnected transactions, you can use this method.
-
Common Table Expressions: Using this technique, you can create a temporary-named result that can be used in later queries within the session. If you can’t manage a complex query, with this method you can break it into simpler and easy-to-manage parts.
Thank.you
I will practice these types of questions
But in reality they are not using it