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.

Who Should Attend

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

Course Content

  • Module 1: Introduction to Microsoft SQL Server
  • 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 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 Aggregate Functions
  • 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

Frequently Asked Questions

"Querying Data with Transact-SQL - Course 20761-C Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 1,490 $.

"Querying Data with Transact-SQL - Course 20761-C Course" trainings are given in two different ways.

The tuition fee as a group is 1,350 $. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 1,490 $.

Our "Querying Data with Transact-SQL - Course 20761-C Course" trainings are one-to-one 5 days,

Our "Querying Data with Transact-SQL - Course 20761-C Course" trainings are group 3 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Reviews

Recommendations by our happy graduates.

Request more information for
"Querying Data with Transact-SQL - Course 20761-C Course"

Prefered Mode of Contact