SQL Server training course

SQL Server training – 3 days – private courses from £2175 + vat

SQL Server training uk

SQL Server is Microsoft's flagship relational database application. This three-day SQLServer training course provides a grounding in relational database design methodology and in its practical application using SQL Server.

SQL Server Training Course Objectives

SQL Server Training Course Content

Principles of database design

A series of presentations and exercises exploring the major aspects of robust relational database design. This section considers:

  • Requirements Capture methodology
  • Normalisation
  • Keys
  • Relationships
  • Business rules
  • Views
  • Data integrity
  • Database modelling

Introduction to SQL Server

This section explores the user interface. The menus, tools and wizards provided by SQL Server. Using examples and exercises, this section considers:

  • Database, table and field creation
  • Security considerations
  • SQL Server Query Analyser
  • Stored Procedures
  • Indexes
  • Triggers
  • The T-SQL language
  • This section also includes an overview of Structured Query Language

Hands On

The theories and skills explored in the previous sections are put into practice. In this section, delegates will design and build a relational database based upon a Case Study.

SQL Server Course Prerequisites

For this SQL server training course delegates will need:

SQL Server Training Recommended Reading

Inside SQL Server 2000 - Kalen Delaney – buy from amazon
SQL Server 2000 Standard Edition 5 – buy from amazon

Programming Training UK

Up