Exam objectives in this chapter:
Create Database Objects
Create and alter views (simple statements).
Work with Data
Query data by using SELECT statements.
Microsoft SQL Server provides three different ways to present a logical view of a table to user queries without having to expose the physical base table directly. Views behave just like tables but can hide complex logic; inline functions can be used like views but also take parameters; and synonyms are a simple way to refer to database objects under a different name.
In this chapter, you learn to design, create, and modify objects that present data tables for your T-SQL code in indirect ways.
Lessons in this chapter ...