• An Introduction To T-SQL

  • 2 Day Course  |  £795.00 (+VAT)

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 Requirements

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 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 2: Basic T-SQL Commands

  • SELECT
  • WHERE
  • IN / LIKE / BETWEEN
  • ORDER BY
  • DISTINCT
  • Built in Functions
  • String and Data Manipulation

Module 3: Modifying Data

  • INSERT
  • UPDATE
  • DELETE
  • OUTPUT
  • INTO

Module 4: Joins

  • INNER
  • OUTER
  • CROSS
  • APPLY
  • UNION
  • INTERSECT
  • EXCEPT

Module 5: Aggregations

  • Group By
  • Having
  • Rollup
  • Cube
  • Pivot

Module 6: Conditional Logic

  • NullIf
  • Case
  • If statement
  • While

Module 7: Sub & Derived Queries

  • IN
  • EXISTS

Module 8: Window Functions

  • Row Number
  • Ranking
  • Cumulative Aggregation
  • Offset

Module 9: Data Access Objects

  • Variables
  • Temporary Tables
  • Views
  • Stored Procedures
  • Functions
  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.