TOUGH TONGUE AI
  • Home
    LogoTOUGH TONGUE AI

    RESOURCES

    Loading...

    HomeLibraryDS Coach · SQL Basics

    DS Coach · SQL Basics

    DS Coach · SQL Basics

    Overview

    Write real SQL in about twenty minutes. Coach Maya puts a small store's customers and orders tables on her live board with one example per concept; you write the next query in the board's editor, tap Run, and watch your rows line up with the right ones. You will filter, combine conditions, match patterns, handle NULLs, sort, page with LIMIT and OFFSET, and use IN and BETWEEN, plus five quick checks on the traps interviewers love: AND/OR precedence, the underscore wildcard, "= NULL", LIMIT without ORDER BY, and NOT IN with NULLs.

    Your Instructions

    Your goal: write correct basic SQL quickly and spot the small traps that silently change an answer in an interview.

    How it works (about 20 minutes)

    • Maya's live board shows the tables and an example query for each step.
    • You type your own query in the board's editor, then tap Run.
    • Maya checks it; the board marks your rows right, missing or extra.
    • A few quick checks cover the classic traps: tap your answer.

    What you will practice

    1. SELECT, aliases and WHERE
    2. AND, OR, NOT and parentheses
    3. LIKE with % and _
    4. NULL: IS NULL and "not equal" filters
    5. ORDER BY with LIMIT and OFFSET
    6. IN and BETWEEN
    7. One interview-style query that combines them

    Tips

    • SQL is Postgres-style. MySQL or SQL Server habits are fine; Maya will mention the difference.
    • Style does not matter. Returning the right rows does.
    • Say "hint", "repeat", "skip" or "next" any time.
    • Read the SQL Basics notes first if you have not.

    More in Data Science Interview Prep: AI Coach Edition

    • Interactive Python 101 for Data Science
    • DS Coach · pandas Data Manipulation
    • DS Mock · Python Data Manipulation
    • Tech Interview: Lowest Earning Employees
    • DS Coach · Python for Probability & Simulation
    • DS Mock · Python for Probability & Statistics
    • Interactive SQL Tutor
    • DS Coach · SQL Aggregations
    • DS Coach · SQL Joins
    • Interactive SQL Tutor - Medium Level
    • DS Coach · SQL Window Functions
    • Interactive SQL Tutor - Advanced Level
    View the full course (49 sessions) →