How hard can a SQL interview go?

Walmart / Data getpaid
Aug 14 25 Comments

Have a SQL interview with another e-commerce company tomorrow for a data analyst role. Wonder if leetcode is enough for this kind of role?

comments

Want to comment? LOG IN or SIGN UP
TOP 25 Comments
  • Amazon 🤠== 8
    Leetcode is for algorithms, the sql on the site is very basic.
    Aug 14 3
    • Walmart / Data getpaid
      OP
      Thank you very much!
      Aug 14
    • New Jaiwho
      Any recommendations on a resource similar to Leetcode for SQL?
      Aug 14
    • Walmart / Data getpaid
      OP
      I tried hackerrank + leetcode. U can check it out
      Aug 14
  • Fanatics coder07
    SQL topics to focus on
    1. Group By ( aggregation)
    2. Where vs having clause
    3. Inner and outer joins
    4. Union vs union all
    5. Nulls , and how they affect your queries
    6. Sub query, depends on your experience and their requirements
    7. Case statements

    Good luck OP. Please let us know how it goes and also what kinda questions they asked.
    Aug 15 0
  • Western Union 30ssss
    Is it for Wayfair? 😆
    Aug 14 13
    • New / Strategy
      Porsche996

      New Strategy

      BIO
      BS MechE, MS ISyE
      Porsche996more
      Reply Walmart
      Aug 15
    • Walmart / Data getpaid
      OP
      A while ago. Not new not old. Why?
      Aug 15
    • Walmart / Data getpaid
      OP
      Replied Porsche996
      Aug 15
    • New / Strategy
      Porsche996

      New Strategy

      BIO
      BS MechE, MS ISyE
      Porsche996more
      Friend was complaining recently so want to test the hypothesis.
      Aug 15
    • Walmart / Data getpaid
      OP
      R u my friend?
      Aug 15
  • Signpost BL07
    I see all suggestions above related to basic SQL. In a data analyst role, you’ll often require window functions and will be tested on that.
    Aug 17 0
  • Apple / Eng misled
    Fizzbuzz
    Aug 14 0
  • Walmart / Data getpaid
    OP
    Thank you so muchhhh!!
    Aug 15 1
    • Fanatics coder07
      You're welcome!
      Aug 15
  • New / Strategy
    Porsche996

    New Strategy

    BIO
    BS MechE, MS ISyE
    Porsche996more
    You cant go to Amazon. There is a NDA.
    Aug 14 1
    • Walmart / Data getpaid
      OP
      True that. This is for a small company.
      Aug 14

Salary
Comparison

    Real time salary information from verified employees