img

Querying Data with SQL and T-SQL Training Course

Querying Data with SQL and T-SQL

  • $449.00
  • 8 hours
  • Intermediate
  • Instructor Led Online Training
  • Querying Data with SQL and T-SQL training course

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.

Course Dates, Prices & Enrolment

Time Zone:
DatesPrice
Tue 23 Feb 2021 - Tue 04 Mar 2021
06:00 PM - 08:00 PM (ET)
2 Tuesdays & 2 Thursdays (4-day)
$449
Enrol Now
Tue 23 Mar 2021 - Tue 01 Apr 2021
06:00 PM - 08:00 PM (ET)
2 Tuesdays & 2 Thursdays (4-day)
$449
Enrol Now
  1. 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
  2. Multi-Table Queries
    • Joining Tables
    • INNER JOIN
    • INNER JOIN with more than two Tables
    • OUTER JOIN
  3. Grouping Data
    • Using Aggregate Functions
    • Using GROUP BY Clause
    • Using HAVING Clause
    • Aggregate Queries with Multiple Tables
  4. 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
  5. Temporary Tables & Stored Procedures
    • Temporary Tables
    • Populating a Temp table with SELECT INTO
    • Stored Procedures
    • Populating Table from Stored Procedure
    • Using Temp table in a Stored Procedure
A photo of Younus

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).

A photo of Jayan

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.

Shares

Customers Also Bought

Subscribe To Our Onlinesletter

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor