MENU
Introduction
CoursesCourses
Querying Microsoft SQL Server
new Interest in course

Querying Microsoft SQL Server (MOC20461)

This 5-day 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.
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.
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 Profile

The course is included in the following categories: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
Microsoft

Difficulty of the course: Beginner

Course duration: 5 days

Contents of the course:

  • Introduction to Microsoft SQL Server 2014
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • 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

Expected knowledge:
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.

Time schedule: 9:00 - 17:00

.

Course dates:

22.10. 26.10.2018 Bratislava
1 000 EUR (without VAT)
22.10. 26.10.2018 Brno
25 700 CZK (without VAT)
05.11. 09.11.2018 Praha
25 700 CZK (without VAT)
12.11. 16.11.2018 Ostrava 25 700 CZK (without VAT) Order
12.11. 16.11.2018 Bratislava 1 000 EUR (without VAT) Order
19.11. 23.11.2018 Košice 1 000 EUR (without VAT) Order
19.11. 23.11.2018 Brno 25 700 CZK (without VAT) Order
03.12. 07.12.2018 Ostrava 25 700 CZK (without VAT) Order
03.12. 07.12.2018 Praha 25 700 CZK (without VAT) Order
10.12. 14.12.2018 Bratislava 1 000 EUR (without VAT) Order
17.12. 21.12.2018 Košice 1 000 EUR (without VAT) Order
17.12. 21.12.2018 Brno 25 700 CZK (without VAT) Order
25.12. 29.12.2018 Praha 25 700 CZK (without VAT) Order
07.01. 11.01.2019 Bratislava 1 000 EUR (without VAT) Order
14.01. 18.01.2019 Praha 25 700 CZK (without VAT) Order
14.01. 18.01.2019 Brno 25 700 CZK (without VAT) Order

Recommended previous and follow-up courses: