Expose students to SQLite and SQL SELECT syntax, as well as to the structure of relational databases.
Materials:
- Describe relational databases
- Connect to a SQLite database and get schema information
- Use SQL SELECT and
pd.read_sql()
to query databases - Use WHERE, ORDER BY and LIMIT to modify queries
Netflix has a great article describing three different data roles at their company, their different needs, and their toolsets.