O'Reilly logo

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Designing and Creating Views, Inline Functions, and Synonyms

Exam objectives in this chapter:

  • Create Database Objects

    • Create and alter views (simple statements).

    • Design views.

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required