Training Course

SQL Querying SQL Databases using T-SQL

PDF
2 Days
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
24 Apr - 25 Apr 2025
Virtual Course
£1995
27 May - 28 May 2025
Virtual Course
£1995
30 Jun - 01 Jul 2025
Virtual Course
£1995
28 Jul - 29 Jul 2025
Virtual Course
£1995
26 Aug - 27 Aug 2025
Virtual Course
£1995
29 Sep - 30 Sep 2025
Virtual Course
£1995

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Prerequisites

    • There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.

Target Audience for this Course

    • IT Professionals who will be writing queries for use with Microsoft SQL Server 2005, 2008, 2012, 2014 and 2016. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.
    • The course is aimed at both non-technical 'power users' and IT Professionals who will be writing queries for use with Microsoft SQL Server.

Included with this course

    • Comprehensive course materials and exercises

SQL Querying SQL Databases using T-SQL Course Content

  • Introduction to T-SQL

    This module provides essential background information on Relational Database Management Systems and Microsoft SQL Server and introduces the main tool that will be used throughout the course - SQL Server Management Studio.
    Familiarize yourself with SSMS
    Introduction to the Query Editor

  • Retrieving Data

    This module describes the fundamental part of a T-SQL query: the SELECT statement.
    Basic Select statements
    Using expressions in Select lists

  • Filtering Rows

    This module describes how you can filter unwanted data out of your results using the WHERE clause.
    Basic equality filters
    Basic comparisons
    Logical comparisons
    String comparisons
    NULL comparisons

  • Sorting returned rows

    This module describes how to use the ORDER BY clause of a query to manage the order in which rows are returned.
    Basic sorting
    Sorting on expressions
    Unique rows
    Limiting results

  • Grouping and Aggregating data

    This module describes how to use the aggregate functions of SQL to calculate results for a number of records at a time and how to group results into a series of values. Finally, it describes how to filter the grouped values.
    Single aggregates
    GROUP BY
    HAVING

  • Using multiple tables

    This module describes how to use JOIN clauses to retrieve data from multiple tables. It also covers the UNION, INTERSECT and EXCEPT keywords
    Inner joins
    Outer joins
    Unions

  • Using Views and Stored Procedures

    This module provides an introduction to the benefits of using pre-written queries which have been stored in the database.
    Using views
    Using stored procedures

  • Common Functions

    This module introduces you to some of the basic text, date and null-value manipulation functions that are built in to SQL Server.
    Text functions
    Date functions
    NULL functions
    Formatting dates

  • Appendix : Modifying Data

    If time allows and if enough delegates express an interest in the topic, this module gives a brief introduction to INSERT, UPDATE and DELETE statements.

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
24 Apr - 25 Apr 2025
Virtual Course
£1995
27 May - 28 May 2025
Virtual Course
£1995
30 Jun - 01 Jul 2025
Virtual Course
£1995
28 Jul - 29 Jul 2025
Virtual Course
£1995
26 Aug - 27 Aug 2025
Virtual Course
£1995
29 Sep - 30 Sep 2025
Virtual Course
£1995

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • SQL Querying SQL Databases using T-SQL Course Options
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Course Reviews
What were the most useful aspects of the course "I felt learning about the pathfinder tool and default options the most useful aspect for me. This will save me a lot of time!"

H.Y. CMP Products British Engines, Adobe InDesign Level 1

"Adele made this course easy to follow and we have learned a lot from today's session."

R.H. , Word Advanced Features

What were the most useful aspects of the course "The one to one undivided attention to areas I needed to improve."

M.B. MGL Group, Telephone Skills

"Great introduction to a piece of software I've not used before"

N.L. Imperial College Healthcare Trust, Prezi Creating Professional Presentations

Following this training what are you going to do differently "I shall start using it more often as I have been using the H Drive."

J.F. London Borough of Merton, SharePoint and Teams Overview

Following this training what are you going to do differently "Stop ruining other colleagues spreadsheets! Joking aside, Ill be better placed to present production figures and pinpoint any trends."

D. James Jones, Excel Level 2

"I feel much happier after sitting the course"

D.G. Stobart rail, Excel Level 1

"Excellent course, well worth doing."

A.P. Siemens, Excel Level 2

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
24 Apr - 25 Apr 2025
Virtual Course
£1995
27 May - 28 May 2025
Virtual Course
£1995
30 Jun - 01 Jul 2025
Virtual Course
£1995
28 Jul - 29 Jul 2025
Virtual Course
£1995
26 Aug - 27 Aug 2025
Virtual Course
£1995
29 Sep - 30 Sep 2025
Virtual Course
£1995

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your SQL Querying SQL Databases using T-SQL course, we have many solutions available to ensure you receive the best training possible.
Your SQL course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible SQL Querying SQL Databases using T-SQL course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master SQL, please contact us to book a place or request a quote for your SQL Querying SQL Databases using T-SQL course.

General Information

Microsoft SQL Server is a registered trademark of the Microsoft Corporation Querying SQL Databases using T-SQL Course available throughout North East England. T-SQL training course in Durham, Newcastle, Sunderland, Gateshead, Darlington, Washington, Middlesbrough and Northumberland.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/22/2025 3:35:24 AM