Short course on Microsoft SQL Server Database Designing Regular Course Price: £150.00   
Total Duration: 5 Hours
Course level: Intermediate
Delivery Method: Instructor Led Online Training
Certification: Certificate of Completion will be provided after completing the 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

Training
Method
Dates and Times
(in the UK)
Dates and Times
(if not in the UK)
Price 
Online Training using Zoom 14 Apr 2021 - 16 Apr 2021
Wednesday & Friday
11am - 1:30pm
Start Date & Time
End Date & Time
£150
Enrol Now
Online Training using Zoom 11 May 2021 - 13 May 2021
Tuesday & Thursday
11am - 1:30pm
Start Date & Time
End Date & Time
£150
Enrol Now
Online Training using Zoom 15 Jun 2021 - 17 Jun 2021
Tuesday & Thursday
11am - 1:30pm
Start Date & Time
End Date & Time
£150
Enrol Now
Online Training using Zoom 20 Jul 2021 - 22 Jul 2021
Tuesday & Thursday
11am - 1:30pm
Start Date & Time
End Date & Time
£150
Enrol Now
Online Training using Zoom 24 Aug 2021 - 26 Aug 2021
Tuesday & Thursday
11am - 1:30pm
Start Date & Time
End Date & Time
£150
Enrol Now

Full Course Outline

  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

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:

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

Course Tutors

The course instructor is a .NET developer with 15 years of experience in software and web development. He is a Microsoft Certified Application Developer and skilled on C#, ASP.NET, Microsoft SQL Server, Ajax, HTML, and CSS.

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

Newsletter Sign-up

Have a Question?