Foundations of Querying Microsoft SQL Server 2012

Suggested Practices

To help you successfully master the exam objectives presented in this chapter, complete the following tasks.

Visit T-SQL Public Newsgroups and Review Code

To practice your knowledge of using T-SQL in a relational way, you should review code samples written by others.

• Practice 1 List as many examples as you can for aspects of T-SQL coding that are not relational.

• Practice 2 After creating the list in Practice 1, visit the Microsoft public forum for T-SQL at http://social.msdn.microsoft.com/Forums/en/transactsql/threads. Review code samples in the T-SQL threads. Try to identify cases where nonrelational elements are used; if you find such cases, identify what needs to be revised to make them relational.

Describe Logical Query Processing

To better understand logical query processing, we recommend that you complete the following tasks:

• Practice 1 Create a document with a numbered list of the phases involved with logical query processing in the correct order. Provide a brief paragraph summarizing what happens in each step.

• Practice 2 Create a graphical flow diagram representing the flow of the logical query processing phases by using a tool such as Microsoft Visio, Microsoft PowerPoint, or Microsoft Word.