Workshop

The workshop is designed to help you anticipate possible questions, review what you've learned, and begin putting your knowledge into practice.

Quiz

1.	The integer 56678685 could be which data type(s)?
2.	How would you define a field that could contain only the following strings: apple, pear, banana, cherry?
3.	What would be the LIMIT clauses for selecting the first 25 records of a table? Then the next 25?
4.	How would you formulate a string comparison using LIKE to match first names of "John" or "Joseph"?
5.	How would you explicitly refer to a field called id in a table called table1?
6.	Write a SQL statement that joins two tables, orders and items_ordered, each of which has a primary key 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.
7.	Write a SQL query to find the starting position of a substring "grape" in a string "applepearbananagrape".
8.	Write a query that selects the last five characters from the string "applepearbananagrape".

Answers

1.	MEDIUMINT, INT, or BIGINT.
2.	ENUM ('apple', 'pear', 'banana', 'cherry') or SET ('apple', 'pear', 'banana', 'cherry')
3.	LIMIT 0, 25 and LIMIT 25, 25
4.	LIKE 'Jo%'
5.	Use table1.id instead of id in your query.
6.	SELECT orders.order_name, orders.order_date, items_ordered.item_description FROM orders LEFT JOIN items_ordered ON orders.order_id = items_ordered.id;
7.	SELECT LOCATE('grape', 'applepearbananagrape');
8.	SELECT RIGHT("applepearbananagrape", 5);

Activity

Take the time to create some sample tables and practice using basic INSERT and SELECT commands.