20461: Querying Microsoft SQL Server 2014 Databases

  • Overview

    This module will teach students how to write necessary Transact-SQL queries for MS SQL Server 2014. This module is planned for Database Developers, Database Administrators, and Business Intelligence professionals. After completing this module, students will be able to: explain the basic architecture and concepts of MS SQL Server and comprehend the differences and similarities between Transact-SQL and other computer languages.

    Course Objectives

    • Using Books Online
    • Understanding Predicate Logic
    • Understanding the Logical Order of Operations in SELECT statements
    • Executing queries which sort data using ORDER BY
    • Using Column and Table Aliases
    • Querying with Cross Joins and Self Joins
    • Working with Unknown and Missing Values
    • Writing Queries That Use Character Functions
    • Using Inline Table-Valued Functions
    • Exploring Window Functions
    • Writing Queries with UNPIVOT and PIVOT

    Course Content / Exam(s)

    Schedule for 20461: Querying Microsoft SQL Server 2014 Databases
    Course # Course Contents Exam #

    Regular Track
    (days)

    20461D Querying Microsoft SQL Server 2014 Databases 70-461 5
    Total 5
    Prerequisites
    • Knowledge of relational databases.
    • Knowledge of the MS Windows operating system and its core functionality.
    Recommended Courses and Certification:
  • Students Reviews
    Hassan  Alawi Koenig IT Training Student

    My name is Hassan and I'm from Copenhagen in Denmark. I have no IT education on paper since I'm self-taught into IT. So I decided it is time to be certified, to get my knowledge on paper. I found...

    Read MoreHassan AlawiDenmark
    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


    5
    5
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields