Book now

MS SQL Server Advanced Course

Course summary

SQL Sub-queries
·Sub-queries in the WHERE, SELECT, From or Having clauses
·Using SOME, ALL, ANY and IN clauses in the Where Clause ·Self-contained sub-queries
·Correlated sub-queries
·Sub-queries with the EXISTS predicate

Derived Tables and CTEs
·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs

Create, alter and drop Views, Indexes

SQL Stored Procedure Basics
·Stored Procedure Principles ·Creating stored procedures ·Executing stored procedures ·System stored procedures

Variables
·Declaring variables ·SET versus SELECT

Parameters and Return Values
·Passing parameters ·Default values and WHERE clauses ·Output parameters ·Using RETURN
Testing Conditions
·The IF/ELSE statement ·CASE ·CHOOSE

Looping
·Syntax of SQL 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

User defined Functions
Table Valued Functions

·In-line table-valued functions ·Multi- Statement table-valued functions ·Limitations of user-defined functions
Scalar Functions
·What are scalar functions? ·Some examples ·Disadvantages of scalar functions ·Three advantages

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

Triggers
Create or replace triggers

Creating Tables in SQL
·Create, alter and drop Tables
·Inserting values, single rows and multiple rows using queries

Constraints:
Not Null
Unique
Default
Check
Primary Key
Foreign Key
Identity / Auto-increments

Sequencing
Indexes

SQL Temporary Tables and Table Variables
·Create and use SQL temporary tables
·Create and use SQL table variables
·SQL Tables vs. Table Variables

Error-Handling
·SQL TRY/CATCH
·SQL System error functions
·Customizing SQL error messages
·@@ error function

Debugging
·The SQL Server debugger, Debugging (breakpoints, etc.)

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Starting How long Where Price

Thu 21st Jun
11:00am - 6:00pm

2 days
Part time day
London,
WC2N 4HS
Map

£700
per course

> Book now

Thu 28th Jun
11:00am - 6:00pm

2 days
Part time day
London,
WC2N 4HS
Map

£700
per course

> Book now

Thu 05th Jul
11:00am - 6:00pm

2 days
Part time day
London,
WC2N 4HS
Map

£700
per course

> Book now

Mon 09th Jul
11:00am - 6:00pm

2 days
Part time day
Manchester,
M2 4PD
Map

£875
per course

> Book now

Thu 12th Jul
11:00am - 6:00pm

2 days
Part time day
London,
WC2N 4HS
Map

£700
per course

> Book now

Mon 16th Jul
11:00am - 6:00pm

2 days
Part time day
Manchester,
M2 4PD
Map

£875
per course

> Book now

Thu 19th Jul
11:00am - 6:00pm

2 days
Part time day
London,
WC2N 4HS
Map

£700
per course

> Book now

Mon 23rd Jul
11:00am - 6:00pm

2 days
Part time day
Manchester,
M2 4PD
Map

£875
per course

> Book now

Thu 26th Jul
11:00am - 6:00pm

2 days
Part time day
London,
WC2N 4HS
Map

£700
per course

> Book now

Mon 30th Jul
11:00am - 6:00pm

2 days
Part time day
Manchester,
M2 4PD
Map

£875
per course

> Book now