@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
760Media
🚨 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
878
Nick Singh | The Data Science Guy 📕 retweeted
Osvaldo Ruiz | Data Analysis@ORuizCodeOct 23
Back to my daily #SQL practice questions. Today's focus was joining two tables and ordering the results with a limit. Check it out: datalemur.com/questions/comp… #DataLemur #Robinhood @NickSinghTech

Robinhood SQL Interview Question | DataLemur

Robinhood SQL Interview Question: Write a query to find the cities with the highest completed trades.

datalemur.com
1
1
131
Do you agree with this? Any ideas on how we can better structure the technical interview process?
2
4
823
99% of people have Portfolio Project ideas 10% start working on their project ideas 1% turn their idea into a reality Taking action gets you far, but it’s finishing what you start that truly sets you apart.
1
1
8
1,028
2022 Mood
3
961
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
971
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
4
1,103
Truth
1
7
880
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
4
986
Quirky Guide on Common SQL Queries 🍋🍎🍐
1
1
3
756
Cue the bias 😂
1
6
1,079
Mastering the boring basics of Data Science is how you become an expert.
2
1
9
1,297
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,130
okay which one of you made this
2
1,081
“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
Load more