Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



On Demand Labs: LO20461 Querying Microsoft SQL Server 2014


Introduction

Support your in-class learning with 3 months access to the lab environments used throughout the course.

These self paced labs for the training course 20461 Querying Microsoft SQL Server 2014 provides access to the lab virtual machines for all labs in the course and will be used for every lab. Scenarios, task steps, and extra information are provided by your courseware and lab answer keys.

Outcomes

After completing this course, students will gain the skills to:

  • Writing Basic SELECT Statements
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2014 Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Programming with T-SQL

Bundle offers available with instructor led courses

Instructor Led Training: 20461 Querying Microsoft SQL Server 2014

On-Demand Labs are not stand alone and cannot be sold without an applicable course




User Reviews

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

Course Info

  • Code: ODL20461
  • Duration: 90 Days
  • Price: $242.00

Next Step

Enquire Now
Tell a Friend