MOC On-Demand: Querying Data with Transact-SQL

MOC On-Demand 

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Querying Data with Transact-SQL

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, Data-base Administration, Data-base Development and Business Intelligence.

As such, the primary target audience for this course is: Data-base Administrators, Data-base Developers and BI professionals.

At Course Completion:

At the completion of this course participants will be able to:

  • describe key capabilities and components of SQL Server
  • 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.
  • Additional Resources:

    Instructor-led Training: 20761 Querying Data with Transact-SQL 2016

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: OD20761
  • Duration: 90 Days
  • Price: $1,089.00

Next Step

Enquire Now
Tell a Friend