20761 – Querying Data with Transact-SQL – Official Microsoft Course
Introduction
The main purpose of this 3 day instructor led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
Audience
The main purpose of this 3 day instructor led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
At Course Completion
After completing this course, students will be able to:
- Describe the basic architecture and concepts of Microsoft SQL Server 2016.
- Understand the similarities and differences between Transact-SQL and other computer languages.
- Write SELECT queries
- Query multiple tables
- Sort and filter data
- Describe the use of data types in SQL Server
- Modify data using Transact-SQL
- Use built-in functions
- Group and aggregate data
- Use subqueries
- Use table expressions
- Use set operators
- Use window ranking, offset and aggregate functions
- Implement pivoting and grouping sets
- Execute stored procedures
- Program with T-SQL
- Implement error handling
- Implement transactions
Prerequisites
- Working knowledge of relational databases
- Basic knowledge of the Microsoft Windows operating system and its core functionality
Professional Exam(s):
Exam 70-761: Querying Data with Transact-SQLCertification(s):
MCSA: SQL 2016 Database DevelopmentCourse Features
- Lectures 11
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
-
MODULES
- Nicosia
City
- Class A
1. May 05 8:00 - 15:10
2. May 07 8:00 - 15:10
3. May 11 8:00 - 15:10
4. May 13 8:00 - 15:10
5. May 15 8:00 - 15:10
6. May 19 8:00 - 15:10
Dates and Times
- 40
Duration (Hours)
- 20 Louki Akrita street,
2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
- Class A
1. January 23 8:30 - 15:40
2. January 24 8:30 - 15:40
3. January 30 8:30 - 15:40
4. January 31 8:30 - 15:40
5. February 6 8:30 - 15:40
6. February 7 8:30 - 15:40
Dates and Times
- 40
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(near Hellenic branch - ex Coop - and Agios Nikolaos church)
Location
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manual | Exam | |
| Official Course 20761 | Official - digital ** | 70-761 | |
| Amount | €525,00 | €205,00 | €100,00 |
| VAT * | €228,95 | €38,95 | - |
** if you prefer printed official courseware, cost will be higher by €27,00 +VAT.
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manual | Exam | |
| Official Course 20761 | Official - digital ** | 70-761 | |
| Amount | €600,00 | €191,00 | €100,00 |
| VAT | €114,00 | €36,29 | - |
Take advantage of our special offer by taking this course as part of a bundle of 3 courses leading to the following prestigious MCSA certification:
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manuals | Exams | |
| Courses 20761 & 20762 | Official 20761 & 20762 ** | 70-761 & 70-762 | |
| Amount | €340,00 | €382,00 | |
| VAT * | €323,00 | €72,58 |
** if you prefer printed official courseware, cost will be higher by €52,00 +VAT.
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manuals | Exams | |
| Courses 20761 & 20762 | Official 20761 & 20762 ** | 70-761 & 70-762 | |
| Amount | €840,00 | €382,00 | €200,00 |
| VAT | €159,00 | €72,58 |
