Links:

• Codecademy Learn SQL
• Access SQL: basic concepts, vocabulary, and syntax

---

The SQL Playground initializes these variables for your use:

$tb = $('#Data table');	$tb is now a jQuery object that holds the table.
$tr = $('#Data table tr:has(td)');	$tr holds all table rows except the header row.
$td = $('#Data table td');	$td holds all table data elements.
$th = $('#Data table th');	$th holds all table header elements.

Note that you don't need to use document ready or its shorthand to work in the Playground.

---

I've extended jQuery's filter() method so that it accepts a regular expression, which will match against the text content of the elements.

Example:

$td.filter(/^[t-u].+county$/i)   .css('background', 'orange');

Select all table data that start with the letter t or u and end with the word county (case-insensitive), and give them an orange background. You cannot accomplish this using contains().

---

Codecademy has a good SQL course. But it's based on SQLite, which has a slightly different syntax from Access, which we use in-house.

---

In Unit 2: Queries | 11. Limit, you'll see:

SELECT * FROM movies ORDER BY imdb_rating DESC LIMIT 3;

Note that Access does not have the LIMIT verb. Instead, you would use TOP, like this:

SELECT TOP 3 FROM movies ORDER BY imdb_rating DESC;

---

In Unit 4: Multiple Tables | 4. Cross Join, you'll see:

SELECT * FROM albums JOIN artists ON albums.artist_id = artists.id;

This is how you create an INNER JOIN in SQLite.

In Access, you have to explicitly include the word INNER:

SELECT * FROM albums INNER JOIN artists ON albums.artist_id = artists.id;

This syntax also works in SQLite, so you might as well include the word INNER whenever you need an INNER JOIN.