Course Description

Course Code : IT013

This course is designed for delegates requiring an understanding of MS SQL database


Course Objectives

Understand the principles MS SQL.

Be familiar with robust database design.

Be able to build a medium size SQL database.

Maintain an SQL database.

Course Features

  • Principles of good database design.
  • Structure of an MS SQL database.
  • Basics of SQL Query Language.
  • Tables & Forms, Reports, Stored Procedures & Views, Using Triggers.
  • Basics of database maintenance.
  • Reducing redundancy.
  • Fault Finding.

 

  • At the end of the course each participant will:
  • Be familiar with robust database design.
  • Understand the principles MS SQL.
  • Be able to build a medium size SQL database.
  • Maintain an SQL database.