Course code: MOC 20761« Back

Querying Data with Transact-SQL

The main purpose of this 5 day instructor led 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. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.

 DateDurationCourse priceHandbook priceCourse languageLocation 
10/7/2019 5 31 070 CZK included in course price Anglický jazyk GOPAS Praha
 
GTK 10/21/2019 5 31 070 CZK included in course price Český jazyk GOPAS Praha
 
GTK 11/18/2019 5 31 070 CZK included in course price Český jazyk GOPAS Praha
 
1/27/2020 5 31 070 CZK included in course price Český jazyk GOPAS Praha
 
3/30/2020 5 31 070 CZK included in course price Český jazyk GOPAS Praha
 
GTK 5/18/2020 5 31 070 CZK included in course price Český jazyk GOPAS Praha
 
GTK 10/14/2019 5 31 070 CZK included in course price Český jazyk GOPAS Brno
 
2/24/2020 5 31 070 CZK included in course price Český jazyk GOPAS Brno
 
5/11/2020 5 31 070 CZK included in course price Český jazyk GOPAS Brno
 
GTK 11/4/2019 5 875,00 EUR 270,00 EUR Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 31 070 CZK included in course price 50
Brno5 31 070 CZK included in course price 50
Bratislava5 875,00 EUR 270,00 EUR 50

User intensity level

Who the course is for

  • 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; namely, report writers, business analysts and client application developers.

After completing this course, students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2016.
  • 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
  • Use built-in functions
  • Modify data using Transact-SQL
  • 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

Required skills

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

Teaching methods

Expert instruction with practical examples, computer practice

Literature

  • Microsoft Learning (MSL) official student training kit in English
    The student kit contains a book with the presentations used during the course as well as detailed procedures for practical exercises. Excercises usually take at least one third of the time spent on the course
    The student kit also represents a valid license to attend the course. Every student is officially required to have the student kit available for his own use during the course. If the student already owns student kit from a previous training, it is not necessarily required to pay for it again.

Course Outline

Module 1: Introduction to Microsoft SQL Server 2016
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
Module 2: Introduction to T-SQL Querying
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
Module 3: Writing SELECT Queries
  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
Module 4: Querying Multiple Tables
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
Module 5: Sorting and Filtering Data
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values
Module 6: Working with SQL Server 2016 Data Types
  • Introducing SQL Server 2016 Data Types
  • Working with Character Data
  • Working with Date and Time Data
Module 7: Using DML to Modify Data
  • Inserting Data
  • Modifying and Deleting Data
Module 8: Using Built-In Functions
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
Module 9: Grouping and Aggregating Data
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
Module 10: Using Subqueries
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
Module 11: Using Set Operators
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
Elektronická příručka MOC 20761

Price:
8570 CZK
Elektronická příručka MOC 20761

Price:
270 EUR
The prices are without VAT.