Master SQL For Data Analysis with 120 free flashcards. Study using spaced repetition and focus mode for effective learning in Data Science.
Sample card
What does SQL stand for?
Structured Query Language
Q · 1 of 120
What does SQL stand for?
Q · 2 of 120
What is the purpose of the SELECT statement in SQL?
Q · 3 of 120
Which clause in a SELECT statement filters rows before grouping?
Structured Query Language
To query and retrieve data from one or more tables
WHERE
HAVING
WHERE filters individual rows before GROUP BY; HAVING filters aggregated groups after GROUP BY
Returns only unique values, removing duplicate rows from the result set
Ascending (ASC)
ORDER BY column_name DESC
The 10 rows starting at position 21 (rows 21-30)
LIMIT sets the maximum rows returned; OFFSET specifies how many rows to skip before starting to return rows
3 (MySQL performs implicit type conversion from string to number)
A special marker representing the absence of any value; it is not zero and not an empty string
Flashcards
Flip to reveal
Focus Mode
Spaced repetition
Multiple Choice
Test your knowledge
Type Answer
Active recall
Learn Mode
Multi-round mastery
Match Game
Memory challenge