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

SQL Server Training

3 days - please call for a quote

SQL Server Training

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 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 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.