> > > 20761

Querying Data with Transact-SQL (20761)

Course Description Schedule Course Outline Querying Data with Transact-SQL - Download PDF Download PDF
 

Course Overview

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Who should attend

The main purpose of the 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.

Prerequisites

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

Course Objectives

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2016.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

Follow On Courses

Course Content

  • 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 Table Expressions
  • Using Set Operators
  • Using Windows Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
Classroom Training
Modality: C

Duration 5 days

Price (excl. tax)
  • Eastern Europe: 1,250.- €
  • SA Voucher: 5
    hardcoded default SA
Dates and Booking
Online Training
Modality: L

Duration 5 days

Price (excl. tax)
  • Eastern Europe: 1,250.- €
  • SA Voucher: 5
    hardcoded default SA
Dates and Booking
 
Click on town name to book Schedule
Slovenia
 11/03/2019 - 15/03/2019 Ljubljana This is a FLEX course.   Time zone: Europe/Ljubljana Course language: English Enroll:
for online training
for classroom training
Poland
 11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Ljubljana Course language: English Enroll
Turkey
 11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Ljubljana Course language: English Enroll
Czech Republic
 11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Ljubljana Course language: English Enroll
Hungary
 11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Ljubljana Course language: English Enroll
Romania
 11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Ljubljana Course language: English Enroll
Slovakia
 11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/Ljubljana Enroll
Europe
Germany
25/03/2019 - 29/03/2019 Hamburg Enroll
08/04/2019 - 12/04/2019 Münster Enroll
29/04/2019 - 03/05/2019 Stuttgart Enroll
20/05/2019 - 24/05/2019 Berlin Enroll
11/06/2019 - 14/06/2019 Frankfurt 4 days Enroll
01/07/2019 - 05/07/2019 Düsseldorf Enroll
15/07/2019 - 19/07/2019 Munich Enroll
29/07/2019 - 02/08/2019 Hamburg Enroll
+ show all dates
France
04/03/2019 - 08/03/2019 Bordeaux Enroll
18/03/2019 - 22/03/2019 Paris Enroll
13/05/2019 - 17/05/2019 Lille Enroll
20/05/2019 - 24/05/2019 Aix-en-Provence Enroll
20/05/2019 - 24/05/2019 Bordeaux Enroll
20/05/2019 - 24/05/2019 Paris Enroll
03/06/2019 - 07/06/2019 Lyon Enroll
03/06/2019 - 07/06/2019 Strasbourg Enroll
+ show all dates
Italy
15/04/2019 - 19/04/2019 Milan Enroll
24/06/2019 - 28/06/2019 Rome Enroll
21/10/2019 - 25/10/2019 Milan Enroll
Switzerland
29/04/2019 - 03/05/2019 Zurich Enroll
15/07/2019 - 19/07/2019 Zurich Enroll
02/09/2019 - 06/09/2019 Zurich Enroll
11/11/2019 - 15/11/2019 Zurich Enroll
United Kingdom
 25/02/2019 - 01/03/2019 guaranteed date! FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
11/03/2019 - 15/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
11/03/2019 - 15/03/2019 Manchester Enroll
18/03/2019 - 22/03/2019 FLEX training This is an English language FLEX course.   Time zone: Europe/London Enroll
18/03/2019 - 22/03/2019 London Enroll
25/03/2019 - 29/03/2019 Birmingham Enroll
01/04/2019 - 05/04/2019 Newcastle Enroll
15/04/2019 - 23/04/2019 London (Int Hse) 7 days Enroll
+ show all dates
North America
United States
 04/03/2019 - 08/03/2019 guaranteed date! Online Training Time zone: US/Pacific Course language: English Enroll
Latin America
Argentina
 05/08/2019 - 09/08/2019 Online Training Time zone: America/Buenos_Aires Course language: Spanish Enroll
Brazil
 15/07/2019 - 19/07/2019 Online Training Time zone: America/Sao_Paulo Course language: Portuguese Enroll
Colombia
 13/05/2019 - 17/05/2019 Online Training Time zone: America/Bogota Course language: Spanish Enroll
Costa Rica
 15/07/2019 - 19/07/2019 Online Training Time zone: America/Costa_Rica Course language: Spanish Enroll
Mexico
 15/07/2019 - 19/07/2019 Online Training Time zone: America/Mexico_City Course language: Spanish Enroll
Peru
 04/11/2019 - 08/11/2019 Online Training Time zone: America/Lima Course language: Spanish Enroll
Middle East
Qatar
24/03/2019 - 28/03/2019 Doha Course language: English Enroll
28/07/2019 - 01/08/2019 Doha Course language: English Enroll
24/11/2019 - 28/11/2019 Doha Course language: English Enroll
United Arab Emirates
24/03/2019 - 28/03/2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
26/05/2019 - 30/05/2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
28/07/2019 - 01/08/2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
29/09/2019 - 03/10/2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
24/11/2019 - 28/11/2019 Dubai Course language: English This course is being delivered by iTLS. Enroll
Africa
Egypt
24/03/2019 - 28/03/2019 Cairo Course language: English Enroll
26/05/2019 - 30/05/2019 Cairo Course language: English Enroll
28/07/2019 - 01/08/2019 Cairo Course language: English Enroll
29/09/2019 - 03/10/2019 Cairo Course language: English Enroll
01/12/2019 - 05/12/2019 Cairo Course language: English Enroll
Fast Lane will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!