Advance SQL
Starting DateApril 20, 2022
DurationOne Day
LocationOnline
CertificateN/A
CostTo Be Confirmed
Course code9009

Programme Overview

The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.

Learning Outcome

• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

Who is this course for

  • Delegates should be familiar with the Microsoft SQL Server SQL Language

Modules

Modules to include;

  • How to create and maintain an index
  • Use of Rollup
  • Use of Cube
  • Use of ranking functions

Trainer Profile

Applications Closing on13th April 2022