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

Cadbury World + Warwick-castle
Wed, 29 Oct at 09:00 am Cadbury World + Warwick-castle

Cadbury World

Cadbury World + Legoland Discovery Centre Birmingham
Wed, 29 Oct at 09:00 am Cadbury World + Legoland Discovery Centre Birmingham

Cadbury World

Active Communities, Healthier Futures - SPARC 2025
Wed, 29 Oct at 09:00 am Active Communities, Healthier Futures - SPARC 2025

McIntyre House (University College Birmingham)

SPORTS BUSINESS
Legoland Discovery Centre Birmingham + Warwick Castle + Cadbury World
Wed, 29 Oct at 09:30 am Legoland Discovery Centre Birmingham + Warwick Castle + Cadbury World

Barclaycard Arena

KIDS
Standard Admission - Peak
Wed, 29 Oct at 09:30 am Standard Admission - Peak

Utilita Arena

Legoland Discovery Centre + Sea Life Birmingham
Wed, 29 Oct at 09:30 am Legoland Discovery Centre + Sea Life Birmingham

Utilita Arena

KIDS
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
Birmingham  STEM Women Graduate Careers Event
Wed, 29 Oct at 01:00 pm Birmingham STEM Women Graduate Careers Event

Edgbaston Stadium

WORKSHOPS JOB-FAIRS
Birmingham Network: Tech Startups, Professionals & Investors Connect Event
Wed, 29 Oct at 06:00 pm Birmingham Network: Tech Startups, Professionals & Investors Connect Event

The Cocktail Club - Cocktail Bar in Birmingham

BUSINESS PHOTOGRAPHY
BTW Club - Whoop Night - 29th October
Wed, 29 Oct at 06:00 pm BTW Club - Whoop Night - 29th October

Cuttle Bridge Inn

SPORTS WORKSHOPS
October Brum Indies Gamedev Meetup
Wed, 29 Oct at 07:30 pm October Brum Indies Gamedev Meetup

Cherry Red's Cafe Bar

MEETUPS SPORTS
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

What's Happening Next in Birmingham?

Discover Birmingham Events