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.

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.

 

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

"The whole course in general was very good"

S.M. Bilfinger UK, PowerPoint Essentials

"Everything was useful and delivered very well."

B.W. Tyne Wear Fire Rescue Service, Excel Level 2

Which part of the course did you find particularly valuable "How to deal with responding to clients difficult scenarios "

S.T. TLW Solicitors, Managing Difficult Conversations

Which part of the course did you find particularly valuable "All of it from start to finish :"

M.A. , Word Advanced Features

"Very nice approach and teacher style"

L.H. SchlegelGiesse, Excel Level 1

Following this training what are you going to do differently "Design frames and images better. Using templates and master pages more efficiently."

M.L. NIHR Clinical Research Network, Adobe InDesign Level 1

Following this training what are you going to do differently "Lots! Lots of little shortcuts to remember and use, I will definitely apply all that I've learnt, I knew the basics of many of the functions but great to get more training on them from a pro because I am mainly self taught."

V.K. , Excel Level 3

How would you rate the course content overall "Given very helpful and useful guidance "

S.O. Railway Housing Association, Customer Care Dealing with Difficult and Aggressive Behaviour

 

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:1/14/2025 4:31:51 PM