Querying Data with Transact-SQL - Course 20761-C Course in Capellen
AT7771
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.
Acknowledged by Deloitte as a pioneer in education, AcademyTech provides the official Querying Data with Transact-SQL - Course 20761-C Course in Capellen and one-on-one online formats; both finalized with the certification exam.
Training schedule for "Querying Data with Transact-SQL - Course 20761-C Course"
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,700 €.
The total duration (day) of the One-to-One Querying Data with Transact-SQL - Course 20761-C Course program is 3.
Note: If you prefer to take this course onsite, the total duration will be 5, as required by the training vendor’s delivery standards.
We can also deliver this Querying Data with Transact-SQL - Course 20761-C Course in French, Arabic, and Spanish. If you require another language option, our Customer Success Managers will be happy to assist and guide you through availability and scheduling.
Yes, our certified and experienced trainers can deliver this program onsite at your location, and if required, in your preferred language. For customized delivery formats and pricing, please contact your Customer Success Manager.
If you prefer to take this course as a group (onsite), the total duration will be 5, as required by the training vendor’s delivery standards.
Official training materials (for Querying Data with Transact-SQL - Course 20761-C Course), instructor support, hands-on labs and practical exercises, and 1-month post-training Q&A support.
Exam & Certification
Participation Certificate
All trainees who participate in training will have an AcademyTech participation certificate.
AcademyTech Training and Consulting Center
AcademyTech is very affordable and a perfect online training environment. Training Coordicator (Seyma) is always taking care of how the course is going on. A typical day insisted of some prep time in the morning, lots of time for Q and A during the course. Verify flexible schedule and very knowledgeable trainers.
Jason Bradford
Our Company is an Oil & Natural Gas Company in Libya, and our Microsoft Azure Courses given by AcademyTech at Istanbul. We are really glad for the Microsoft Azure Courses which is held at AcademyTech's venue named as Artois Cadde. Moreover the great courses, we have been hosted by the management team in Artois Restaurant at evenings with their tastefull cocktails and Pastas.
Salah Handr
I joined an online 3 days Microsoft course, with great student guides and lab guides, coupled with an instructor (Konstantin Ceran) who made the topics interesting with with knowledge of the subject matter.
Kerri Kincaid
I was in doubt to take this Microsoft course as Online.But I was really impressed with the easy to use online system, Labs and Presentation, as well as the instructor's knowledge, availability, and willingness to help me throughout the course.
Nick Ragan
Just completed the 20703 - Administering SCCM course. Top notch training materials, lab and instruction. Thank you for a great class Mr. Kosta
JOSE GOSENDE
Microsoft Power BI Training by Kosta was actually well tailored to match a novice like me. Online Training Systems and the team (Seyma) behind it also did a good job in following up and arranging everything required for and before the training neatly. Thank you.!
Fabricio Reyes
Took the one day Azure fundamentals. Really enjoyed this course. I have better understanding of Azure. The delivery of this course was great. It was not too technical it was good to have a good picture. Really enjoyed the instructor also showing how things are working in Azure. It's not just a lecture you get to see the components in actions.
Bharat Khare
Very good instructor and very good course (Azure Fundamentals) - I don't like the word "Excellent", I generally use it only for sightseeing :))
Michael Hutchings