Short course on Microsoft SQL Server Database Designing Course level: Intermediate
Total Duration: 10 Hours
Delivery Method: Instructor Led Classroom 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

Certification:
Certificate of Completion will be provided after completing the course

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 MethodDatesPriceEnrol
Classroom Training 26 Jun 2018 - 28 Jun 2018
Tuesday & Thursday
£220Enrol Now
Classroom Training 07 Jul 2018 - 14 Jul 2018
2 Saturdays
£220Enrol Now
Classroom Training 17 Jul 2018 - 19 Jul 2018
Tuesday & Thursday
£220Enrol Now
Classroom Training 23 Jul 2018 - 01 Aug 2018
2 Mondays & 2 Wednesdays
£220Enrol Now
Classroom Training 14 Aug 2018 - 16 Aug 2018
Tuesday & Thursday
£220Enrol Now
Classroom Training 25 Aug 2018 - 01 Sep 2018
2 Saturdays
£220Enrol Now
Classroom Training 28 Aug 2018 - 06 Sep 2018
2 Tuesdays & 2 Thursdays
£220Enrol Now
Classroom Training 18 Sep 2018 - 20 Sep 2018
Tuesday & Thursday
£220Enrol Now
Classroom Training 06 Oct 2018 - 13 Oct 2018
2 Saturdays
£220Enrol Now
Classroom Training 10 Nov 2018 - 17 Nov 2018
2 Saturdays
£220Enrol 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

Course Tutor

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 upto 25% by booking this course with other related courses as shown below:

Microsoft SQL Server Immersive

£840 (save £100)

This package combines
Find out more & book now

SQL and T-SQL Immersive

£450 (save £50)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?