How to learn SQL for data science interview (the minimize effort maximize outcome way)

This is a step by step guide for how I learned SQL for my FANG data science interview. I had never touched SQL before and only had 2 weeks to prepare for my interview. So I made a scientifically-backed study plan to learn SQL most efficiently with the least amount of time and effort. By the end of the 11 days, I felt super confident and prepared. I went on to pass my FANG data science interviews and got the job!

My motto: Minimize effort and maximize outcome!!

Btw apologies about audio quality from about 2 – 3.5 min mark. Something weird happened to my mic 🙁
______________________________________________________________________
Timestamps:
00:00 Overview
01:01 Study Plan
06:00 SQL Interview Demo
08:47 End of Demo
09:36 Final Thoughts
______________________________________________________________________
Contact:
email: hellotinah@gmail.com
linkedin: https://www.linkedin.com/in/tinaw-h/
______________________________________________________________________
Music Credit:
Potato Deal – Craig MacArthur
Smile – Slynk
______________________________________________________________________
relevant topics: mysql, postgresql, postgresql tutorial ,postgresql tutorial for beginners

source by Tina Huang

sql

Mourad ELGORMA

Fondateur de summarynetworks, passionné des nouvelles technologies et des métiers de Réseautique , Master en réseaux et système de télécommunications. ,j’ai affaire à Pascal, Delphi, Java, MATLAB, php …Connaissance du protocole TCP / IP, des applications Ethernet, des WLAN …Planification, installation et dépannage de problèmes de réseau informatique……Installez, configurez et dépannez les périphériques Cisco IOS. Surveillez les performances du réseau et isolez les défaillances du réseau. VLANs, protocoles de routage (RIPv2, EIGRP, OSPF.)…..Manipuler des systèmes embarqués (matériel et logiciel ex: Beaglebone Black)…Linux (Ubuntu, kali, serveur Mandriva Fedora, …). Microsoft (Windows, Windows Server 2003). ……Paquet tracer, GNS3, VMware Workstation, Virtual Box, Filezilla (client / serveur), EasyPhp, serveur Wamp,Le système de gestion WORDPRESS………Installation des caméras de surveillance ( technologie hikvision DVR………..). ,

23 réflexions sur “How to learn SQL for data science interview (the minimize effort maximize outcome way)

  • juin 15, 2021 à 2:14
    Permalien

    Hi Tina! Thank you very much for this comprehensive guide to learning SQL that I am currently following. I did not know about Mode website before watching your video and I have been going through the content, it is amazing! I was wondering if you knew a similar kind of resource for Statistics and Probability content that would be useful, to learn what's expected to know for a Data Science Interview ? I really value your opinion and would love to hear your recommendations. Thank you very much! Keep up the good work! 💪💪

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    I know it is an old video but I will give it a shot. I have to learn it and learn it quick. It will be interesting.

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    Hi! Would this also work?

    SELECT COUNT(CASE WHEN flag = 'on' ELSE NULL END AND CASE WHEN event_timestamp =now() ELSE NULL END) AS count_currently_on
    FROM TABLE

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    Hello Tina, I found out about your channel just yesterday and I absolutely love your videos. They are very informative, motivating and filmed in a great atmosphere/attitude. Please continue in what you are doing! 🙂

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    Hi Tina, your video is helpful to me. Thanks. I would like to get your some advice how to become a data scientist with a bio-statistician background using SAS/SQL and R language on daily job. I had a master of statistics and work as bio-statistician now. I would like to see whether I could get close to a DS role in future.

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    sTarted learning python in January…got burnt out arnd March and had covered some abt 50% of beginner topics….thinking of resuming ..tell me do l have to master everything and go through all those topics like classes and dictionaries before l can begin a project,…yooh its an uphill journey l tell you…

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    Hi, great video! Already subscribed! Could you give me some advice on alternative resources to practice SQL or Python skills?

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    I haven't started sql yet..I guess found the right content at the right time!!
    ^_^ thank you soo much!! <3

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    I have a Credit Analyst interview on 10th May and it relies heavily on SQL and Excel, i'm certainly using your technique.

    Répondre
  • juin 15, 2021 à 2:14
    Permalien

    Hi friends! I really hope you find this video helpful 😀 Let me know what you think about my SQL prep strategy!

    Répondre

Laisser un commentaire