Learn how to write effective SQL statements from the ground up in this TSQL Training Course.  Understand the set paradigm, right from the start.  No experience is necessary to go to a good level with good explanations and lots of examples. This course can be 1 day to 3 days depending on your level of expertise, you decide

Learning Outcomes 

Set theory, then lots of examples about selecting and filtering data.  Joining data and more difficult TSQL topics covered, examples of stored procedures and view

Course Requirements

Beginners or Refreshing Users of TSQL, Data Analysts, wanting to get more out of T-SQL

Course Length

2-days

• SQL Server Management Studio
• Creating Tables
• Naming Conventions
• Data Types

• SELECT
• FROM
• WHERE
• GROUP BY
• ORDER BY
• and lastly HAVING (not in the right order!)

• CASE statements
• LIKE
• Functions (lots of them)
• Date and Time

• Cross
• Inner
• Outer
• 1-to-Many
• Many-to-Many
• Union
• Union All

• Stored Procedures
• Views
• Calling them and where to use them?
• Why to use them?
• Examples

• INSERT
• DELETE

• IF
• WHILE
• Cursors
• Loops

• Derived Tables
• Temporary Tables
• Table Variables
• Benefits and downsides

Course Price

This course costs £900 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!