10774: Querying Microsoft SQL Server 2012 (Exam 70-461) Course - Koenig-Solutions
  • Email info@koenig-solutions.com
  • WhatsApp +91 81307 98752
  • Phone +1 877 226 2244

10774: Querying Microsoft SQL Server 2012

  • Overview

    This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Many of the exercises in this course are SQL Azure enabled and can be performed both locally or on SQL Azure.

    This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren't necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

    Course Objectives

    • Working with SQL Server Management Studio
    • Creating and Organizing T-SQL scripts 
    • Describe the use of predicate logic in SQL Server
    • Describe the logical order of operations in SELECT statements
    • Using Conversion Functions
    • Using Logical Functions 
    • Describe the role of indexes and statistics in SQL Server
    • Display and interpret basic query plans

    Course Content / Exam(s)

    Schedule for 10774: Querying Microsoft SQL Server 2012
    Course# Course Contents Exam# Exam Regular Track
    (days)
    10774 Querying Microsoft SQL Server 2012 Databases 70-461 Querying Microsoft SQL Server 2012 Databases 5
    Total 5
    Prerequisites

     

    Before attending this course, students must have:

    • Working knowledge of relational databases.
    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    Recommended Courses and Certification:
  • 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
    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
    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