Querying SQL Databases using T-SQL
Book Now - 1 Delivery Method Available:Classroom Virtual Classroom Private Group - Virtual Self-Paced Online
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.
This course will benefit IT Professionals who will be writing queries for use with Microsoft SQL Server 2005, 2008 or 2012. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Introduction to T-SQL (2 topics)
- Familiarize yourself with SSMS
- Introduction to the Query Editor
Retrieving Data (2 topics)
- Basic Select statements
- Using expressions in Select lists
Filtering Rows (5 topics)
- Basic equality filters
- Basic comparisons
- Logical comparisons
- String comparisons
- NULL comparisons
Sorting Returned Rows (4 topics)
- Basic sorting
- Sorting on expressions
- Unique rows
- Limiting results
Grouping and Aggregating Data (3 topics)
- Single aggregates
- GROUP BY
Using Multiple Tables (3 topics)
- Inner joins
- Outer joins
Using Views and Stored Procedures (2 topics)
- Using views
- Using stored procedures
Common Functions (4 topics)
- Text functions
- Date functions
- NULL functions
- Formatting dates
- There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.
- The course is aimed at both non-technical 'power users' and IT Professionals who will be writing queries for use with Microsoft SQL Server.