Logo

Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863

NewMS-20761MOD

Querying Data with Transact-SQL: On-Demand

Description

The Microsoft on-demand product is an integrated on-line training experience that includes video, labs, exercises, text and knowledge checks. Attendees experience all of this through an on-demand course player.

What`s included?

  • Access to the official Microsoft Video on Demand Course for 90 days from the point of first access, allowing you to start and stop when you need to.
  • Lab access for 3 months from start of access.
  • MCT Support via our Microsoft Training Support Yammer Group (you will be invited to the group after registration)

The content is based on the same official courseware we use in our instructor-led training, and videos feature engaging experts hand-selected by Microsoft. Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives you a live, real-time environment for hands-on training.

The On-Demand eLearning Product can also be purchased using 2 SA Vouchers.

Outline

The main purpose of this 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.
The course will very likely be well attended by SQL power users who aren`t necessarily database-focused; 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 2016.
  • 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

PreRequisites

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Audience

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; namely, report writers, business analysts and client application developers.
$600.00 List Price


Software Assurance
MAX Educ. Savings
Categories: , Tag:
Loading ...