Querying Data with Transact SQL

Become an TRANSACT-SQL Specialist. Construct and execute queries and sub-queries. Create and implement views and table-valued functions in T-SQL. Get the complete knowledge on creating and implementing joins and stored procedures. Get to Transform data by implementing pivot, unpivot, rollup and cube. Be able to sort and filter data, use built-in functions and table expressions. Acquire insights to group and aggregate data, use set operators and pivot sets. Learn to implement error handling and transactions in T-SQL.

  • On demand online self-paced Instructor-led classes by Industry Experts
  • Get a complete knowledge on constructing queries, sub-queries and stored procedures in T-SQL
  • Guidance to Practice, Study and Gain confidence to clear the Microsoft Certification Exam 70-761
Call Me

Self-Paced

batch loading...

Course Features

Related Courses

About Querying Data with Transact-SQL

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Course Objectives
  • Describe key capabilities and components of SQL Server 2016.
  • 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 SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • 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 window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.
Curriculum
Module 1:

Introduction to Microsoft SQL Server 2016

Module 2:

Introduction to T-SQL Querying

Module 3:

Writing SELECT Queries

Module 4:

Querying Multiple Tables

Module 5:

Sorting and Filtering Data

Module 6:

Working with SQL Server 2016 Data Types

Module 7:

Using DML to Modify Data

Module 8:

Using Built-In Functions

Module 9:

Grouping and Aggregating Data

Module 10:

Using Subqueries

Module 11:

Using Table Expressions

Module 12:

Using Set Operators

Module 13:

Using Windows Ranking, Offset, and Aggre

Module 14:

Pivoting and Grouping Sets

Module 15:

Executing Stored Procedures

Module 16:

Programming with T-SQL

Module 17:

Implementing Error Handling

Module 18:

Implementing Transactions

Instructor

All Microsoft On-demand content is designed and created by Microsoft Certified Trainers and Microsoft Subject Matter Experts. The trainers teaching the content in videos are the officials who have been working on the same technology that is being taught in the course.

Certification

After completing the course sucessfully you will be able to download and save the certificate or print it.

Pre-requisites

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

FAQs

Why should I choose MOC on-demand?

To ensure that learners have the adequate skills to use Microsoft technologies MOC on-demand Courses have been introduced by Microsoft. These courses have been made available to serve the needs of learners who prefer to study at their own pace, at their convinient time and from their preferred location globally.

What do MOC On-demand courses include?

  • MOC On-demand Courses are organised in Modules which include:
  • Demos: A video walk-through of a process or task discussed in that lesson.
  • Practices: A self-paced practice where they can apply what was covered in the lesson, with supporting prompts to guide them as needed.
  • Labs: These detailed exercises use practice files and offer a more hands-on experience with the lesson material. Note: Not all courses include labs.
  • Knowledge Checks: A brief quiz testing what was learned in the lesson.
  • Assessments: To test knowledge attained from the course.

How do I get the product?

After purchasing a MOC on-demand course on training.com, you will receive a mail with an access code, link to the Microsoft training site and detailed instructions to login, redeem the Access Code and start with your course.

What is important for students to know before redeeming a voucher code?

  • You need to create a Microsoft account if you have not already, for example, Live.com, Hotmail.com and Outlook.com.
  • An access code can only be redeemed once.
  • A code must be redeemed by the expiration date provided by their Microsoft Learning Partner.
  • Once activated, course materials are available for a period of 90 days
  • All the details are included in the Microsoft Official Course On-Demand Terms and Conditions: http://go.microsoft.com.

Who should join this course?

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

How are the MOC courses structured?

Microsoft official courses on-demand are arranged in modules that include few minutes videos. At the end of each module one or two questions will be posed to test your comprehension. There will be an assessment of at least 25 questions at the end of the course.

What is the instructors' profile who teach the course?

All Microsoft On-demand content is designed and created by Microsoft Certified Trainers and Microsoft Subject Matter Experts. The trainers teaching the content in videos are the officials who have been working on the same technology that is being taught in the course.

What are the course packages available to purchase?

There are 2 sets of courses - Basic Set and Package Set

Basic Set:
  • 90-day access to the official Microsoft On-Demand Training Videos
  • 90-day access to Live Microsoft Labs Online (MLO) for hands-on practice
  • 90-day access to Course Exercises
  • Reading and Knowledge checks throughout the course
  • Package Set:
  • Basic Set features
  • Digital edition of the Microsoft Official Curriculum (dMOC) kit for reference.

Course Features

batch loading...

Related Courses

