Querying Data with Transact-SQL

Asseco Academy » Training » Querying Data with Transact-SQL

Training MS 55366AC

Querying Data with Transact-SQL

IT Solutions Microsoft

Accreditation

Training

Price of training from PLN 3,555 ^net

Lowest price in the last 30 days: PLN 3,555 ^net

Language: polish

*the price depends, among others on the form of training and the date

Download PDF

Additional products

No additional books or exams are specified for this training.

Czas trwania: 40h dydaktycznych

Training description

This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.

Audience Profile

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.

Prerequisites

Basic understanding of relational databases.
Basic Windows knowledge.

At Course Completion

Create single table SELECT queries
Create multiple table SELECT queries
Filter and sort data
Insert, update, and delete data
Query data using built-in functions
Create queries that aggregate data
Create subqueries
Create queries that use table expressions
Use UNION, INTERSECT, and EXCEPT on multiple sets of data
Implement window functions in queries
Use PIVOT and GROUPING SETS in queries
Use stored procedures in queries
Add error handling to queries
Use transactions in queries

Scope

Module 1: Introduction to Transact-SQL
Module 2: Joining tables with Transact-SQL
Module 3: Filtering and sorting results
Module 4: SQL Server data types
Module 5: Inserting, updating and deleting data
Module 6: Using SQL Server functions with Transact-SQL
Module 7: Aggregating data with Transact-SQL
Module 8: Implement subqueries with Transact-SQL
Module 9: Create queries that use table expressions
Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data
Module 11: Implement window functions in queries
Module 12: Use PIVOT and grouping sets in queries
Module 13: Use stored procedures in queries
Module 14: Implement programming features in Transact-SQL
Module 15: Add error handling to queries
Module 16: Use transactions in queries

Training schedule

Remote

… if you value the opportunity to learn with a trainer and other participants, from anywhere without having to commute.

Stationary

… if you want to learn while sitting in the same room with the trainer and other participants.

Online

… if you want to learn from materials available via the interenet anywhere at any time

Filters:

Date guarantee

location:

Training: MS 55366AC

Querying Data with Transact-SQL

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

location:

Training: MS 55366AC

Querying Data with Transact-SQL

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

form:

Training: MS 55366AC

Querying Data with Transact-SQL

Currently, there is no trainings in the selected form.

Szukasz szkolenia w innym terminie?

Co nowego?

Newest
Uncategorized

Dołącz do Membership

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Jak ugryźć innowacyjność

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Nowoczesne metody supportu – testowy wpis

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Chcesz z nami porozmawiać?

Zadzwoń do nas: tel. 801 30 30 30