Workshop

The Workshop provides quiz questions to help you solidify your understanding of the material covered and exercises to provide you with experience in using what you've learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, "Answers to Quizzes and Exercises," and make sure you understand the answers before continuing to the next lesson.

Quiz

1:How can I tell whether the words I type into the Query Analyzer editor are keywords?
2:Identify the column and table names in the following SELECT statement:
select OrderID,
        CustomerID,
        OrderDate,
        ShipName,
        ShippedDate
From Orders

3:The following query does not work. Why?
Select * Employees

Exercise

1:Using the Employees table from earlier today, write a query to return just the EmployeeID and title for each employee.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset