Course Description

Course Code : ITEC0040

This course is designed for delegates requiring an understanding of designing and developing a Microsoft SQL Server database. Topics including tables and table relations, Transact-SQL queries, Views and Stored procedures are covered.

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