20761 : Querying Data with Transact-SQL ( SQL 2016)

  • Overview

    The SQL 2016 Querying course 20761 aims to impart skills on writing queries for Transact-SQL language. This SQL 2016 Querying certification training is the basic foundation for SQL Server-related disciplines such as Database Administration, Business Intelligence and Database Development. The course teaches participants how to select, sort and filter data from multiple tables and how to use stored procedures and views.

    Primary audience for this T-SQL training is database administrators, business intelligence professionals, database developers etc. This T-SQL certification course can also be attended by non-technical power users such as business analysts, report writers, and client application developers.

    Course Objectives

    • Understand the fundamental concepts and underlying architecture of SQL Server 2016
    • Discover the differences and similarities between Transact-SQL and other languages
    • Write, sort, filter, and modify data using Transact-SQL
    • Query multiple tables, use sub-queries and execute stored procedures
    • Learn to use table expressions, window ranking, set operators, offset and aggregate functions
    • Implement group sets, pivoting and error handling

    Course Content / Exam(s)

    Schedule for 20761 : Querying Data with Transact-SQL ( SQL 2016)
    Course # Course Contents Regular Track
    (days)
    Fast Track
    (days)
    20761 Querying Data with Transact-SQL 5 3
    Total 5 3
    Prerequisites
    • Basic knowledge of relational databases.
  • Students Reviews
    Jose Biniecki Mariusz Koenig IT Training Student

    During my stay, I did 2 fast track courses, MCSA: Windows Server 2012 R2 and MCSA SQL Server 2012 at Koenig Goa, India. I spent my time pretty nicely. I achieved MCSA certificates and met with new...

    Read MoreJose Biniecki MariuszPoland
    Juvencio  Manhique Koenig IT Training Student

    The experience I had with Koenig Solutions in Dubai was very good and rewarding, since the beginning till the very end. Instructor was able to guide his students very well, through his knowledge of...

    Read MoreJuvencio ManhiqueUnited Arab Emirates
    Clotilde Mundlovo  Soiane Koenig IT Training Student

    It was a great pleasure to have attended MCSA SQL Server 2012 course in Koenig Dubai. The training exceeded my expectations, taking into account the environment and ambience which were quite...

    Read MoreClotilde Mundlovo SoianeUnited Arab Emirates
    Daniel  Thompson Koenig IT Training Student

    This was my second trip to train with Koenig in India. My first time was in Dehradun, northern India and the experience is a life changing one. This time I decided to choose Goa and one of the forces...

    Read MoreDaniel ThompsonUnited Kingdom
    Bert  Ham Koenig IT Training Student

    I would like to thank you and your team for a very good course, I am very pleased with the results (MCSA 2012 graduation) and the acquired knowledge. The MCSA training was very good and the trainer...

    Read MoreBert HamNetherlands
    View All Testimonials
  • Schedule & Prices
    1
    2
    3


    4
     

    5
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields