Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Querying Microsoft SQL Server 2014 (M20461)

Learn basic Transact- SQL queries for SQL Server 2012 and 2014.

Vendor# M20461

GK# 6552

Course Overview

In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server.

This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20461: Querying Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-461 and along with on-the-job experience, helps you prepare for the exam.

Note:

  • Redeem five SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
  • Redeem five SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC)
  • Redeem two SATVs for an individual GK Digital Learning course

*For more information on Microsoft SATVs, click here.

GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC). Click here to purchase.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $2995 CAD

    5 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $2995 CAD

    5 day

  • Virtual Classroom Fit

    Virtual Classroom Fit

    Attend live, online training sessions for a total of 24 hours spread over four weeks.

    From

    $2795 CAD

    5 day

  • GK Digital Learning

    GK Digital Learning

    Experience high-quality online learning combined with reliable expert guidance and skills development activities.

    From

    $1245 CAD

    90 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • SELECT query writing
  • Query multiple tables
  • Sort and filter data
  • Data types in SQL Server
  • Data modification using T-SQL
  • Built-in functions
  • Group and aggregate data
  • Set operators
  • Window functions: ranking, offset, and aggregate
  • Pivot and group sets
  • T-SQL programming
  • Error handling and transaction implementation

Follow-On Courses

Prerequisites

  • Working knowledge of relational databases
  • Basic knowledge of Microsoft Windows operation system and its core functionality

Who Needs To Attend

  • Database administrators
  • Database developers
  • Business intelligence professionals
  • SQL power-users such as:
    • Report writers
    • Business analysts
    • Client application developers

Related Certifications

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more