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
- 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 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 Recommended Reading
Inside SQL Server 2000 - Kalen Delaney – buy from amazon
SQL Server 2000 Standard Edition 5 – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Programming Training UK
Up