Workshop

The Workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.

Quiz

1:	The integer 56678685 could be which data type(s)?
A1:	`MEDIUMINT`, `INT`, or `BIGINT`.
2:	How would you define a field that could only contain the following strings: apple, pear, banana, cherry?
A2:	`ENUM ('apple', 'pear', 'banana', 'cherry') or SET ('apple', 'pear', 'banana', 'cherry')`
3:	What would be the `LIMIT` clauses for selecting the first 25 records of a table? Then the next 25?
A3:	`LIMIT 0, 25` and `LIMIT 26, 25`
4:	How would you formulate a string comparison using `LIKE` to match first names of "John" or "Joseph"?
A4:	`LIKE 'Jo%'`
5:	How would you explicitly refer to a field called `id` in a table called `table1`?
A5:	Use `table1.id` instead of `id` in your query.
6:	Write an SQL statement that joins two tables, orders, and `items_ordered`, with a primary key in each of `order_id`. From the orders table, select the following fields: `order_name` and `order_date`. From the `items_ordered` table, select the `item_description` field.
A6:	SELECT orders.order_name, orders.order_date, items_ordered.item_description FROM orders LEFT JOIN items_ordered ON orders.order_id = items_ordered.id.