PDP Url

Querying Data with Microsoft Transact-SQL (MS-20761)

This course takes a shot at two levels. The initial three days the understudies will be instructed about the Transact SQL and the process that will be useful for understudies who need to get other SQL courses too.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

SubscribeBuy Individually
empty table
tab
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1187 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
Learners Have Enrolled For This Course

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

This course takes a shot at two levels. The initial three days the understudies will be instructed about the Transact SQL and the process that will be useful for understudies who need to get other SQL courses too.

Course Information

About the course:

This course takes a shot at two levels. The initial three days the understudies will be instructed about the Transact SQL and the process that will be useful for understudies who need to get other SQL courses too. The other two days will be focused on setting you up for the Microsoft 70-761: the certification exam of Querying Data with Transact-SQL.

A Database Administrator gains up to $71, 429 every year.

Course Objective:

  • Having the option to distinguish the main parts of the SQL server
  • Describe key components and capabilities of SQL Server.
  • Having the ability to make a solitary table or multi-table SELECT statement with sorting and filtering.
  • Performing and making views and table-valued functions.
  • Gain the skills to see how the servers of SQL function and how they utilize information types
  • Write SELECT statements with sorting and filtering.
  • Figuring out how to compose DML queries and statements that utilize in the functions of the build.
  • Queries composing that aggregate date as well as composing subqueries too which will utilize the functions of window offset, ranking, and aggregate.
  • Compose queries
  • Making and executing views and table-valued functions.
  • Include programming builds, for example, conditions, variables, and loops to the code of T-SQL.
  • Change information by implementing unpivot, pivot, rollup and cube.
  • Make and execute stored procedures.

Targeted audience:

Since this is a course with respect to data about the servers of SQL and Transact, it is especially for individuals working in the fields that are related to the databases e.g Database Administrator, Database Developers, and BI experts.

Prerequisites:

So as to take this course you ought to have some information on Microsoft Windows and databases.

Outline

Course Endorsed By:

Author

Ola Sigurdson

Ola Sigurdson has designed and optimized networks for 30 years, from the cabling systems, network equipment and servers, to the end user applications. His company has been providing cloud service for biotech companies since the start of the millennium. He is now guiding companies, primarily in telco, to choose the right SDN technology for their virtualized NFV infrastructure.

Frequently Asked Questions

What are the prerequisites to the course Querying Data with Microsoft Transact-SQL (MS-20761) ?
  • Working Knowledge of Relational Databases.
  • Fundamental knowledge of the Microsoft Windows operating system and its core functionality.

What is the Difficulty level of the course Querying Data with Microsoft Transact-SQL (MS-20761) certification training?

  • Intermediate.

How will Querying Data with Microsoft Transact-SQL (MS-20761) certification training benefit me in my current job role?

This certification training will help you in your Job’s current role by knowing and getting hands on experience in the following areas:

  • How to retrieve Data from a SQL Server database.
  • How to write Functions and subqueries to obtain custom results
  • Writing views and table valued functions
  • Writing Stored Procedures, DML Statements and Multi-Table select statements.

What is the exam criteria for the course Querying Data with Microsoft Transact-SQL (MS-20761)?

Following is the Criteria/Format of 70-761 Exam:

  • Manage Data with Transact SQL (40-45%) topics from this area which includes scenario- based questions, MCQ’s, writing TSQL statements and Drag and Drop question and answers.
  • 30 to 35% questions will be based on Querying Advanced TSQL components such as subqueries, Apply operator, tabled valued expressions, temporal and non- relational data. Expect scenario-based questions, MCQ’s and completing T-SQL Queries.
  • Same format from the last section of this exam (Programming databases using TSQL). Weightage of 25-30%). Expect MCQ’s. and completing TSQL statements to create Stored Procedures, Writing Queries for error handling and dry run the code to check what output it will produce.
  • To pass the exam you have to score 700 marks out of 100.Please note that: each question contains distinct weightage and percentage define for each section may vary.

What you will learn?

  • Key components and capabilities of SQL Server
  • Sets and Predicate Logic
  • How to write single table select statement
  • How to query multiple tables
  • Sort and Filter Data
  • Different Data Types and their usage.
  • How to write DML Queries.
  • Built in Function in SQL Server 2016.
  • Aggregating and Grouping Data.
  • Subqueries
  • Table Expressions
  • Set Operators and their usage.
  • What is Windows Ranking, Offset, and Aggregate Functions?
  • Pivoting and Sets Grouping.
  • Transactions and their usage.
  • Error Handling.
  • How to do Programming in T-SQL

