MS SQL Server Advanced 2-Day Course, Birmingham

Schedule

Thu, 02 Aug, 2018 at 11:00 am to Thu, 30 Oct, 2025 at 05:00 pm

UTC+01:00

Location

One Victoria Square | Birmingham, EN

Advertisement
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 predicateDerived Tables and CTEs ·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs Create, alter and drop Views, IndexesSQL 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.)
Advertisement

Where is it happening?

One Victoria Square, Birmingham, United Kingdom

Event Location & Nearby Stays:

Tickets

GBP 431.79 to GBP 1401.99

Icon
Know what’s Happening Next — before everyone else does.
PCWorkshops

Host or Publisher PCWorkshops

Ask AI if this event suits you:

Discover More Events in Birmingham

Nightingale Club Thursdays
Thu, 30 Oct at 10:00 pm Nightingale Club Thursdays

Nightingale Club

ENTERTAINMENT DANCE
Baddies Nation
Thu, 30 Oct at 10:00 pm Baddies Nation

Savanna Restaurant & Cocktail Bar

HALLOWEEN ART
\ud83d\udc24SCARY DUCK\ud83d\udc24 POPWORLD BIRMINGHAM THURSDAY 30-10-25 HALLOWEEN EVE
Thu, 30 Oct at 10:00 pm 🐤SCARY DUCK🐤 POPWORLD BIRMINGHAM THURSDAY 30-10-25 HALLOWEEN EVE

Popworld - Birmingham

HALLOWEEN ART
BOLLYWEEN BASH
Thu, 30 Oct at 10:00 pm BOLLYWEEN BASH

King of clubs

ART NONPROFIT
 \ud83e\udde1 VODBULL HALLOWEEN HORRORBULL \ud83d\udc7b at ROSIES!! 30\/10
Thu, 30 Oct at 10:30 pm 🧡 VODBULL HALLOWEEN HORRORBULL 👻 at ROSIES!! 30/10

Rosies

ENTERTAINMENT HALLOWEEN
SNOBS X Naughty Horse Halloween Eve [Final Tickets]
Thu, 30 Oct at 10:30 pm SNOBS X Naughty Horse Halloween Eve [Final Tickets]

Snobs

HALLOWEEN PARTIES
Drippin x Halloween - LAB11
Thu, 30 Oct at 11:00 pm Drippin x Halloween - LAB11

LAB11

ENTERTAINMENT DANCE
MS SQL Server Advanced 2-Day Course, Birmingham
Thu, 02 Aug at 11:00 am MS SQL Server Advanced 2-Day Course, Birmingham

One Victoria Square

WORKSHOPS
Canon imagePROGRAF PRO-300\/310 Print Workshop: Birmingham
Tue, 05 Aug at 10:00 am Canon imagePROGRAF PRO-300/310 Print Workshop: Birmingham

Canon (UK) Ltd - Office and Showroom

WORKSHOPS ART
Canon imagePROGRAF PRO-1000\/1100 Workshop: Birmingham
Wed, 06 Aug at 10:00 am Canon imagePROGRAF PRO-1000/1100 Workshop: Birmingham

Canon (UK) Ltd - Office and Showroom

WORKSHOPS ART
PRINCE2 Course | Training and Exams | Birmingham, ENG
Sat, 23 Aug at 09:00 am PRINCE2 Course | Training and Exams | Birmingham, ENG

Spaces - Birmingham, Lewis Building

WORKSHOPS NONPROFIT
Cyber Security Essentials: 1 Day Overview Workshop in Birmingham
Tue, 09 Sep at 09:00 am Cyber Security Essentials: 1 Day Overview Workshop in Birmingham

For venue details, reach us at [email protected]

WORKSHOPS BUSINESS
Digital Skills  Training with Solihull College (North Solihull)
Tue, 23 Sep at 01:00 pm Digital Skills Training with Solihull College (North Solihull)

Solihull Recruitment & Training Centre, B37 5TS

WORKSHOPS
Cyber Security Breakfast Hosted by BT Local Business
Thu, 30 Oct at 08:00 am Cyber Security Breakfast Hosted by BT Local Business

BT PLC

BUSINESS WORKSHOPS
Bredent Customer Conference
Fri, 31 Oct at 09:30 am Bredent Customer Conference

Edgbaston Park Hotel Birmingham

BUSINESS CONFERENCES
Reform UK: Birmingham Business Engagement Dinner
Tue, 04 Nov at 06:00 pm Reform UK: Birmingham Business Engagement Dinner

Hyatt Regency Birmingham

BUSINESS HEALTH-WELLNESS
Birmingham Network: Tech Startups, Professionals & Investors Connect Event
Wed, 05 Nov at 06:00 pm Birmingham Network: Tech Startups, Professionals & Investors Connect Event

The Lost & Found Birmingham

BUSINESS PHOTOGRAPHY
Rise & Shine: South & City College Innovation Hub - Business Networking
Thu, 06 Nov at 08:30 am Rise & Shine: South & City College Innovation Hub - Business Networking

ibis Birmingham New Street Station

BUSINESS WORKSHOPS
NABERS IDR Approval Process
Thu, 06 Nov at 04:30 pm NABERS IDR Approval Process

Cundall

ART

What's Happening Next in Birmingham?

Discover Birmingham Events