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

Download Course Contents

20761C:Querying Data with Transact-SQL 2016 Course Overview

New version DP-080T00: Querying Data with Microsoft Transact-SQL is now available.

T-SQL or Transact SQL is a query language specific to the Microsoft SQL Server product. It can help perform operations like retrieving data from a single row, inserting new rows, and retrieving multiple rows. It is a procedural language that is used by the SQL server.

Businesses use tools like these to help sift through large databases of information to derive meaningful or relevant data. Professionals with this skill set are highly sought after worldwide, across industries, and for businesses of any size. Professionals completing the 20761C: Querying Data with Transact-SQL 2016 training course are able to use Transact-SQL to query data based on organizational needs.

For professionals looking to establish themselves as database and business intelligence professionals, this course is the right fit for you. Check out the dates below to enroll in this Querying Data with Transact-SQL 2016 course today.

home-icon

The 1-on-1 Advantage

Get 1-on-1 session with our expert trainers at a date & time of your convenience.
home-icon

Flexible Dates

Start your session at a date of your choice-weekend & evening slots included, and reschedule if necessary.
home-icon

4-Hour Sessions

Training never been so convenient- attend training sessions 4-hour long for easy learning.
home-icon

Destination Training

Attend trainings at some of the most loved cities such as Dubai, London, Delhi(India), Goa, Singapore, New York and Sydney.

You will learn:

Module 1: Introduction to Microsoft SQL Server 2016
  • Lesson 1: The Basic Architecture of SQL Server
  • Lesson 2: SQL Server Editions and Versions
  • Lesson 3: Getting Started with SQL Server Management Studio
  • Lab: Working with SQL Server 2016 Tools
  • Lesson 1: Introducing T-SQL
  • Lesson 2: Understanding Sets
  • Lesson 3: Understanding Predicate Logic
  • Lesson 4: Understanding the Logical Order of Operations in SELECT Statements
  • Lab: Introduction to T-SQL Querying
  • Lesson 1: Writing Simple SELECT Statements
  • Lesson 2: Eliminating Duplicates with DISTINCT
  • Lesson 3: Using Column and Table Aliases
  • Lesson 4: Writing Simple CASE Expressions
  • Lab: Writing Basic SELECT Statements
  • Lesson 1: Understanding Joins
  • Lesson 2: Querying with Inner Joins
  • Lesson 3: Querying with Outer Joins
  • Lesson 4: Querying with Cross Joins and Self Joins
  • Lab: Querying Multiple Tables
  • Lesson 1: Sorting Data
  • Lesson 2: Filtering Data with Predicates
  • Lesson 3: Filtering Data with TOP and OFFSET-FETCH
  • Lesson 4: Working with Unknown Values
  • Lab: Sorting and Filtering Data
  • Lesson 1: Introducing SQL Server 2016 Data Types
  • Lesson 2: Working with Character Data
  • Lesson 3: Working with Date and Time Data
  • Lab: Working with SQL Server 2016 Data Types
  • Lesson 1: Adding Data to Tables
  • Lesson 2: Modifying and Removing Data
  • Lesson 3: Generating Automatic Column Values
  • Lab: Using DML to Modify Data
  • Lesson 1: Writing Queries with Built-In Functions
  • Lesson 2: Using Conversion Functions
  • Lesson 3: Using Logical Functions
  • Lesson 4: Using Functions to Work with NULL
  • Lab: Using Built-in Functions
  • Lesson 1: Using Aggregate Functions
  • Lesson 2: Using the GROUP BY Clause
  • Lesson 3: Filtering Groups with HAVING
  • Lab: Grouping and Aggregating
  • Lesson 1: Writing Self-Contained Subqueries
  • Lesson 2: Writing Correlated Subqueries
  • Lesson 3: Using the EXISTS Predicate with Subqueries
  • Lab: Using Subqueries
  • Details are not available.
  • Lesson 1: Writing Queries with the UNION Operator
  • Lesson 2: Using EXCEPT and INTERSECT
  • Lesson 3: Using APPLY
  • Lab: Using Set Operators
  • Lesson 1: Creating Windows with OVER
  • Lesson 2: Exploring Window Functions
  • Lab: Using Window Ranking, Offset, and Aggregate Functions
  • Lesson 1: Writing Queries with PIVOT and UNPIVOT
  • Lesson 2: Working with Grouping Sets
  • Lab: Pivoting and Grouping Sets
  • Lesson 1: Querying Data with Stored Procedures
  • Lesson 2: Passing Parameters to Stored Procedures
  • Lesson 3: Creating Simple Stored Procedures
  • Lesson 4: Working with Dynamic SQL
  • Lab: Executing Stored Procedures
  • Lesson 1: T-SQL Programming Elements
  • Lesson 2: Controlling Program Flow
  • Lab: Programming with T-SQL
  • Lesson 1: Implementing T-SQL Error Handling
  • Lesson 2: Implementing Structured Exception Handling
  • Lab: Implementing Error Handling
  • Lesson 1: Transactions and the Database Engine
  • Lesson 2: Controlling Transactions
  • Lab: Implementing Transactions
