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.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron