Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019
Special, in person, One Day Sessions...
 Pinal Dave
16thand 17th May 2019

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