DataLemur | Ace the SQL Interview @DataLemurHQ
Follow for SQL Interview tips. Made by @NickSinghTech, Author of Ace the Data Science Interview! Start solving 200+ FAANG SQL questions for FREE 👇 datalemur.com/questions San Francisco Joined July 2022-
Tweets476
-
Followers3K
-
Following47
-
Likes262
SQL Interviews LOVE to test you on Window Functions. Here’s the 7 most popular window functions & some real SQL interview questions to practice these commands 👇
CVS Health SQL Interview Question: Write a SQL query to find the top 3 most profitable medicines sold, and how much profit they made. Assume that there are no ties in the profits. Display the result from the highest to the lowest total profit.
Google's results for "SQL Interview Questions" are SUPER SHITTY. Hiring a plumber? You'd ask 'How to unclog this💩?' not 'What is a toilet🚽?' Similarly, data interviews don't ask 'What's SQL?'. They craft ask you to write SQL queries to answer realistic business questions.
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 Let's practice these on a JP Morgan dataset:
If you’re starting out in Data Science/Analytics, don’t worry about probability, statistics, or Machine Learning. Start by learning SQL, then get get good at visualizing data in a tool like Excel or Tableau. At the start of your data journey, don't overcomplicate things!
SQL interview question: How would you design the DB schema for a ride-sharing app like Uber? What are some tables you'd create? What primary & foreign keys should you use? What fields should you index things on?
99% of data jobs won't ask you simple SQL interview questions like “What does GROUP BY do?" Instead, you'll have to write a SQL query which uses GROUP BY to solve a real-world problem, like in this Tesla interview question:
Solve this LinkedIn SQL Interview Question together! 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. Input Data & Our Solution 🧵👇
Google's search results for "SQL Interview Questions" are TERRIBLE and mislead Data Analysts/Data Scientists into studying the WRONG THINGS! Book mark this thread - we're about to cover what companies ~actually~ ask in SQL interviews, and how to best prepare for these questions!
From reviewing 50+ resumes while I worked at Facebook, the most common mistake I saw was: ❌ Stuffing a resume with irrelevant details ❌ 3 Examples of this Resume Mistake: 1. In the summary/objective, they’d talk about how passionate they were about Data Engineering (while…
Confession: I STILL mess up the SQL Order of Operations 😅 Queries get written: SELECT FROM WHERE GROUP BY HAVING ORDER BY LIMIT But their executed: FROM WHERE GROUP BY HAVING SELECT ORDER BY LIMIT Please tell me I'm not the only one who mis-orders these?
everything in data except SQL was a mistake
Microsoft SQL Interview Question: Write a query to identify the top 2 Power Users who sent the highest number of messages on Microsoft Teams in August 2022. Display the IDs of these 2 users along with the total number of messages they sent.
Learning SQL? Here's 3 big mistakes beginners should avoid when learning SQL:
It's wild to see how fast salaries can grow in Data Science & Analytics. Below is Charlotte Chaze's entire salary history which she put publicly on her LinkedIn profile!
Data Science interviews cover WAY more than just SQL. You can expect technical questions on: •Probability & Statistics •Machine Learning •Coding (Data Structures & Pandas) •Product-Sense •A/B Testing To help you prep, here's a FREE 9-day Data Interview Crash Course👇
If Eminem queried SQL 😂 Credit: @DataWithDanny
Nick Singh | The Data.. @NickSinghTech
30K Followers 4K Following Author of Ace the Data Science Interview. Free Book Preview 👇 https://t.co/1izgOFy1Kt Founder of https://t.co/yyE4B5Ltpf (SQL Interview Prep) Ex-FacebookAishwarya Nevrekar @nevrekaraishwa2
45K Followers 960 Following I post about data science and memes. Chapter Lead at Omdena Mumbai Chapter Your only limit is your mind. DM for Collaborations 📩Sachin Kumar @Sachintukumar
10K Followers 168 Following Tweets on Data Science, Machine Learning & Deep Learning || Python 🐍 || SQL👨💻 || Appeared in Civil Service Exam || 12K on @Linkedin🤝 📩 for CollaborationKshiteej Pitta @KshiteejPitt
109 Followers 516 FollowingEfficiency Factory @ConsultingGodp
23 Followers 177 FollowingNM @genser99
61 Followers 270 FollowingMahesh Dehar 🕉 @Freakadelic06
564 Followers 5K Following जय श्री राम ; Punjabi Hindu, born and bred in Malaysia.jam @agamal0994
1 Followers 19 FollowingData Wizard @DataWizardPhd
17 Followers 484 Following For the love of data, mathematics, and solving a puzzles.Johnny English @JohnDoe1414454
111 Followers 408 FollowingMahima @SreeNispark
2 Followers 77 FollowingTaufik @taufikwanahmad
208 Followers 879 Following Ummat Nabi Saw | Power BI Consultant | Public Gold Dealer | PHS Exclusive Agent |Shubham Mishra @are_mishraaa
104 Followers 555 Followingangel razh @angelrazh
7 Followers 1K FollowingDebra @debra_colten84
216 Followers 3K FollowingSalman @m_salmann
0 Followers 1K Followingsuryakant mishra @suryakant4u_
28 Followers 50 Following Data Enthusiast | Exploring Data EngineeringMahesh H @MaheshH72094190
1 Followers 44 FollowingShadrack Osero @ShadrackOsero
835 Followers 5K Following |YALI RLC Alumni|Imara Africa alumni| Graduate Student at the Pennsylvania State University Park|Di Vine @Divine56624
36 Followers 153 Following God❤️||tech👩💻||HTML||CSS||JavaScript||Frontend||python||Flaskmd.yusuf @yusufm223
8 Followers 564 FollowingMohd | Data analyst @Ask2me__
7 Followers 70 FollowingNikunj Mathur @nikunjmathur3
97 Followers 1K FollowingSidnei Pacheco @sidneipjunior
84 Followers 1K Following co-founder, ruby, typescript & Fullstack developer & CTO at gurupassAnurag Gupta @AnuragGupt51262
0 Followers 118 FollowingJohn Obinyan🐉 MON @john_obinyan
7 Followers 31 Followingprince GM 🇲🇼, @PrinceGM265MW
443 Followers 1K FollowingSaumya🍁 @Saumyasarkhel
9 Followers 76 FollowingUgbaje Innocent 🇳�.. @theibesone
29 Followers 144 Following Business Developer | Data Analyst | Microsoft Excel | SQL | PowerBI | Data Visualization | Power Query | Big Data | AI- Copilot..Cognos Link up for enquiry.....Matthew Tate @Matthew81902
43 Followers 215 FollowingPavan @pavantechworld
0 Followers 211 FollowingVfenek @vfenek
9 Followers 34 FollowingDineshk @denesh612
3 Followers 29 FollowingWasim shaikh @swasim73
80 Followers 2K Following Software Developer | Free thinker | Loves traveling.CodeToCompass @code2compass
33 Followers 422 Following GNSS Data Scientist | Python Programmer | Machine Learning EnthusiastEmre @emresirma1
1 Followers 96 Followingvicsthedude @vicsthedude
14 Followers 333 FollowingKenneth Chiori Eze Nn.. @Kennethchiori
203 Followers 353 Following Copywriter, content writer/Author.Tabitha Ndwaru @tabbyndwaru
8 Followers 531 FollowingNihir Basumatary @NihirplusIns
71 Followers 315 Following Analytics & Management | Data Analyst #DataScience #Analyticsrishabh sethi @rishabh_sethi1
12 Followers 838 FollowingDude Bro @GuytanoPython
90 Followers 254 FollowingJames Essiet @JamesEssiet
132 Followers 348 Following analyzing process @AirtelNigeria | @datacamp Certified | help African business make data-driven decisions one query at a time| @aiesec & @cowrywise ambassadorAlex Freberg @Alex_TheAnalyst
67K Followers 36 Following Alex The Analyst Official Twitter Account | YT Alex The Analyst | IG @Alex_The_Analyst | YouTube’s #1 Data Analyst Channel (don’t fact check that)Nick Singh | The Data.. @NickSinghTech
30K Followers 4K Following Author of Ace the Data Science Interview. Free Book Preview 👇 https://t.co/1izgOFy1Kt Founder of https://t.co/yyE4B5Ltpf (SQL Interview Prep) Ex-FacebookEzekiel @ezekiel_aleke
70K Followers 151 Following Data Analyst | Author | Tutor | Mentor | Best-selling Author of DATA ANALYSIS MADE EASY. Dm for Promotion/Collaboration. https://t.co/rMOX0NhISLBrittany City @brittanycity
12K Followers 1K Following hey! here you’ll gain skills to land your first tech role — data/AI + instructor + career mentor + content creatorPau Labarta Bajo @paulabartabajo_
45K Followers 222 Following The Real-World ML guy | Learn to build real-world ML apps at https://t.co/xWr8Hm8zI5Suman Dey @datawithsuman
33K Followers 94 Following Applied AI @jpmorgan Masters in Data Science @IITHyderabad Data Science Mentor @scaler_official Open to remote opportunities 📩 DM for CollaborationRaul Junco @RaulJuncoV
18K Followers 450 Following I simplify System Design, and System Design will make you a better Software Engineer. System Design • Databases • Algorithms • AI EnthusiastProbability and Stati.. @probnstat
34K Followers 332 Following Probability. Statistics. Machine Learning. Data Science.Machine Learning Comm.. @c4ml_
10K Followers 266 Following Follow for Actionable tips, Best Resources and Daily content on Python, Data Science & Machine Learning. 🚀Ann Melissa Campbell @anncampbelliowa
997 Followers 800 Following Professor @TippieAnalytics and Hanson Family Chair at .@UIowa. Opinions are mine. Interested in last mile delivery, disaster logistics, dogs, F1.onesandzeros @onesndzeros
174 Followers 349 Following Built https://t.co/MrKsuobvR3 Writing at https://t.co/h4HpOYk6zIharpreet @DataScienceHarp
7K Followers 1K Following 🤖 Generative AI Hacker | 👨🏽💻 AI Engineer | 👷🏽♀️ Developer Advocate | Building🏗️-Shipping🚢-Sharing🚀Gianni Cara @giannicara
21K Followers 88 Following Helping creatives uncover their unique message, communicate it effectively, and build a powerful brand.Daliana Liu @DalianaLiu
6K Followers 1K Following Host of 'The Data Scientist Show' | ex-Amazon senior data scientist | Nerdy joke connoisseur 📍SFData Science Renee @BecomingDataSci
66K Followers 10K Following Sr Director of DS at @HelioCampus || Author of SQL for Data Scientists (Wiley) || @DataSciGuide @NewDataSciJobs || @paix120 || Not views of employer || she/herRichard Railton @_rrailton_
172 Followers 3K Following Data Analyst - Environment, Healthcare & TechSmarterQueue ⚡ @SmarterQueue
18K Followers 1K Following The social media power tool. 💪 Boost engagement & save hours of time with our intuitive publishing, scheduling, curation & analytics features. Try it freeHypefury - Simple aud.. @hypefury
73K Followers 99 Following Simple social automation & content creation for entrepreneurs who dream big 🚀 Free Twitter growth tips in your 👉 📩 https://t.co/KWuQw0Dos8Edwinlovesdata @edWINtheanalyst
7 Followers 55 Following Data Analyst | Chartered Banker | SQL | Tableau | Excel Documenting my data journey. Aiming to be a well-known #dataanalyst from Africa🧘🏾♂️👨🏽💻. 📍🇬🇭Harsha @Harsh__116
79 Followers 330 Following Hey I am DataScience and ML enthusiastic and Loves Maths. I always Loves to spend my time with Friends/movies/seriesFozail khan @FozailKhan
176 Followers 542 Following Geologist | Researcher | Data analyst | Learning #Datascience, #Python & #DataAnalytics | #Machinelearning | #Artificialintelligence | #pakdatascienceAbdulwajeed @GAbdulwajeed
116 Followers 405 Following Data scientist | Learner | Computer Engineering studentANATICAL RAY @racmorenfood
298 Followers 943 Following I love the learning process||Human Resources professional||Analysts||A Thinker and Fixer||Chef Ray. I don't say doesn't mean i don't see. Receptive with limit.naz @alanznaz
409 Followers 2K Following Ex-data analyst | Software Engineer in Fintech |• be kind to everyone | fan of Boruto since 2017. | Aspire to be a computational physicist. 💻⚛️Bavona Cherry @bavo_sheba
375 Followers 593 Following Data & Tech Enthusiast | Sideline 👉| Foodie | Zen Mindset| Mental Health AdvocateSalim Imuzai @salimkarbm
165 Followers 542 Following A Back End Engineer Who believes that; for every complex problem there is an answer that is either clear, simple or wrong, I take pride in finding out.Adebayo Lamidi F @Ayofe_data
21 Followers 190 Following Solved business problems worth of millions of dollars with data. Business Analyst | On Chain Analyst | SQL | Tableau | WriterHalf-Moon God 🌙 @saddick_marcelo
1K Followers 1K Following Data enthusiast passionate about #DataAnalysis, #DataViz, and #Coding. Sharing insights and learning from the #DataScience community. #PowerBI #Tableau #ExcelWilyereny @wilyereny
25 Followers 95 Following Networking Engineer | Developer | SAP BPA/BTP IntegratorMr Folami A. A. ✨�.. @FolamiAbdulafe1
124 Followers 973 Following Tech 💝🖋 An open-minded seeker of knowledge. Wanna keep learning till my situation changes for good.📚📡Raghav Khanna @erRaghavKhanna
5K Followers 518 Following On journey of becoming Full Stack Developer @Deloitte • A Peaceful Hacker • Cloud • DevOps • Mentor • Post about - Engagement building, Dev Facts & Humor 🫡jm @xvjsmx
287 Followers 35 FollowingDipankar Mazumdar🥑 @Dipankartnt
1K Followers 528 Following Staff Data Engineering Advocate @OnehouseHQ, prev DevRel @Dremio, R&D @Qlik, Data @OtisElevatorCo | Author (O’Reilly) | Research: https://t.co/AiDKzVJCGaDiego Jotta @DiegoJotta1
48 Followers 833 FollowingVin Vashishta @v_vashishta
29K Followers 1K Following Author, Best Seller “From Data To Profit.” I wrote the playbook for enterprise data & AI monetization. AI advisor, speaker, & course instructor.From reviewing 50+ resumes while I worked at Facebook, the most common mistake I saw was: ❌ Stuffing a resume with irrelevant details ❌ 3 Examples of this Resume Mistake: 1. In the summary/objective, they’d talk about how passionate they were about Data Engineering (while…
Using both SQL and Excel on a dataset🤩 Write Queries to get what I want from the dataset, and move the table result to Excel to visualize it🤩 You can use PowerBi to visualize, your choice😘
@RaulJuncoV Yes sometimes. COALESCE is efficient and cleaner than multiple CASE statements.
@RaulJuncoV Both of these come in real handy in our reporting module which we have. Good explanation as usual Raul !!!
@RaulJuncoV We can also handle NULL values gracefully, for example in adding values in a column. For example - SELECT COALESCE(store1_revenue, 0) + COALESCE(store2_revenue, 0) + COALESCE(store3_revenue, 0) AS total_revenue FROM sales_data;
everything in data except SQL was a mistake
If you’re applying to 47 jobs, you may need 47 𝐝𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐭 resumes. Here’s why this strategy works, along with a trick for customizing resumes easily with AI: Firstly, understand this: the average recruiter spends 7.4 seconds reading your resume. Recruiters don’t have…
3 amazing platforms that have helped me immensely in my SQL journey!! Started ➡️ @DataLemurHQ Parallel it with➡️@StrataScratch When I was thorough with my concepts and I felt confident, I picked up @LeetCode.
Since we're apparently on a SQL roll with that last post, I also wanted to shout out @NickSinghTech's site @DataLemurHQ. Prepping for SQL skills is especially important for DS roles at small companies where you'll do a lot of your own data engineering 🔗 datalemur.com/questions
I've worked at Facebook, Google, & Microsoft. But in 2020 I left big-tech. A story about FAANG, fulfillment, and failure 🧵:
8 must-read books to land a Product Data Science or Product Analytics job: (along with a guided 12 week study plan) 🧵👇