SQL Training – SQL Server Stored Procedure

The Knowledge Academy

Course

In Cardiff

£ 2,995 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    1 Day

  • Start date

    Different dates available

The Knowledge Academy Writing Stored Procedures 1 day course covers the following topics:

Introduction

Participants of this course will be introduced to the best practices for building simple stored procedures and will be provided with the opportunity to gain hands-on experience of handling programming errors.

Facilities

Location

Start date

Cardiff
See map
Castle Street, CF10 1SZ

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • Server
  • IT
  • SQL
  • Writing
  • Programming
  • IF-ELSE
  • WHILE
  • Variables
  • Parameters
  • Querying

Course programme

Prerequisites

Candidates should be familiar with basic SQL queries.

Who should attend?

This course is ideal for technical users and developers who need to understand how to build stored procedures that retrieve and modify data.

What will you learn?

  • How to build stored procedures that retrieve and modify data
  • How to implement IF-ELSE, WHILE and BEGIN-END blocks
  • How to manipulate variables and parameters

Course Outline

  • Techniques for building simple stored procedures
  • Methods for using procedural extensions to Transact-SQL
  • Implementing IF-ELSE, WHILE and BEGIN-END blocks
  • Declaring local variables
  • Declaring input/output parameters
  • Techniques for handling programming errors

Additional information

Comprehensive overview of the techniques for building simple stored procedures Understand how to code a simple retrieval procedure Use new skills to handle errors such as primary and foreign key violations GUARANTEED LOWEST PRICE IN THE INDUSTRY Courses delivered by world class training instructors Training provided in luxury venues Includes material and manuals

See related categories

SQL Training – SQL Server Stored Procedure

£ 2,995 + VAT

The best SQL Server courses

See all

See all