Querying Data with Transact-SQL - Course 20761-C Course in United States
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.
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,480 $.
"Querying Data with Transact-SQL - Course 20761-C Course" trainings are given in two different ways.
The tuition fee as a group is 1,490 $. To create a group, you must be at least 3 people.
The one-to-one tuition fee is 1,480 $.
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.
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