Home » Training Courses » Programming & Networking Training » SQL Server Training

SQL Server Training

3 days - please call for a quote

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

SQL Server Training Course Objectives

• This 3-day SQL Server training course provides clients with a good working knowledge of SQL Server & Transact SQL.
• Upon completion of this SQL Server training course, the delegate will be familiar with the usage of SQL Server in the implementation of robust relational databases.

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 Training Course Prerequisites

For this SQL server training course delegates will need:

• Experience of working with databases in a commercial environment e.g. VB – ActiveX or ASP/ADO
• Good knowledge of at least one programming/scripting language, preferably Microsoft e.g. VBScript, VBA, VB

SQL Server Training Course Recommended Reading

SQL Pocket Guide - Jonathan Gennick – buy from amazon    
SQL Server 2008 Query Performance Tuning Distilled by G; Dam, S Fritchey - buy from amazon

Download course outline as pdf.