Adanced SQL Problems

AT&T
BigDataEng

Go to company page AT&T

BigDataEng
May 8, 2020 5 Comments

hey everyone ! Any pointers to improve complex SQL problems other than Hackerrank and Leet Code

comments

Want to comment? LOG IN or SIGN UP
TOP 5 Comments
  • Twitter / Data
    KC1

    Go to company page Twitter Data

    KC1
    I didn’t even know complex SQL practice problems existed.

    I’m honestly not sure how you’d do it since:

    A. Optimization is super vendor-specific like someone else said.

    B. The hardest part of SQL isnt syntax but knowing where the data lives and the intricacies of those specific tables and how they map to other tables. Production DBs are a result of a lot of moving parts and years of accumulated neglect... I’m not sure you could even intentionally recreate that if you tried. Even if you could, tough to expect a candidate to suss that out in the span of an interview.

    Personally the hardest SQL question I’ve ever been asked was implementing a window function and this was just talking out how I’d query something against a hypothetical table, not actually firing anything.
    May 8, 2020 0
  • Brute force. Just interview for positions you won’t accept. I’ve never found a good resource that had SQL interview questions. The ones that do are easy. I got really good by trial and error in interviews.
    May 8, 2020 0
  • Uber
    tsee

    Go to company page Uber

    tsee
    Most of the big companies won’t ask super advanced sql even for senior data scientist roles. Leetcode medium DB section, maybe some of the harder that should be medium, is all you need
    May 8, 2020 0
  • Oracle
    kO8lz

    Go to company page Oracle

    kO8lz
    Beyond that all you've got is query optimization and db vendor specific things. Vendor specific features don't tend to matter too much in interviews. Optimization is a pretty out there topic and most people don't know what to do with it past indexing. Just read about indices and know how to create one, you'll be fine.
    May 8, 2020 0
  • New / Data
    data52

    New Data

    data52
    The HackerRank SQL Questions are more "algorithm" in nature. They're really weird, nothing like you'd ever see on the job. LeetCode has SQL questions that make sense, table joins, aggregations, window functions, CTEs vs SubQueries, top n, return 3rd highest, etc.
    Oct 3, 2021 0