Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

 SQL for SQL Server

  Course Code: GN-331  Duration: 3 Days

This course is designed for developers wishing to exploit SQL in a Microsoft SQL Server environment. The course most often lasts for 3 days but shorter versions can be provided. The full 3-day overview is given below. While we normally use the latest version, older versions of SQL server from 2000 onwards can be supported. The course is highly practical including many exercises which can be adapted to follow your real-world requirements. An additional day covering the spatial types (geometry and geography) is also available.


 Course Outline



  • Relational Databases.
  • IDs and Keys.
  • Primary and Foreign Keys.
  • Entity-Relationship Modelling - ERM. T-SQL.
  • How SQL Server Works.
  • System Databases.
  • SQL Server Management Studio.
  • SQL Server Configuration Manager.
  • Other Tools.

Tables and Data Types

  • Naming Objects.
  • Designing a Table.
  • Creating a Database.
  • Database Files.
  • Storing Scripts.
  • Data Types - Integers.
  • Non-Integer Numeric Types.
  • Characters and Text.
  • Other Main Data Types.
  • Identity Columns.
  • Setting the Primary Key.
  • Nulls.
  • Altering a Table.
  • Dropping Columns and Tables.
  • User Defined Data Types.

Selecting Data

  • The Select Statement.
  • Selecting Columns.
  • Ordering.
  • Aliases.
  • Combining Columns.
  • Distinct.
  • Filtering Using Where.
  • Using Not, And and Or.
  • Matching using Like.
  • Between and In.

Joins and Constraints

  • Relationships.
  • Using Foreign Keys.
  • Inner Joins.
  • Outer Joins.
  • Disambiguation and abbreviation.
  • Foreign Key Constraints.
  • Database Diagrams.
  • Relationship Properties.
  • Cascading on Update or Delete.
  • Default, Unique and Check Constraints.
  • Disabling Constraints.


  • Aggregate Functions.
  • Group By and Having.
  • Having and Where.
  • Rollup, Cube and Grouping Sets.
  • Dates and Times.
  • The Convert Function.
  • String Functions.

Action Queries

  • Insert Into.
  • Delete.
  • Update.
  • Updating Multiple Rows.
  • Insert ... Select.
  • Select Into.


  • Simple sub-queries.
  • Sub queries using multiple items.
  • Correlated sub-queries.
  • Exists and Not Exists.

Views and Triggers

  • Creating and Using Views.
  • Views Involving Multiple Tables.
  • Inserting via a View.
  • Triggers.
  • The Trigger SQL.
  • Temporary Tables.

Stored Procedures and Functions

  • What is a Stored Procedure?
  • Creating a Stored Procedure.
  • Calling the Procedure.
  • Passing Parameters.
  • Returning a Value.
  • Using an Output Parameter.
  • Scalar-Valued Functions.
  • Table-Valued Functions.
  • A Function as a Parameterized View.
  • Multi-Statement Table-Valued Functions.
  • Error Handling.
  • T-SQL as a Programming Language.


  • Index Structure.
  • Clustered and Non-Clustered Indexes.
  • Query Analysis.
  • Indexes and Primary Keys.
  • Covering a Query.

Transactions and Locks

  • Using Transactions.
  • Savepoints.
  • Nested Transactions.
  • Transaction Isolation Levels.

© Beckinridge Ltd.

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development