Workshop
The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”
Quiz
| 1: | What does it mean to streamline a SQL statement? |
| 2: | Should tables and their corresponding indexes reside on the same disk? |
| 3: | Why is the arrangement of conditions in a SQL statement important? |
| 4: | What happens during a full-table scan? |
| 5: | How can you avoid a full-table scan? |
| 6: | What are some common hindrances of general performance? |
Exercises
| 1: | Make the following SQL statement more readable:
SELECT EMPLOYEE.LAST_NAME, EMPLOYEE.FIRST_NAME, EMPLOYEE.MIDDLE_NAME, ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
