Zac Anger's Blog

SQL/RDBMS

2016-01-28

Tags: db, rdbms, sql, sqlite


Queries

These will be in SQLite, specifically.

SELECT * FROM foo_bar
SELECT quux,baz FROM foo_bar
/* find this thing in that table */
SELECT * FROM what WHERE things = 'stuff'
/* WHERE is a simple conditional */

Joins

This is a big deal, so it gets its own subsection.

Aaaandd... my brain kinda hurts. That's enough of that. Here are a couple of resources for learning the basics of relational databases: * SQL Teaching * Stanford's Free Online Mini-Courses