TSQL for Beginners or Data Analysts Training Course

TSQL for Beginners or Data Analysts Training Course

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

T-SQL for Beginners or Data Analysts Training Course Agenda

T-SQL Introduction
  • SQL Server Management Studio
  • Creating Tables
  • Naming Conventions
  • Data Types
Transact-SQL
  • SELECT
  • FROM
  • WHERE
  • GROUP BY
  • ORDER BY
  • and lastly HAVING (not in the right order!)
Expressions
  • CASE statements
  • LIKE
  • Functions (lots of them)
  • Date and Time
Join Us
  • Cross
  • Inner
  • Outer
  • 1-to-Many
  • Many-to-Many
  • Union
  • Union All
Database Objects
  • Stored Procedures
  • Views
  • Calling them and where to use them?
  • Why to use them?
  • Examples
Adding More Data
  • INSERT
  • DELETE
Control of Flow
  • IF
  • WHILE
  • Cursors
  • Loops
It’s all Temporary
  • 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!

You Might Also Like…

New Features of SQL Course
Advanced TSQL Course
Beginners SQL DBA Course
Installing SQL Server Training
Data Warehouse Training
SSRS Training Course
Power BI Training Course

 

Summary
TSQL for Beginners or Data Analysts Training Course
Service Type
TSQL for Beginners or Data Analysts Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
Learn how to write effective SQL statements from the ground up in this TSQL for Beginners 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.