Introduction
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first part can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Remaining skills required to take exam 70-761 ae also covered.
Audience
The main purpose of this 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
IT Graduates and Young Professionals: Elevate your career! Watch our IT Certifications Video and download our latest Guide.
Professional Exam(s)
Exam 70-761: Querying Data with Transact-SQLCertification(s):
Private: MCSA: SQL 2016 Database Development-
MODULES
- 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. March 06 8:00 - 15:10
2. March 07 8:00 - 15:10
3. March 08 8:00 - 15:10
4. March 09 8:00 - 15:10
5. March 10 8:00 - 15:10
6. March 13 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. March 06 8:00 - 15:10
2. March 07 8:00 - 15:10
3. March 08 8:00 - 15:10
4. March 09 8:00 - 15:10
5. March 10 8:00 - 15:10
6. March 13 8:00 - 15:10
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 | - |
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 |
.
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 |
