20461: Querying Microsoft SQL Server – Official Microsoft Course
Free
Introduction
This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; 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 2014.
- 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:
This course requires that you meet the following prerequisites:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Professional Exam(s)
Exam 70-461: Querying Microsoft SQL ServerCertification(s):
MCSA: SQL Server-
MODULES
- Introduction to Microsoft SQL Server 2014
- Introduction to T-SQL Querying
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server 2014 Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Using Table Expressions
- Using Set Operators
- Using Window Ranking, Offset, and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
- Improving Query Performance
- Querying SQL Server Metadata
- Nicosia
City
- Class A
1. Tuesday Oct 9 8:00 - 15:10
2. Thursday Oct 11 8:00 - 15:10
3. Friday Oct 13 8:00 - 15:10
4. Tuesday Oct 16 8:00 - 15:10
5. Thursday Oct 18 8:00 - 15:10
6. Friday Oct 19 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 20461 | Official - digital | 70-461 | |
| Amount | €425,00 | €205,00 | €100,00 |
| VAT * | €209,95 | €38,95 | - |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manual | Exam | |
| Official Course 20461 | Official - digital | 70-461 | |
| Amount | €600,00 | €205,00 | €100,00 |
| VAT | €114,00 | €38,95 | - |
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 20461, 20462 & 20463 | Official 20461, 20462 & 20463 | 70-461, 70-462 & 70-463 | |
| Amount | €510,00 | €615,00 | |
| VAT * | €484,50 | €116,85 |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manuals | Exams | |
| Courses 20461, 20462 & 20463 | Official 20461, 20462 & 20463 | 70-461, 70-462 & 70-463 | |
| Amount | €1,260,50 | €615,00 | €300,00 |
| VAT | €239,50 | €116,85 |
