Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


Microsoft SQL Server 2012 Transact-SQL offers advanced query techniques, such as built-in aggregate, analytic, scalar, and ranking functions, as well as common table expressions, or CTEs and derived tables to manipulate the result set for a query. To manipulate the result sets and generate summarization information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. The UNION, INTERSECT, and EXCEPT operators can be used to combined the result set of multiple queries. SQL Server 2012 also offers the use of CTEs and derived tables to obtain a result set, temporarily store it, and then pass it to a query to return another result set based on that information. This course demonstrates how to perform advanced query techniques to manipulate data using the SQL Server 2012 built-in functions, operators, and table expressions. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Learning Objectives
  • Describe the features of functions in SQL Server 2012
  • Use built in functions in SQL Server 2012
  • Determine the kind of scalar function required in a given scenario
  • Manipulate data using built-in functions
  • Manage results sets
  • Return a single value by evaluating conditions
  • Describe the considerations involved in creating summary reports
  • Change a table-valued expression using the PIVOT and UNPIVOT operators in a given scenario
  • Use the results returned from a subquery in an outer query
  • Use operators and table expressions to work with data in given scenarios
  • Determine which expression should be used in a given scenario
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.