Home > Store > Operating Systems, Server > Microsoft Servers

Module 2: Work With Data, Downloadable Version

Module 2: Work With Data, Downloadable Version

Downloadable Video

  • Your Price: $59.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2015
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-399549-6
  • ISBN-13: 978-0-13-399549-7

Module 2: Work With Data

In this module, you will learn how to work with data. We start first with querying data using the SELECT statement moving from simple queries to complex joins. We will then see how to implement subqueries and data types. Finally, we will see how to implement aggregate queries and manage XML data.

Lesson 5: Query Data by Using SELECT Statements

In this lesson, you will learn how to create efficient queries that filter data using predicates. We will examine methods to control query results, as well as write complex queries using multiple tables. Finally, we will implement statements that load and create tables.

Lesson 6: Implement Subqueries

In this lesson, you will learn how to create and implement subqueries to manage complex statements. We will examine both derived tables and common table expressions (CTEs). Finally, we will implement PIVOT and UNPIVOT operators in queries.

Lesson 7: Implement Data Types

In this lesson, you will learn the uses and limitations of data types. We will implement data types for columns, keys, numbers, and data and time. We will then work with string and other data types.

Lesson 8: Implement Aggregate Queries

In this lesson, you will learn how to group data in queries by implementing single and multiple grouping sets. We will also see how to apply window aggregate, ranking, and offset functions in queries.

Lesson 9: Query and Manage XML Data

In this lesson, you will learn how to return results as XML. We will see how to query XML data using XQUERY. Finally, we will examine best practices in using the XML data type.

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership