.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaC# training course UKC#.net training course UKvb.net training course UKSQL Server training course UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida
.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk floridaDelphi training course UKASP.net training courseJava training course UKASP.NET training class UK.net c# vb.net delphi sql server asp java coldfusion web developer training course class uk florida

C#.Net training

VB.Net training

SQL Server training

ADO.NET training

ASP.net training

Delphi training

Java training

Web Tech, UK
+44 (0) 1452 814 303

Web Tech, USA


Quick Search:

If you have three or more developers needing this course consider having us customize this course for your specific needs - at your site or ours.

SQL Server Course in UK - SQL Server Class Outline

SQL Server 7.0 Database Implementation
Next Course Dates Call for schedule
Cost / Duration
5 days


Experience using the Microsoft Windows operating system. It is recommended delegates have one year's experience with relational databases, three to six months of SQL Server experience together with an understanding of basic ANSI SQL statements.

Who Should Attend?

This course is aimed at application programmers, database engineers, analysts or other database specialists who require in-depth understanding of SQL Server architecture and advanced facilities together with the skills to implement a database solution using the MS SQL server management system.
Course Benefits

This course provides delegates with technical skills required to implement a database solution with the Microsoft SQL Server relational database management system. The course provides extensive hands-on practical experience covering all the main topics including creating databases, creating indexes, performing advanced queries and summarising data.

You Will Learn How To
  • Create and manage files, file groups, databases, tables and transaction logs
  • Enforce data integrity using constraints, defaults, and rules
  • Plan for appropriate use
  • Create and maintain indexes
  • Write queries that retrieve and modify data using joins and subqueries
  • Write queries that summarise data
  • Manage locking options and transactions to ensure data concurrency and recoverability
  • Create views of data
  • Design & create stored procedures
  • Design and create triggers
  • Work with distributed data

Course Content













SQL Server Overview
What is Microsoft SQL Server? | SQL Server architecture | SQL Server security | SQL Server databases | Working with SQL Server

Overview of Transact - SQL
Microsoft SQL Server programming tools | Transact-SQL programming language | Elements of Transact-SQL | Ways to execute Transact-SQL statements | How queries are processed

Creating Databases
Introduction to databases | Working with databases | Modifying databases | Creating file groups | Library database | Creating data types | Creating tables | Generating scripts

Implementing Data Integrity
Types of data integrity | Enforcing data integrity | Using constraints | Using defaults and rules | Deciding which enforcement method to use

Planning and Creating Indexes
Introduction to indexes | Index architecture | Creating indexes | CREATE INDEX options

Querying Multiple Tables
Combining data from multiple tables | Combining multiple result sets | Creating a table from a result set

Advanced Query Techniques
Introduction to subqueries | Nested subqueries | Correlated subqueries | Using the EXISTS and NOT EXISTS keywords | Modifying data

Summarizing Data
Using aggregate functions | GROUP BY fundamentals | Generating aggregate values within result sets | Using the COMPUTE and COMPUTE BY clauses | Listing the top n values

Managing Transactions and Locks
Introduction to transactions and lock | Managing transactions | SQL Server locking | Managing locks

Working with Distributed Data
Introduction to distributed queries | Executing an ad hoc query on a remote data source | Setting up a linked server environment | Executing a query on a linked server | Executing a stored procedure on a linked server | Modifying data on a linked server | Distributing data

\Implementing Views
What is a view? | Advantages of views | Defining views | Modifying data through views

Implementing Stored Procedures
Introduction to stored procedures | Creating, executing and modifying stored procedures | Using parameters in stored procedures | Executing extended stored procedures | Handling error messages

Implementing Triggers
Introduction to triggers | Defining triggers | Examples of triggers

Advanced Text Queries
Microsoft Search Service | Microsoft English Query

Copyright 1990 - 2013 - WebTech Training & Development - C#.net training vb.net training SQL Server training Delphi training ASP.net training Java training UK


home ] contact ] courses ] register ]