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.

  Training schedule for "Querying Data with Transact-SQL - Course 20761-C Course"

August
2022
20
Sat
21
Sun
22
Mon
23
Tue
One to One - Online
09:00-17:00 (EST)
AT7771V222321
1,490 $
1,340 $
August
2022
6
Sat
7
Sun
8
Mon
9
Tue
One to One - Online
09:00-17:00 (EST)
AT7771V222181
1,490 $
1,340 $
July
2022
23
Sat
24
Sun
25
Mon
26
Tue
One to One - Online
09:00-17:00 (EST)
AT7771V222041
1,490 $
1,340 $
August
2022
15
Mon
16
Tue
17
Wed
18
Thu
One to One - Online
09:00-17:00 (EST)
AT7771V222271
1,490 $
1,340 $
July
2022
18
Mon
19
Tue
20
Wed
21
Thu
One to One - Online
09:00-17:00 (EST)
AT7771V221991
1,490 $
1,340 $
July
2022
9
Sat
10
Sun
11
Mon
12
Tue
One to One - Online
09:00-17:00 (EST)
AT7771V221901
1,490 $
June
2022
25
Sat
26
Sun
27
Mon
28
Tue
One to One - Online
09:00-17:00 (EST)
AT7771V221761
1,490 $
August
2022
1
Mon
2
Tue
3
Wed
4
Thu
One to One - Online
09:00-17:00 (EST)
AT7771V222131
1,490 $
1,340 $
July
2022
4
Mon
5
Tue
6
Wed
7
Thu
One to One - Online
09:00-17:00 (EST)
AT7771V221851
1,490 $

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,340 $.

"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,340 $.

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