@NickSinghTech

Founder of https://xitter.cf/t.co/yyE4B5M1eN (SQL Interview Prep, 250k+ users). Author of Ace the Data Science Interview (50k+ books sold). Ex-Meta. 185k+ on LinkedIn.

 Washington DC
datalemur.com/questions
Joined February 2014
  • Tweets3.3K
  • Following4.3K
  • Followers32.9K
759Media
🚨 DataLemur is LIVE! 🚨 Solve 50+ SQL Interview questions from companies like Facebook, Amazon, and Google for FREE! Even if you aren’t on the job hunt, DataLemur is still a great place to practice your #SQL skills on tricky problems: datalemur.com/
24
229
9
876
2022 Mood
1
941
Mastering Data Structures & Algorithms is a game-changer. It's not about interviews or reinventing the wheel. It's about understanding the universal patterns we use to organize information (data structures) and then process that information (algorithms).
2
1
957
Mathematicians are curious about how the world works, so they devout thousands of hours and their high IQs to toil for their noble goal (often for little pay, results, or recognition). Meanwhile the rest of us in the real world would be happy to have a cancer cure, our 401k 10x, and our team win the Superbowl. Whether a human mathematician could explain the results of this outcome is so irrelevant to 99% of folks. Hilarious Terrence Tao is trying to relate in this way.
Andrew Curran
@AndrewCurran_Oct 10
This is a slide from Terence Tao's 'Math 2.0' public lecture yesterday evening at Caltech. I am highly confident that, if the cure actually worked, almost any Stage 4 cancer patient would tell you that human comprehension of its mechanism is completely irrelevant to them.
1
3
1,095
Truth
1
6
874
absence of evidence ≠ evidence of absence sample estimate ≠ true effect size randomisation ≠ random sampling statistically significant ≠ relevant multivariate ≠ multivariable 95% CI ≠ 95% probability p-value ≠ probability H0 correlation ≠ causation bias ≠ error
2
3
983
Quirky Guide on Common SQL Queries 🍋🍎🍐
1
1
2
754
Cue the bias 😂
1
6
1,078
Mastering the boring basics of Data Science is how you become an expert.
2
1
9
1,296
Common SQL Interview Question: How do you optimize a slow SQL query? Answers Include: •Avoid SELECT DISTINCT •Create joins with INNER JOIN (not WHERE) •Avoid JOINs in general (maybe try de-normalization) •Add indexes to your database •Examine the SQL query execution plan
1
2
1,126
okay which one of you made this
2
1,080
“Can you explain this gap on your resume?” Can you explain this gap on your team?
3
1,074
If Eminem queried SQL 😂 Credit: @DataWithDanny
2
6
1,069
Life Hack To Start Your Morning With More Energy
8
1,093
Why did you become a Data Scientist/Analyst? Wrong answers only
2
6
1,421
The 5 most common aggregate functions used in SQL interviews are: AVG() - Returns the average value COUNT() - Returns the number of rows MAX() - Returns the largest value MIN() - Returns the smallest value SUM() - Returns the sum array_agg() / string_agg() rarely show up.
1
1
1,037
The 5 most common aggregate functions used in SQL interviews are: AVG() - Returns the average value COUNT() - Returns the number of rows MAX() - Returns the largest value MIN() - Returns the smallest value SUM() - Returns the sum array_agg() / string_agg() rarely show up.
1
5
1,142
Here's a morning hack for you 😄
1,052
I don't know who needs to hear this, but the central limit theorem doesn't magically “kick in” at n=30.
6
1,096
LinkedIn SQL Interview Question: Given a table containing job postings from various companies on the LinkedIn platform, write a query to retrieve the count of companies that have posted duplicate job listings. Practice this question on DataLemur: datalemur.com/questions/dupl…
5
1,086
Massively Long AI. The token cost will get cheaper, but we literally had the $1m prize because humanity couldn't figure it out – until now!
Daniel
@growing_danielSep 8
OpenAI spent $15m in tokens to solve a problem with a $1m prize. Standard AI economics here
1
2
1,076
Load more