Limited Time Discount Offer
40% Off - Ends in 02:00:00
Best seller!
70-761: Querying Data with Transact-SQL Training Course
Best seller!
star star star star star

70-761: Querying Data with Transact-SQL Certification Video Training Course

The complete solution to prepare for for your exam with 70-761: Querying Data with Transact-SQL certification video training course. The 70-761: Querying Data with Transact-SQL certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft MCSA 70-761 exam dumps, study guide & practice test questions and answers.

141 Students Enrolled
10 Lectures
06:45:25 Hours

70-761: Querying Data with Transact-SQL Certification Video Training Course Exam Curriculum



1 Lectures
Time 00:03:14

Getting Started

4 Lectures
Time 00:17:11


5 Lectures
Time 00:27:11


  • 03:15

Getting Started

  • 04:09
  • 04:49
  • 05:04
  • 03:09


  • 08:10
  • 06:21
  • 05:55
  • 05:07
  • 01:39

About 70-761: Querying Data with Transact-SQL Certification Video Training Course

70-761: Querying Data with Transact-SQL certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.

This is an awesome Microsoft practice lab course that can help you advance your knowledge and pass the 70-761 certification exam. This training is intended for those who want to know more about Transact-SQL. It is structured so that the initial segment of the substance can be educated as a course to the individuals requiring the additional learning for different courses in the SQL Server educational modules.


Microsoft SQL Server is one the most well-known Relational Database Management System (RDBMS) utilized in the Microsoft universe. What's more, the 70-761: Querying Data with Transact SQL course is structured in a stage work. It begins with most major subjects like what is data and database. It goes to cutting-edge themes like working with triggers, put-away methods and files. This is a perfect start-up for those individuals who will discover their vocation in programming web or Windows applications utilizing C# or utilizing MSBI instruments for information exam and reports.
The principle aim of the course is to give the candidates a profound understanding of the Transact-SQL dialect used by all SQL Server-related controls, to be specific, Database Administration, Database Development, and Business Intelligence.


The course comes with a basic and single requirement of having working knowledge regarding databases and basics of SQL Server Express. The understanding of Microsoft Windows for its basic functionality is also welcome. The system engineers, SQL Server database administrators, and developers who want to take the 70-761 exam must have at least two years of experience.

Course outline
  • Portray key capacities and parts of SQL Server
  • Make and actualize perspectives and table-esteemed capacities
  • Compose a multi-table SELECT proclamation
  • Portray T-SQL, sets, and predicate rationale
  • Utilize set administrators to join question results
  • Compose SELECT proclamations with separating and arranging
  • Depict how SQL Server utilizes information types
  • Compose DML explanations
  • Compose a solitary table SELECT proclamation
  • Compose subqueries
  • Compose questions that utilization worked in capacities
  • Compose inquiries that total information
  • Change information by actualizing turn, 3D shape, UNPIVOT, and rollup 
  • Make and actualize put-away strategies
  • Include programming builds, for example, factors, conditions, and circles to T-SQL code
Course objectives
  • Working with SQL Server 2016 Tools
  • Querying Multiple Tables
  • Using Table Expressions
  • Using Built-In Functions
  • Introduction to Transact-SQL Querying
  • Implementing Error Handling
  • Writing Basic SELECT Statements
  • Using Subqueries
  • Filtering and Sorting Data
  • Using DML to Modify Data
  • Using SET Operators
  • Pivoting and Grouping Sets
  • Programming with T-SQL
  • Working with SQL Server 2016 Data Types
  • Implementing Transactions 
  • Grouping and Aggregating Data
  • Using Windows Ranking, Offset, and Aggregate
Exam details
  • The exam passing score is 700 marks out of 1000.
  • The paper is possible to fill in the English language.
  • The test leads to obtaining the MCSA and MCP certificates.
Exam topics
  • Managing data with Transact-SQL 
  • Querying data with advance Transact-SQL components 
  • Programming databases with the usage of Transact-SQL
Target audience
  • Database Administrators
  • BI Professionals
  • Database Developers

This Microsoft course is the excellent training that can increase your competence, highlight you among other specialists, and approve your insight and abilities.

Career path:
  • Database Designers 
  • Database Developers 
  • Database Administrators 
  • IT Managers 
  • IT Directors 
  • Systems Administrators 
  • Sr. Systems Engineers

The certificate holder is capable of earning a basic salary from about $44,655 to $135,186 on yearly basis. 

Prepaway's 70-761: Querying Data with Transact-SQL video training course for passing certification exams is the only solution which you need.

Free 70-761 Exam Questions & Microsoft 70-761 Dumps
Views: 2174
Downloads: 1964
Size: 10.76 MB
Views: 1879
Downloads: 1915
Size: 11.13 MB
Views: 1997
Downloads: 2248
Size: 10.84 MB
Views: 3665
Downloads: 3826
Size: 10.27 MB

Student Feedback

star star star star star
star star star star star
star star star star star
star star star star star
star star star star star

Comments * The most recent comment are at the top

South Africa
Jan 23, 2021
I don't seem to find the "working files folder" in my list of folders, please any help will be greatly appreciated.
Jan 19, 2021
This is really helpful and flexible course to enhance your professional levels. The online videos and the support of the expert tutor make miracles work while preparing for the exam. Again the practice tests and puzzles add to the excitement of learning with PrepAway.
Jan 08, 2021
The course went well. I liked it very much, and the teacher was extremely intuitive and proficient in the field. It is decent to have an evaluation after the course is finished to quantify what was realized and accomplished. I’m really adored learning with this guide. All the best for your future courses.
antonio brown
Jan 01, 2021
The course is well-organized and straightforward, easy to get even for beginners. Anyway, it also includes the difficult and important concepts of the 70-761 exam points: XML, JSON, CROSS APPLY, and OUTER APPLY. A debt of gratitude is in order for designing this adaptable to run with course.
United States
Dec 21, 2020
Up until this point, I like completely the way of discussing the teacher. He is extremely simple to pursue and talks so positively, which is definitely not the situation with all online courses. The concise recordings and the online practice papers were extremely incredible help in passing the exam.
Dec 10, 2020
The Instructor is exceptionally sure and competent. There is a great deal of clearness and explanations with models. Besides, this has helped in seeing all of the ideas in detail. It was astounding learning with this coach.
larry fitzgerald
Dec 01, 2020
I truly appreciated the course with all the provided clarifications. I believe I ingested 100% of the substance. A debt of gratitude is in order for making a difference for me.
United States
Nov 25, 2020
Good Evening, everybody, I'd like to know how to access the working file, please.

Thank you
Kushal Suyal
United Arab Emirates
Nov 13, 2020
Presenter explained each and every thing in a very good manner.
It helped me to pass my exam.
Nov 04, 2020
Does anybody have access to the script files following the examples and recommended practices?
Also, is the dump still valid?
Thanks! :)

Add Comments

Post your comments about 70-761: Querying Data with Transact-SQL certification video training course, exam dumps, practice test questions and answers.

Comment will be moderated and published within 1-4 hours

insert code
Type the characters from the picture.