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 2. Getting Started with the SELECT Statement

Exam objectives in this chapter:

  • Work with Data

    • Query data by using SELECT statements.

    • Implement data types.

  • Modify Data

    • Work with functions.

The previous chapter provided you with the foundations to T-SQL. This chapter starts by covering two of the principal query clauses—FROM and SELECT. It then continues by covering the data types supported by Microsoft SQL Server and the considerations in choosing the appropriate data types for your columns. This chapter also covers the use of built-in scalar functions, the CASE expression, and variations like ISNULL and COALESCE.

Lessons in this chapter:

Before You ...

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