Training Microsoft

Training goals

code: MS-55366 | version: A

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.

After completing the course, student knows how to:

  • 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

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.

Conspect Show list

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

Additional information

Prerequisites
  • Basic understanding of relational databases.
  • Basic Windows knowledge.
Difficulty level
Duration 5 days
Certificate

Certificate of completing an authorized Microsoft training

Trainer

Microsoft Certified Trainer

Other training Microsoft | Microsoft SQL Server

Contact form

Please fill form below to obtain more info about this training.







* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

2300 EUR

FORM OF TRAINING ?

 

TRAINING MATERIALS ?

 

SELECT TRAINING DATE

    • General information
    • Guaranteed dates
    • Last minute (-10%)
    • Language of the training
    • English
Book a training appointment
close

Traditional training

Sessions organised at Compendium CE are usually held in our locations in Kraków and Warsaw, but also in venues designated by the client. The group participating in training meets at a specific place and specific time with a coach and actively participates in laboratory sessions.

Dlearning training

You may participate from at any place in the world. It is sufficient to have a computer (or, actually a tablet, or smartphone) connected to the Internet. Compendium CE provides each Distance Learning training participant with adequate software enabling connection to the Data Center. For more information, please visit dlearning.eu site

close

Paper materials

Traditional materials: The price includes standard materials issued in the form of paper books, printed or other, depending on the arrangements with the manufacturer.

Electronic materials

Electronic materials: These are electronic training materials that are available to you based on your specific application: Skillpipe, eVantage, etc., or as PDF documents.

Ctab materials

Ctab materials: the price includes ctab tablet and electronic training materials or traditional training materials and supplies provided electronically according to manufacturer's specifications (in PDF or EPUB form). The materials provided are adapted for display on ctab tablets. For more information, check out the ctab website.