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.

Interested in gaining deeper knowledge and acquiring new skills? Look no further than our "Querying Data with Transact-SQL - Course 20761-C Course" course. Regardless of where you're situated, including Antalya, you can connect with our experienced instructors at AcademyTech's advanced training centers, online education platforms, or even arrange training sessions at your own facilities. If you represent a company or a large organization, we can tailor training programs to your specifications, selecting convenient locations or delivering them at your workplace. Whether you're an individual or part of a larger team, we're fully equipped to assist with all aspects of your "Querying Data with Transact-SQL - Course 20761-C Course" training.

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

September
2024
16
Mon
17
Tue
18
Wed
One to One - Online
09:00-17:00 (EST)
AT7771V242601
15,810 ₺
September
2024
21
Sat
22
Sun
23
Mon
One to One - Online
09:00-17:00 (EST)
AT7771V242651
15,810 ₺
30 September 2024 - 3 Oct
One to One - Online
09:00-17:00 (EST)
AT7771V242741
15,810 ₺
13,560 ₺
Early bird discount
October
2024
5
Sat
6
Sun
7
Mon
One to One - Online
09:00-17:00 (EST)
AT7771V242791
15,810 ₺
13,560 ₺
Early bird discount
October
2024
14
Mon
15
Tue
16
Wed
One to One - Online
09:00-17:00 (EST)
AT7771V242881
15,810 ₺
13,560 ₺
Early bird discount
October
2024
19
Sat
20
Sun
21
Mon
One to One - Online
09:00-17:00 (EST)
AT7771V242931
15,810 ₺
13,560 ₺
Early bird discount
October
2024
28
Mon
29
Tue
30
Wed
One to One - Online
09:00-17:00 (EST)
AT7771V243021
15,810 ₺
13,560 ₺
Early bird discount
November
2024
2
Sat
3
Sun
4
Mon
One to One - Online
09:00-17:00 (EST)
AT7771V243071
15,810 ₺
13,560 ₺
Early bird discount

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 13,560 ₺.

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

The tuition fee as a group is 35,620 ₺. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 13,560 ₺.

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.

Popular locations for Querying Data with Transact-SQL - Course 20761-C Course in Turkey

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

Prefered Mode of Contact