SQL Training | SQL Exam

Course

In Cardiff

£ 1,195 + VAT

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    2 Days

  • Start date

    Different dates available

The Knowledge Academy Courseware Book Manual Certificate Experienced Instructor Refreshments

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

  • Global
  • Syntax
  • Visual Studio
  • Testing
  • Server
  • IT
  • Approach
  • SQL

Course programme

The Knowledge Academy Advanced SQL 2 day course covers the following topics:

This two day course assumes that you know how to query data using SQL, and shows you how to really progam in SQL Server

Course Content

Stored Procedure Basics

  • Pros and cons of stored procedures
  • Creating stored procedures
  • Three ways to execute
  • System stored procedures

Variables

  • Declaring variables
  • SET versus SELECT
  • Tricks with variables and rowsets
  • So-called global variables

Parameters and Return Values

  • Passing parameters
  • Default values and WHERE clauses
  • Output parameters
  • Using RETURN

Avoiding Scalar Functions

  • What are scalar functions?
  • Some examples
  • Disadvantages of scalar functions
  • Three alternatives

Testing Conditions

  • IF / ELSE statement
  • Using CASE where possible

Looping

  • Syntax of WHILE
  • Breaking out of a loop
  • Basic transactions
  • Beginning a transaction
  • Committing / rolling back
  • Deleting and updating
  • Using DELETE and UPDATE
  • Sys.Objects
  • Dropping objects

Creating Tables

  • Creating tables in SQL
  • Inserting data
  • Inserting single rows
  • Inserting multiple rows

Temporary Tables and Table Variables

  • Using temporary tables
  • Creating table variables
  • Pros and cons of each approach

Table Valued Functions

  • In-line table-valued functions
  • Mult-statement table-valued functions
  • Limitations of user-defined functions

Derived Tables and CTEs

  • Using dervied tables
  • Common Table Expressions (CTEs)
  • Recursive CTEs

Subqueries

  • The concept of a subquery
  • Using ALL, ANY and IN
  • Correlated subqueries
  • Using EXISTS

Cursors

  • Syntax of fetching rows
  • When to use (and when not to)

Error-Handling

  • Using TRY / CATCH
  • System error functions
  • Custom error messages
  • The obsolete @@error function

Debugging

  • Version differences
  • The Visual Studio debugger
  • The SQL Server debugger
  • Debugging (breakpoints, etc.)

Additional information

  • Recommended for those who are already familiar with SQL
  • Develop knowledge on analysing applications on the network
  • Some previous programming or database experience would be useful
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Learn about mult-statement table-valued functions
  • Courses delivered by world class training instructors in luxury venues
  • Advanced SQL includes material and manuals
  • Book Online or Call 01344 203999 to speak to a training advisor today

SQL Training | SQL Exam

£ 1,195 + VAT