Querying Data with SQL and T-SQL course

Querying Data with SQL and T-SQL

$270.00
5 hours
Intermediate
Instructor Led Online Training

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
Multi-Table Queries
Grouping Data
Subqueries
Temporary Tables & Stored Procedures

Skills Required

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.

Booking Request

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 you want book?

Booking for how many people?

Here is the total cost of booking:

Price per person for this course:

Preferred Dates and Times

Any other information

You must need to Register / Sign In first to submit this booking request form.

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
Stored Procedures
- Introduction of Stored Procedures
- Creating and Using a Stored Procedure

Younus Kazi

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He is also a Microsoft Certified Application Developer (MCAD).

Jayan Karmacharya

Jayan is an Experienced Web Developer and IT tutor with over 10 years of experience in Server side programming, front-end development, database design, web server management and, IT instruction. Having Master of Science in Information Technology Degree and Microsoft certified Programming in HTML5 with JavaScript and CSS3.

Related Courses

Programming With C# for Beginners

$420
SQL Server Reporting Services (SSRS)

$280
Data Warehouse Design with Microsoft SQL Server and SSIS

$280
SQL for Beginners

$280

Querying Data with SQL and T-SQL Training Course