Pick 1 & Get 1 Free + 10% additional off!

Special Offers for Students, Corporates & Government Employees - Get Details

Learn the theory and practice of the Transact-SQL language in detail.

20761A: Querying Data with Transact-SQL 2016 Training & Certification Course

Learn the theory and practice of the Transact-SQL language in detail.

     108 Learners       Add to wishlist

Play Video

Instructor-Led Online Training

  • 24 Hrs. Training
  • Certified & Experienced Trainer
  • Training Session Videos
  • Training Certificate
  • Learning Material
$ 250
ENROLL NOW
Training Schedule
Start Date End Date No. of Hrs Time (IST) Day  
15 Dec 2018 06 Jan 2019 24 06:00 PM - 09:00 PM Sat, Sun
22 Dec 2018 13 Jan 2019 24 06:00 PM - 09:00 PM Sat, Sun
29 Dec 2018 20 Jan 2019 24 06:00 PM - 09:00 PM Sat, Sun

Schedule does not suit you, contact us now!    |    Want to take one-on-one training, contact us now!

Course Overview

The 20761A Querying Data with Transact-SQL 2016 Training & Certification course introduces students to the fundamentals and practices of the Transact-SQL language in detail. Transact-SQL is nowadays used by all Server-related disciplines namely, Database Administration, Database Development and Business Intelligence. The candidates will learn in this course the correct methods of selecting, sorting, and filtering data from different tables, among many other things.

Some of the major learnings of the candidates at the completion of this training and certification course can be listed as follows:

  • Ability to describe the key capabilities and components of SQL Server
  • Complete understanding of T-SQL, sets, and predicate logic
  • Ability to write a single table and multi-table SELECT statement
  • Ability to write DML statements
  • Ability to write subqueries
  • Knowledge of implementing views and table-valued functions
  • Knowledge of creating and implementing stored procedures
  • Know-how of adding programming constructs such as variables, conditions, and loops to T-SQL code

Course Contents

Course ContentDetailed Course Topics
  • Module 1: Introduction to Microsoft SQL Server 2016
  • Module 2: Introduction to T‐SQL Querying
  • Module 3: Writing SELECT Queries
  • Module 4: Querying Multiple Tables
  • Module 5: Sorting and Filtering Data
  • Module 6: Working with SQL Server 2016 Data Types
  • Module 7: Using DML to Modify Data
  • Module 8: Using Built‐In Functions
  • Module 9: Grouping and Aggregating Data
  • Module 10: Using Subqueries
  • Module 11: Using Set Operators

Target Audience

  • Database Administrators
  • Database Developers
  • Business Intelligence Professionals
  • Business Analysts

Certification

After completing the 20761A Querying Data with Transact-SQL 2016 Training & Certification course, the candidates will receive a training completion certificate from Multisoft Virtual Academy.

Send us a Query

Capcha

I agree to be contacted via e-mail.

Related Courses

Combo Offers

20761A: Querying Data with Transact-SQL 2016 Training & Certification Course
Rated 5/5 based on 108 votes 108 reviews

Get in Touch

Follow Us

We Accept Online Payments

Online Registration

Subscribe to our Newsletter

Find us on

Online Registration

Contact Us

Capcha

I agree to be contacted via e-mail.

Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP and SP are registered marks of the Project Management Institute, Inc.
  • PRINCE2® is a registered trade mark of AXELOS Limited
  • ITIL® is a registered trade mark of AXELOS Limited
  • MSP® is a registered trade mark of AXELOS Limited
  • The Swirl logoTM is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.