Live Online Training (Duration : 40 Hours)
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

2200 + If you accept merging of other students. Per Participant & excluding VAT/GST
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
1700 Per Participant & excluding VAT/GST
Online
09 - 13 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)
Online
06 - 10 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)
Winner of the Microsoft’s Asia Superstar Campaign in FY 22
Winner of the Microsoft’s Asia Superstar Campaign in FY 22
Course Prerequisites

In order to successfully complete this Querying Data with Transact-SQL 2016 course, participants must have;

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of relational databases

The Querying Data with Transact-SQL 2016 course is designed to introduce students to Transact-SQL. It is designed as a foundational course for participants to take other courses listed in the SQL Server curriculum.

Key Features Of 20761C:Querying Data with Transact-SQL 2016 Certification Training Course

  • 5-day Instructor-led Querying Data with Transact-SQL 2016Training
  • Get access to a free 1-hour Querying Data with Transact-SQL 2016course preview to learn Microsoft Transact-SQL
  • Expert Microsoft SQL instructors across the globe
  • Accredited Microsoft Querying Data with Transact-SQL 2016 course material prepared by SMEs
  • Get hands-on experience through Microsoft Transact-SQL lab sessions
  • Industry-recognized Microsoft Querying Data with Transact-SQL 2016 Course Completion certificate provided
  • Querying Data with Transact-SQL 2016training provided across 100+ locations globally

Who can take up Querying Data with Transact-SQL 2016Training?

Job roles that can take up Querying Data with Transact-SQL 2016 online training include, but are not limited to:

  • Application Developers
  • Database Administrators
  • Business Intelligence (BI) Professionals
  • Database Developers
  • Business Analysts
  • Report Writers
  • Data Analysts
  • IT Administrators
  • IT Professionals
  • Individuals looking to understand everything about the Microsoft Transact-SQL tool
  • Individuals who are looking to sit for Microsoft 70 - 761 certification exam

Learning Objectives of Querying Data with Transact-SQL 2016 Training

This Querying Data with Transact-SQL 2016 course consists of eighteen modules, including “Introduction to T-SQL Querying,” “Grouping and Aggregating Data,” “Pivoting and Grouping Sets,” and “Implementing Transactions.” These modules include labs allowing students to develop a more practical understanding of the concepts explained over the course.

Upon completion of this Querying Data with Transact-SQL 2016 course, candidates will learn how to;

  • Describe key capabilities and components of the SQL server
  • Describe T-SQL, sets, and predicate logic
  • Write a single table SELECT statement
  • Write a multi-table SELECT statement
  • Write Select statements with filtering and sorting
  • Describe how the SQL server uses data types
  • Write DML statements
  • Write queries that aggregate data
  • Write subqueries
  • Create and implement views and table-valued functions
  • Use set operators to combine query results
  • Write queries that use windows ranking, offset, and aggregate functions
  • Transform data by implementing pivot, unpivot, rollup and cube
  • Create and implement stored procedures
  • Add programming constructs including variables, conditions, and loops to T-SQL code

Benefits of taking up Querying Data with Transact-SQL 2016 Certification Training

  • Holding a Microsoft offered certification is ideal for professionals looking to establish themselves as highly skilled individuals in their field.
  • Microsoft certifications test professionals around the most up-to-date and relevant skills within the industry.
  • Professionals with Microsoft accreditation are recognized by prospective employers for their abilities to craft bespoke and relevant solutions.
  • Holding a Microsoft certification is also beneficial to the professional. It offers them heightened professional opportunities along with better starting salaries, benefits, and more desirable responsibilities.
  • Upon completion of this Querying Data with Transact-SQL 2016 course, participants can apply for the roles of database developers, database administrators, and BI professionals.

The average salaries for these job titles with Querying Data with Transact-SQL 2016 certification are as follows;

  • Database administrator: Average salary is USD 90,856 annually
  • Database developer: Average salary is USD 96,345 annually
  • BI Professional: Average salary is USD 87,611 annually for Business Intelligence Analysts

Querying Data with Transact-SQL 2016 Exam Format

Upon completion of this Querying Data with Transact-SQL 2016 online course, participants are eligible to sit the 70-761: Querying Data with Transact-SQL examination.

Exam Code Microsoft Querying Data with Transact-SQL
Exam Name Microsoft Dynamics 365 Finance
Exam Type Multiple-choice and Multiple Response Questions
Exam Cost USD 165
Total Questions 40 –60 Questions
Exam Duration 150 Minutes
Passing Score 700 out of 1000
Languages English

 

The examination tests learners around the ability to;

  • Manage data with Transact-SQL (40-45%)
  • Query data with advanced Transact-SQL components (30-35%)
  • Program databases by using Transact-SQL (25-30%)