Do I have to prepare anything before attending the Querying Data with Microsoft Transact-SQL (MS-20761) course?

You must know about following topics in depth before taking this course:

  • How Relational databases work.
  • Fundamentals of Windows Operating System and its core functionalities.

More Information

More Information
BrandMicrosoft
SubjectsIT Ops & Management
Lab AccessYes
TechnologyMicrosoft
Learning StyleVirtual Classroom
Learning TypeCourse
DifficultyIntermediate
Course Duration5 Days
LanguageEnglish
SATV Value5
VPA DiscountVPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Prerequisites
Sale
Introduction to Microsoft SQL Databases (MS-10985)
Introduction to Microsoft SQL Databases (MS-10985)
300%
  • Virtual Classroom
  • 3 Days
Now Only $1,395.00 Regular Price $1,995.00

Contact A Learning Consultant


Customer Reviews
  1. MS-20761 - Jan 11, 2019 - Live Online PST
    Course Quality
    100%
    Course Value
    60%
    Overall Satisfaction
    100%
    The instructor was good, I had issues accessing the course and materials and had to have support assist with getting me into the class a few times, but otherwise, the class itself was informative

    Review by

    Posted on

  2. MS-20761 - Jan 11, 2019 - Live Online PST
    Course Quality
    100%
    Course Value
    60%
    Overall Satisfaction
    100%
    The instructor was good, I had issues accessing the course and materials and had to have support assist with getting me into the class a few times, but otherwise, the class itself was informative

    Review by

    Posted on

  3. MS-20761 - Jan 11, 2019 - Live Online PST
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%
    The instructor was very knowledgeable and the training helped me reinforce my concepts.

    Review by

    Posted on

  4. MS-20761 - Jan 11, 2019 - Live Online PST
    Course Quality
    100%
    Course Value
    60%
    Overall Satisfaction
    100%
    The instructor was good, I had issues accessing the course and materials and had to have support assist with getting me into the class a few times, but otherwise, the class itself was informative

    Review by

    Posted on

  5. MS-20761 - Jan 11, 2019 - Live Online PST
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    100%
    The instructor was very knowledgeable and the training helped me reinforce my concepts.

    Review by

    Posted on

  6. Love the training
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Labs were awesome and detailed.

    Review by

    Posted on

  7. Excellent Course
    Course Quality
    80%
    Course Value
    80%
    Overall Satisfaction
    100%
    Overall couse was Good!!

    Review by

    Posted on

  8. Great
    Course Quality
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Overall,couse was Awesome!

    Review by

    Posted on

  9. Knowledgable Instructor
    Course Quality
    100%
    Course Value
    60%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  10. Great instructor!
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  11. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Instructor knowledgeable. But material went fast and challenging to learn content quickly with single pass. Pace could go slower with more Q&A. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  12. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  13. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  14. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Jeff is extremely knowledgeable and knows the material very well. He is able to field questions effectively and teaches in an understandable well paced manner. I have worked less than 1 year in the IT industry when taking this training.

    Review by

    Posted on

  15. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Jeff was very helpful answering questions and providing examples when asked. He was very approachable and was willing to explain further when asked. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  16. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  17. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  18. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Bobby was an energetic and knowledgeable instructor it was a pleasure being his student. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  19. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  20. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  21. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  22. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Great Job Mr. Jeff Keep it up! I have worked 7-10 years in the IT industry when taking this training.

    Review by

    Posted on

  23. Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  24. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  25. Course Value
    100%
    Quality of Instructor
    20%
    Overall Satisfaction
    100%

    Review by

    Posted on

  26. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  27. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  28. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    The instructor was very knowledgeable in the subject matter. I have worked 1-3 years in the IT industry when taking this training.

    Review by

    Posted on

  29. Course Value
    100%
    Quality of Instructor
    40%
    Overall Satisfaction
    60%

    Review by

    Posted on

  30. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  31. Course Quality
    80%
    Overall Satisfaction
    100%
    So many errors in the content, and especially the demos, will make it tough to follow when going back to review without instructor present to point out mistakes. It was very distracting. very thorough and a great communicator.

    Review by

    Posted on

  32. Overall Satisfaction
    100%
    to see if I can make a career change. he provides examples from previous job experience.

    Review by

    Posted on

  33. Course Quality
    80%
    Quality of Instructor
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  34. Course Quality
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

click here