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.
Courses run on a regular basis – contact us via firstname.lastname@example.org or call 0845 519 7408 for dates and prices.
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.
Please note – Delegates attending an Extended Classroom delivery will need access to a second monitor.
- There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.
Querying SQL Databases using T-SQL Training outline
Module 1: 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
Module 2: Retrieving Data
This module describes the fundamental part of a T-SQL query: the SELECT statement.
- Basic Select statements
- Using expressions in Select lists
Module 3: 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
Module 4: 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
Module 5: 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
Module 6: 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
Module 7: 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
Module 8: 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.
Querying SQL Databases using T-SQL Training Courses run on a regular basis – contact us via email@example.com or call 0845 519 7408 for dates and prices.