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 datatype(s)?
2.	How would you define a field that could only contain 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, 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.
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.