Advance SQL
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