Computer Technology

   >

Computer Technology 

   >

Querying Data with Transact- SQL

Querying Data with Transact- SQL

Duration (Days)

5

Overview

This course is designed to introduce participants to Transact-SQL. The program will teach them the required knowledge to write DML statements, queries and subqueries. Participants will also learn about the key capabilities and components of SQL server 2016.

Objectives
  • Write DML Statements , queries and subqueries

  • Implement and create views and table-valued functions

  • Use window ranking, offset and aggregate functions to write queries

  • Work with T-SQL, sets and predicate logic

  • Transform data and implement pivot, unpivot, cube and rollup

  • Implement stored procedures

  • Implement programming constructs

  • Write single or multi table SELECT statement

Course Outline
  • Microsoft SQL server 2016

  • T-SQL querying

  • Select queries

  • Multiple tables

  • Filter and sort data

  • SQL sever 2016 data types

  • Data modification

  • Built in functions

  • Data grouping and aggregating

  • Subqueries

  • Table expressions

  • Set operators

  • Windows, ranking, offset and aggregate functions

  • Group and pivot sets

  • Stored procedures

  • T-SQL programming

  • Error management

  • Transactions implementation