Chapter 8 of the textbook covers a variety of techniques that help optimize your use of SQL. Some of the techniques are available in different ways in tools such as MySQL Workbench.
Assignments – Due May 23, 2011 at midnight
- Read and follow assignments in Chapter 8.
- Final Project 5: A SQL Web Dashboard. Create a PHP webpage that displays two data charts using SQL and JQuery GVChart:
- a bar chart of total sales by vintage year.
- a pie chart of total sales by salesperson.
- Final Exam