20761B - MOC On-Demand Querying Data with Transact - SQL

$484.00

MOC On-Demand Packaged Set 20761B: Querying Data with Transact-SQL (90 Day)
The MOC On-Demand Packaged Set: Querying Data with Transact-SQL contains the following items:
  • MOC On-Demand Course OD20761B (includes Microsoft Labs Online)
  • Digital MOC Course 20761B
The MOC On-Demand Packaged Set 20761B: Querying Data with Transact-SQL 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 is designed to introduce students to Transact-SQL. It is designed for both students requiring the knowledge for other courses in the SQL Server curriculum, and for students preparing for the skills required to take exam 70-761.
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.
Querying Data with Transact-SQL (20761B course) (90 Day)

About this Course
This course is designed to introduce students to Transact-SQL. It is designed for both students requiring the knowledge for other courses in the SQL Server curriculum, and for students preparing for the skills required to take exam 70-761.

Audience Profile
The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by 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.

At Course Completion
After completing this course, students will be able to:
  • Describe key capabilities and components of SQL Server 2016.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

Details for Microsoft Labs Online for this course: Querying Data with Transact-SQL
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:
Browser:
  • current version of Internet Explorer, Microsoft Edge, Google Chrome™ or Firefox®
Internet access:
  • broadband Internet connection (recommended: network bandwidth of over 4Mbps)
Screen resolution:
  • 1280 x 1024 or higher