SQL Basics (SELECT, JOIN, GROUP BY)

Summary

The query language for relational databases — most real-world training data lives in SQL databases, so you need to pull it out yourself.

• 1Practice SELECT, WHERE, JOIN, GROUP BY and ORDER BY on a sample database (e.g. SQLite).
• 2Write queries that answer specific analytical questions, not just syntax drills.
• 3Learn to read a query execution plan at a basic level.