Hi all, I have been working in BI field for 7 years and my experience is around SAP BI... here and there I used SQL and I studied MIS so I learned it from school but I have never been a sql devoloper. Now I'm interviewing for BI analyst positions and they are all asking about my SQL level. I'm pretty comfortable and can solve all the free test online etc but I don't know what it means to have advance level SQL for BI? Please someone advice what should I do to have an advance level SQL What is advance SQL anyways:)? Thanks in advance
Performance tuning, theres a few leetcode data questions that were fun you can do.
CTEs , window functions , performance tuning , optimizing queries . I would say those are some examples of advanced SQL.