Get the basics right.
Go deeper from there.
What interviews made me revisit.
Notes, worked examples, and problems to come back to.
Start with SQL. More subjects are on the way.
Choose a subject
SQLQueries, patterns, database design, and performance.Start learning DSAAlgorithms, data structures, and problem solving.PlannedData EngineeringPipelines, modeling, orchestration, and reliability.PlannedMachine LearningModels, evaluation, and production systems.PlannedAI EngineeringRetrieval, agents, evaluation, and inference.PlannedData Modeling and System DesignData models, architecture, and technical trade-offs.PlannedStart with a concept
Work through an example and see why the query gives that result.
Open the handbookPick a problem
Find a question on StrataScratch, LeetCode, or DataLemur and give it a shot.
Find a problemFigure out what's slow
Read the query plan, test a change, and check whether it helped.
Start investigating