Worth Corner, Crawley, RH10 7SL

Introduction to T-SQL

Target Audience

This course starts with the very basics through to intermediate and is aimed at anyone who has little to no experience with T-SQL.

Required Knowledge

No prior knowledge needed.

Purpose of the Course

The purpose of this course is to provide a firm grounding in T-SQL querying, leaving all attendees with a firm understanding of the structure of a T-SQL query and with the confidence to write good T-SQL code against their servers.

Topics Covered

  • Basic SQL Statements
  • Data Manipulation
  • Joins
  • Aggregation

  • Conditional Statements
  • Sub & Derived Queries
  • Window Functions
  • Data Access Objects

Course Modules

Module 1: What is SQL Server?

  • Brief History of MS SQL Server
  • Version Overview
  • Edition Summary
  • What is T-SQL?

Module 5: Aggregation

  • Group By
  • Having
  • Rollup
  • Cube
  • Pivot

Module 2: Basic T-SQL Commands

  • SELECT / FROM / WHERE
  • IN / LIKE / BETWEEN
  • ORDER BY
  • System Functions
  • String and Data Manipulation

Module 6: Conditional Logic

  • NullIf
  • Case Statement
  • If Statement
  • While

Module 3: Modifying Data

  • INSERT
  • UPDATE
  • DELETE
  • OUTPUT
  • INTO

Module 7: Sub & Derived Queries

  • Definitions
  • IN
  • EXISTS
  • NOT

Module 4: Joins

  • INNER / OUTER
  • Cartesian
  • APPLY
  • UNION
  • INTERSECT / EXCEPT

Module 8: Window Functions

  • Row Number
  • Ranking
  • Cumulative Aggregation
  • Offset

Module 9: Data Access Objects

  • Variables
  • Temporary Tables
  • Views
  • Stored Procedures
  • Functions

Book Course

Sign up for email alerts

Stay current with our latest insights

© Copyright 2020 SQLTraining Ltd.