Student Name Feedback
Yousef Hijazi
United States
A1. amazing
Saleh Al Obaidli
United States
A1. Thanks I'm really appreciated
Mark Lewis
United States
A1. The instructor was fine I have no complaints with the instructor.
Olga Makhova
United States
A1. This was an amazing experience for me! Sandeep has a very professional and friendly manner to deliver the course material. He has outstanding teaching skills, a lot of knowledgeable and experience. He was always happy to answer all my questions with no hesitation even if they were out of the scope of this training. I appreciate his flexibility in meeting my training needs and providing real world examples. I would highly recommend Sandeep as a trainer.
João Carlos Alberto Simões Reis
United States
A1. Kumar is very attentive and helpful, his explanation is very fluid
David Kuala Leonor
United States
A1. I can say, that it was a training with a favorable dynamics and it could be within what SQL programming is.
. Jumana Aljasmi
United States
A1. Tureen was an excellent trainer , he was passionate to teach us and I believe that this course will be an excellent addition to my skills
Awadh Ahmed
United States
A1. he was well prepared and good knowledge and skills easy to deliver the course
Chandan Kumar
United States
A1. having good knowledge about the topic
Nigel Appleford
United States
A1. Appreciated the flexibility and good, clear explanation of teaching points using examples - thanks!
Selwyn Wongfatt
United States
A1. very good knowledge and experience on the subject and very good in transposing the knowledge
Halima Abdulla
United States
A1. very nice explanation skills
Jason Lorimer
United States
A1. Tureen was vey knowledgeable on the subject and took the time to answer all questions on reitertae any subjects that were not understood the first time.
Fatima Safar
United States
A1. I would like to thank mr Tureen for making sure that everyone is satisfied and on track of understanding
Trent Mohney
United States
A1. He was very Knowledgeable.

FAQ's

Yes, you can pay from the course page and flexi page.
Yes you can request your customer experience manager for the same.
Yes, we do. For details go to flexi
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes.You can access courseware for most vendors.
You will receive the letter of course attendance post training completion via learning enhancement tool after registration.
You can request a refund if you do not wish to enroll in the course.
1-on-1 Public - Select your start date. Other students can be merged.
1-on-1 Private - Select your start date. You will be the only student in the class.
Yes, course requiring practical include hands-on labs.
You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
You can pay through debit/credit card or bank wire transfer.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
Yes you can.
Yes, this is our official email address which we use if a recipient is not able to receive emails from our @koenig-solutions.com email address.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
After you submit your payment, you will land on the payment confirmation screen.It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however,it takes 48 hours for the money to be moved.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, if we have an office in your city.
Yes, we do offer corporate training More details
Yes, we do.
Yes, we also offer weekend classes.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
Yes, fee excludes local taxes.
Yes, we do.
The Fee includes:
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Microsoft Gold Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1 on 1 Public you can select your own schedule, other students can be merged. Choose 1-on-1 if published schedule doesn't meet your requirement. If you want a private session, opt for 1-on-1 Private.
Duration of Ultra-Fast Track is 50% of the duration of the Standard Track. Yes(course content is same).

The main purpose of this Querying Data with Transact-SQL 2016 course is to give students a strong understanding of the Transact-SQL language used by all SQL server-related disciplines, namely Database Administration, Database Development, and business intelligence. As a result, the primary audience for this Querying Data with Transact-SQL 2016 course are Database Administrators, Database Developers, and BI professionals.

The cost of the Microsoft Querying Data with Transact-SQL 2016 course is based on the location of the participant and the choice of learning method. On average, the price for the Querying Data with Transact-SQL 2016 course at Koenig Solutions sits at USD 950. The cost of the Microsoft 70 – 761 examination varies based on the location of the participant and the choice of proctor; on average, the price sits at USD 165.

The Querying Data with Transact-SQL 2016 online course takes place over five days. This Querying Data with Transact-SQL 2016 training will be delivered by an expert Microsoft SQL trainer with real-world expertise across various industry sectors.

Microsoft allows five attempts per year for a specific examination. The retake policy for Microsoft 70-761 examination is as follows;

  • If a candidate is unable to clear the examination within the first attempt, they must wait at least 24 hours before retaking the examination
  • If the candidate does not clear the examination the second time, the candidate must wait at least 14 days before sitting the third attempt
  • Candidates must also sit a 14 day waiting period for the fourth and fifth subsequent examination retakes

Participants who enroll for the Querying Data with Transact-SQL 2016 certification training will get:

  • A copy of the Querying Data with Transact-SQL 2016 course material
  • Microsoft 70 - 761 Sample Papers
  • Hands-on exercises developed by an expert Microsoft SQL trainer
  • Querying Data with Transact-SQL 2016 course completion certificate from a Microsoft Gold Partner

Yes, Koenig Solutions is an accredited Microsoft Gold Partner to deliver Microsoft Querying Data with Transact-SQL 2016 Certification Training across the globe.

You can take up this 20761C: Querying Data with Transact-SQL 2016 certification training course in multiple delivery modes that include:

  • Instructor-led classroom training
  • Instructor-led Live online training
  • 1-on-1 training
  • Fly-me-a-Trainer
  • Corporate/on-site training

Prices & Payments

Yes, We are
Yes of course.

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.