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 DevelopmentMODULES
- Introduction to Microsoft SQL Server 2016
- Introduction to T-SQL Querying
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2016 Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Set Operators
- Nicosia
City
- Class A
1. November 27 8:00 - 15:10
2. December 03 8:00 - 15:10
3. December 04 8:00 - 15:10
4. December 10 8:00 - 15:10
5. December 12 8:00 - 15:10
6. December 16 8:00 - 15:10
Dates and Times
- 40
Duration (Hours)
- 20 Louki Akrita street, 2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
Dates and Times
- 40
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near 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 |
