PDP Url

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

Rating:
91% of 100

This course works on two levels. The first three days the students will be taught about the Transact SQL and in a way that it will be helpful for students who want to take other SQL courses as well.


Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
empty table
tab
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1268 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

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 works on two levels. The first three days the students will be taught about the Transact SQL and in a way that it will be helpful for students who want to take other SQL courses as well.

Course Information

About the course:

This course works on two levels. The first three days the students will be taught about the Transact SQL and in a way that it will be helpful for students who want to take other SQL courses as well. The remainder two days will be concentrated on preparing you for the Microsoft 70-761: Querying Data with Transact-SQL certification exam.
A Database Administrator earns up to $71, 429 annually.

Aims:

  •  Being able to identify the key parts of the SQL server
  •  Being able to create a single table or multi table SELECT statement with filtering and sorting
  •  Being able to understand how SQL servers work and how they make use of data types
  •  learning how to write DML statements and queries that make use of in build functions
  •  writing queries that not only aggregate date but writing sub queries as well which will make use of window ranking, offset, and aggregate functions.
  •  Creating and implementing views and table-valued functions.
  •  Add programming constructs such as variables, conditions, and loops to T-SQL code
  •  Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.

Targeted audience:

Since this is a course regarding information about Transact and SQL servers, it is mainly for people working in database related fields e.g Database Developers, Administrator and BI professionals.

Prerequisites:

In order to  take this course you should have some knowledge of databases and Microsoft Windows.

Outline

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
Brand Microsoft
Subjects IT Ops & Management
Lab Access Yes
Technology Microsoft
Learning Style Virtual Classroom
Learning Type Course
Difficulty Intermediate
Course Duration 5 Days
Language English
SATV Value 5
VPA Discount VPA 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


click here