ISM641 American University SQL Query and Sampdb Database Assignment

  1. Using phpMyAdmin, connect to the sampdb database and create three queries including an inner join, outer join and subquery. Include screenshots of SQL query and its results.
  2. Using the information schema in phpMyAdmin, write a query to return the table name, table rows, average row length, index length and auto increment value contained in the sampdb database schema. Include screenshots of SQL query and its results.
  3. Create a tutorial on how to use the query optimizer with these queries. Include screenshots and an explanation on why and when to use the optimizer.

"Is this question part of your assignment? We can help"

ORDER NOW