Querying Data with SQL and T-SQL

Regular Price: £200
Batch Price: From £200   📅 View Dates & Prices
Group Booking Discount: From £100 per person  🧮 Calculate & Book
1-to-1 Training: £250  📋 Booking Request Form

Course Overview

This course is intended for them who need to write queries to retrieve data from the Microsoft SQL Server. This course is highly recommended before starting our SQL Server Reporting Services (SSRS) course. At the end of this course the course attendees should be able to use SQL and T-SQL for querying data.

Following topics are included in this course:

Built-In Functions
Subqueries
Multi-Table Queries
Grouping Data
Aggregate Queries with Multiple Tables

Requirements

This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, basic SQL and T-SQL. Our Database Design with Microsoft SQL Server Training Courses cover all of the prerequisites.

Course Content

Built-In Functions
- Using Built-In Functions
- ISNULL – A System Function
- CONVERT – A Conversion Function
- ROUND: A Mathematical function
- Using String Functions
  - SUBSTRING
  - LEFT & RIGHT
- Using Date and Time Functions
  - GETDATE
  - DATEADD
  - DATEDIFF
  - DATENAME
  - DATEPART
  - DAY, MONTH and YEAR
  - Using CONVERT to format a date/time
Subqueries
- Introduction of Subqueries
- Subqueries vs Joining Tables
- Subqueries with Comparison Operators
- Subqueries with IN and NOT IN Operators
- Subqueries with EXISTS and NOT EXISTS
Multi-Table Queries
- Joining Tables
- INNER JOIN
- INNER JOIN with more than two Tables
- OUTER JOIN
Grouping Data
- Using Aggregate Functions
- Using GROUP BY Clause
- Using HAVING Clause
- Aggregate Queries with Multiple Tables

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Scroll right for more details

There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later.

Note: Online classes are usually delivered through Zoom video conferencing.

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

book a course on different dates
book for a group of delegates
book corporate training

book a customised training
book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

How many hours?

How many people?

Total Cost

Price per person

Preferred Dates and Times

Any other information