20461D - MOC On-Demand Querying Microsoft SQL Server 2014

$484.00

MOC On-Demand Packaged Set 20461D: Querying Microsoft SQL Server® 2014 (90 Day)
The MOC On-Demand Packaged Set: Querying Microsoft SQL Server® 2014 contains the following items:
  • MOC On-Demand Course OD20461D (includes Microsoft Labs Online)
  • Digital MOC Course 20461D

The MOC On-Demand Packaged Set 20461D: Querying Microsoft SQL Server® 2014 is good for one student access for MOC On-Demand and its associated digital MOC.

Note: The Packaged Set assets, MOC On-Demand and its associated digital MOC, may only be provided to a single student; Packaged Set assets cannot be distributed to multiple individuals.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Microsoft Labs Online is a secure, cost-effective, compliant, and convenient way to deliver Microsoft Official Courseware hands-on labs. This internet-based lab hosting service provides 3 months of online access to the labs for this MOC On-Demand Course via a browser.
Details for Querying Microsoft SQL Server® 2014 (20461D course) (90 Day)

About this Course
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


Audience Profile
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

At Course Completion
After completing this course, students will be able to:
  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries.
  • Query multiple tables.
  • Sort and filter data.
  • Describe the use of data types in SQL Server.
  • Modify data using Transact-SQL.
  • Use built-in functions.
  • Group and aggregate data.
  • Use subqueries.
  • Use table expressions.
  • Use set operators.
  • Use window ranking, offset and aggregate functions.
  • Implement pivoting and grouping sets.
  • Execute stored procedures.
  • Program with T-SQL.
  • Implement error handling.
  • Implement transactions.

Details for Microsoft Labs Online for this course: Querying Microsoft SQL Server® 2014
Microsoft Labs Online is a secure, cost-effective, compliant, and convenient way to deliver Microsoft Official Courseware hands-on labs. This internet-based lab hosting service provides online access to the labs for this MOC On-Demand Course via a browser.
Microsoft Labs Online is integrated within the MOC On-Demand Course and there are step-by-step instructions provided on how to access and perform the labs. The student will have 24x7 access to the labs for the duration of course access.

Minimum requirements for Microsoft Labs Online include:

System Requirements:
  • Windows XP SP3 or later
    Note: The Chrome browser must be used with Windows XP and Windows Vista.
  • 32-bit Microsoft Internet Explorer 10.0 or later
  • TCP Port 80 open with inbound/outbound access to the Internet
  • 256 KBps per user network bandwidth
  • Ideal screen resolutions above 1280 x 1024
In addition, the labs may be accessed from other browsers and operating systems, including:
  • Chrome
  • Safari