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

Download Course Contents

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

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.

The 1-on-1 Advantage

Methodology

Flexible Dates

  • • Choose Start Date
  • • Reschedule After Booking
  • • Weekend / Evening Option

4-Hour Sessions

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
  • 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.

1850 + If you accept merging of other students.
4 Hours
8 Hours
Ultra-Fast Track
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
1600 Per Participant
Online
12 - 16 Dec
09:00 AM - 05:00 PM CST
(8 Hours/Day)
Online
16 - 20 Jan
09:00 AM - 05:00 PM CST
(8 Hours/Day)
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 Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name Country Feedback Rating
Reswan Ismail United States A2. Koenig's professionalism is a great differentiator. Koenig lets students focus as much on their studies as possible, avoiding any kind of distractions. The assistance and support provided by the Training Coordinator - Mrs. Rini Watson and the Training Manager - Mrs. Danica Amor is truly essential. Congratulations for your engagement and professionalism.
michael essandoh-sam United States https://youtu.be/nNUXfS1uzGo
Lars Schlaepfer United States https://www.youtube.com/watch?v=m3K9HAXwS4w

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


In both, you choose the schedule. In public, other participants can join, Private other participants want to join.
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.
Yes, you can pay from the course page and flexi page.
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.
You can request a refund if you do not wish to enroll in the course.
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.
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.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
Yes you can.
Yes, we do. For details go to flexi
You can pay through debit/credit card or bank wire transfer.
Dubai, Goa, Delhi, Bangalore.
Yes you can request your customer experience manager for the same.
Yes, fee excludes local taxes.
Yes, we do.
The Fee includes:
  • Courseware
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Microsoft Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1-on-1 you can select your own schedule, other students can be merged but you select the schedule. Choose 1-on-1 if published schedule do not meet your requirement. If you also want a private session, opt for 1-on-1 Public.
Yes.
No, it is not included.

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.