AI and Deep Learning with TensorFlow
AWS Certification and Training Program
Active Directory® Services with Windows Server®
Administering Microsoft Exchange Server 2016
Administering Microsoft® SQL Server® 2014 Databases
Administering System Center Configuration Manager and Intune
Administering Windows Server® 2012
Administering the Web Server IIS Role of Windows Server
Administration Essentials for New Admins- Salesforce
Advanced Automated Administration with Windows PowerShell®
Advanced Data Mining projects with R
Advanced Pay Per Click
Advanced Program in Data Sciences
Advanced Social Media Marketing
Advanced Solutions of Microsoft Exchange Server 2013
Advanced Solutions of Microsoft® SharePoint® Server 2013
Analyzing Data with Power BI
Analyzing and Visualizing Data with Excel
Analyzing and Visualizing Data with Power BI
Android Game Development for Beginners
Angular 5
Application Development with Swift 2
Automated UI Testing in Java
Automating Administration with Windows PowerShell®
Big Data Analytics with R
Big Data Applications using Hadoop
Building Android Games with OpenGL ES
Building Applications with Ext JS
Building Applications with Force.com
Building a Data Mart with Pentaho Data Integration
Building iOS 10 Applications with Swift
Builiding web application with spring MVC
Business Analytics using R from KPMG
Business Analytics using R from KPMG – Advanced
Business Analytics using R from KPMG – Expert
Certified Digital Marketing Professional
Cloud and Datacenter Monitoring with System Center Operations Manager
Complete Web and Social Media Analytics
Configuring Advanced Windows Server® 2012 Services
Core Solutions of Microsoft® Exchange Server 2013
Core Solutions of Microsoft® SharePoint® Server 2013
Core Solutions of Skype for Business 2015
Data Quality 9.x: Developer, Level 1
Data Science Orientation
Data Science with R
Data Science with Spark
Deploying Windows Desktops and Enterprise Applications
Designing and Deploying Microsoft Exchange Server 2016
Designing and Implementing a Server Infrastructure
DevOps Certification Training
Developing Microsoft Azure Solutions
Developing Microsoft SharePoint® Server 2013
Developing Microsoft SharePoint® Server 2013 Core Solutions
Developing SQL Databases
Enabling and Managing Microsoft Office 365
Executive Program in Applied Finance
Executive Program in Digital and Social Media Marketing Strategy
Fundamentals of a Windows Server® Infrastructure
GNIIT Foundation
Getting Started with R for Data Science
Getting started with Apache Solr Search Server
IBM Cognos Connection and Workspace Advanced
IT Service Management with System Center Service Manager
Implementing Microsoft Azure Infrastructure Solutions
Implementing Microsoft Azure Solutions-70-533
Implementing a Data Warehouse with Microsoft® SQL Server® 2014
Informatica PowerCenter 9.x Level 1
Installing and Configuring Windows 10
Installing and Configuring Windows Server® 2012
Introducing Rails 5 Learning Web Development the Ruby Way
Introduction to ITIL
Introduction to SQL Databases
Introduction to Web Development with Microsoft Visual Studio 2010
Java Enterprise Apps with DevOps
Joomla Certification Training Program
Julia for Data Science
LEAD (Learn. Enhance. Aspire. Deliver)
Learning Android N Application Development
Learning Data Mining with R
Learning Joomla 3 Extension Development
Learning MongoDB
Learning R for Data Visualization
Learning Spring Boot
Learning Swift 2
Linux shell scripting solution
Machine Learning with Python
Marketing Analytics Data Tools and Techniques
Mastering Magento
Open Source Web App Development using MEAN Stack
PMI® Agile Certified Practitioner Training
Pentaho Reporting
Performance Tuning and Optimizing SQL Databases
Planning and Deploying System Center 2012 Configuration Manager
Post Graduate Certificate in General Management (PGCGM)
Programming Using Python
Programming in C Sharp
Programming in HTML5 with JavaScript and CSS3
Programming with Python for Data Sciences.
Project Management Professional (PMP®) Training
Querying Data with Transact SQL
Querying Microsoft SQL Server® 2014
R Data Mining Projects
R for Data Science Solutions
Reactive Java 9
SAS Certification Training Program
Secrets of Viral Video Marketing
Selenium with Java
Six Sigma Certification Training Program
Spring Security
Supply Chain Management(SCM) Training Program
Supporting and Troubleshooting Windows 10
Teradata Certification Training
Test Driven Android
UNIX Shell Scripting Training
Upgrading Your Skills to MCSA Windows Server 2016
Upgrading Your Skills to MCSA Windows Server® 2012
Web Apps Development using Node.js along with Express.js and MongoDB
Web Apps Development with HTML5, CSS3, jQuery & Bootstrap
Web Development with Node.JS and MongoDB
iOS App Development Certification Training
jquery UI Development