MyVidster Tag results for sql

sql case statements for data science interviews - youtube
Bookmarked 270 weeks ago
let039s cover 3 types of sql case statements that show up on data science interviews and that you039d use daily as a data scientist i039ll cover 3 different use cases for sql case statements explain the nuances and what goes on behind the scenes when you execute your sql query all of this hopefully to make you better on your data science interviewsfollow along interactively by coding the solutions to the questions:- case statement for numerical values: http:bitly2wmnvad- case statement for text: http:bitly3p0ebop- the most popular case statement on sql interviews: http:bitly2itci9f______________________________________________________________________this series is for both beginner and intermediate data scientists and analysts interested in learning how to solve common data science interview questions in sql these are real data science interview questions for some background context and an intro about what this series is about: https:bitly36kkbxg subscribe to my cha

step-by-step approach to solving any data science sql interview question twitch
Bookmarked 258 weeks ago
here039s a step-by-step framework to solve any data science sql interview question we039ll cover a brand new data science interview question from twitch where i039ll walk you through the steps on how to solve the problem and communicate with the interviewer

top data science interview question and answer mistakes 2021 asked by amazon - youtube
Bookmarked 269 weeks ago
we039re going to cover the 1 most common mistake made on data science interviews this mistake is made by both inexperienced and experience data science profe

advanced data science sql interview question amazon window functions amp aliasing
Bookmarked 262 weeks ago

solving complex sql interview questions how to organize lengthy code solutions
Bookmarked 266 weeks ago
let039s talk about a framework to organize lengthy sql code on a data science interview or on the job most data science problems involve numerous business rules and deal with complicated logic your code might end up being hundreds of lines long how do we properly organize our solution i lay out a framework that can help anyonelink to question: https:bitly2jpvviq______________________________________________________________________this series is for both beginner and intermediate data scientists and analysts interested in learning how to solve common data science interview questions in sql these are real data science interview questions subscribe to my channel: https:bitly2gsfxma playlist for more data science interview questions and answers: https:bitly3jifw81 playlist for data science interview tips: https:bitly2g5hnoj practice more real data science interview questions: https:bitly2qhnnmh______________________________________________

how i learned data science resources to get a job in 2021
Bookmarked 265 weeks ago
let039s talk about how to learn data science or at least how i learned data science i039ll go over the topics i think are important like programming in sql and python understanding machine learning theory and produce management principles i039ll leave you with a few resources you all can explore to get better at data science and hopefully land a jobresources mentioned:leetcodecomstratascratchcomconfettiaibrilliantorgkagglecomtryexponentcommediumcomwikipediaorg subscribe to my channel: https:bitly2gsfxma ______________________________________________________________________contact:if you have any questions comments or feedback please leave them herefeel free to also email me at nathanstratascratchcom

common date manipulations on data science sql interviews
Bookmarked 263 weeks ago
date and datetime manipulations are really common and necessary to do data science work the skill and concepts are often tested on data science interviews extracting components from the date field like year day month is super common in analytics often times yoursquore given a date field and asked to calculate or count some metric over years or months let039s go over these concepts in this videolink to the question: http:bitly3jmkh7x______________________________________________________________________ subscribe to my channel: https:bitly2gsfxma playlist for more data science interview questions and answers: https:bitly3jifw81 playlist for data science interview tips: https:bitly2g5hnoj practice more real data science interview questions: https:bitly2qhnnmhabout the platform:i039m using stratascratch a platform that allows you to practice real data science interview questions there are over 1000 interview questions that cov

top data science interview questions in 2021 3 concepts tested on all interviews
Bookmarked 267 weeks ago
wersquore going to go over the most common data science interview question for 2021 in this video really itrsquos 3 of the most common concepts tested on all coding interviews wrapped in one question i see this question or version of this question on almost every interview irsquove been on or given follow along with me and see if you would be able to answer this questionlink to question: http:bitly2l2pf0wthis question is from microsoft but versions of this has been found at other tech companies like facebook google airbnb doordash and others the 3 concepts tested are sql joins case statements and subqueries common table expressions sql ctes______________________________________________________________________ subscribe to my channel: https:bitly2gsfxma playlist for more data science interview questions and answers: https:bitly3jifw81 practice more real data science interview questions: https:bitly2qhnnmh_______________________________________