Schema:: Student_id, depart_id, coach_id, date Find AVERAGE number of students per department in March 2021 Is window function needed here?? I know a group by depart_id is used and i can count number of students by using count (*) but how do I calculate average? Edit: one student could belong t...Read more
Quick question about Sql assessment during interview. In the environment where you code your query, are you able to see the results of your query when you run it? #data #aws #amazon #datascience #dataanalytics
Feeling really down… I have worked years in analytics and use SQL everyday. I just did a phone screen with SQL question, it felt hard when I did it but my nerves got the better of me and I wasn’t able to do it (I was on the right track). I thought about the question after the interview and realized...Read more
As the title suggests, I know SQL and have been working with SQL for 7 years now. My current work is in data science using Python but I’m really still learning it. I’m looking for roles in FAANG which help me use SQL and also learn data science. So something like an analyst role. What roles should I...Read more
My team only uses SQL for everything: analysis, pipelines, ML. Is this a bad job due to not using more advanced things (Python, Spark, Hadoop, Java) or is this an industry norm?
Can anyone shed some light on the the types of SQL questions presented during the SQL phone screen and ‘on-site’ technical interview for Amazon BA roles? I’ve been using SQL for years but I don’t have experience with these types of interviews. Any resources or references are welcomed. Edit: Passe...Read more
In my little bastion of Amazon, SQL is regarded as slow and unscalable. Every time I suggest it for a solution with what appears to be highly relational data, I'm immediately shot down with, "eww" or "that won't scale". Last I checked, plenty of behemoth corporations were using SQL for all manner of...Read more
In my SQL round of data science interview, I could arrive at the final answers for all the questions but the interviewer helped me and gave me a lot of hints while coding. I also misinterpreted one of the questions and starting coding. The interviewer corrected my interpretation and I re coded the c...Read more
I have solved all Leetcode SQL questions. Need to practice some hard ones for my DS interview at FB. Any pointers or examples? My phone interview feedback was "weak in programming" but they gave me second round because of good product thinking and because I used a pseudo code to give enough hints th...Read more
What is the fastest way to learn SQL? Intermediate level. How and any online resources?
This is a classic question which arises in system design interviews and also practical distributed systems. Should I use sql or no sql for a particualr database. Looking at enginering blogs of tech companies like youtube they use a hybrid sql and nosql solutions. Can anyone give me a link or reaso...Read more
How many years did it take for people to be comfortable with intermediate/advanced SQL for work projects? I took a course in SQL but that wasn’t enough to cover most of what I needed to know for a real world project SQL seems to have a steep learning curve.
humans were not meant to query tabular data like this It is language designed by tie wearers and bald ppl Use Javascript to query your databases It is what the cool kids use Otherwise don’t sit at our table
Does anybody have any pointers on how to best prepare for an SQL interview for an Amazon Business Intelligence Engineer L6 role? I know its going to be only SQL, and maybe some Data Viz (Not sure how that is tested?) It has been a while since I have been through a technical assessment, So If you ca...Read more
SELECT * FROM blind_schema WHERE employer LIKE '%kpmg%' AND (industry = 'Management_Consulting' OR industry = 'tech' OR industry = 'software_engineering');
I have a sql interview lined up with Uber. Can anyone share their experience about Uber sql interview ? What kind of questions can I expect ? I am interviewing for non tech role which requires sql.
What level of SQL is expected in Amazon SQL interview for BIE ? LC - easy/med/hard ?#tech #career TC - 125k YOE - 4
Is there a particular certification you would recommend for SQL that is well recognized industry wide? I'm using w3schools and leetcode to train myself but no certification. #dataanalytics #businessanalyst