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

PCWorkshops

Host or Publisher PCWorkshops

It's more fun with friends. Share with friends

Discover More Events in Birmingham

Norma Jean, Horse The Band, For Your Health in Birmingham
Sat, 04 Oct at 10:15 pm Norma Jean, Horse The Band, For Your Health in Birmingham

WORKPLAY

MUSIC ENTERTAINMENT
Portrait Freshers Special
Sat, 04 Oct at 10:30 pm Portrait Freshers Special

Portrait Birmingham

BOLLYWOOD-PARTIES
2FACE IDIBIA LIVE IN BIRMINGHAM (NIGERIA INDEPENDENCE SPECIAL) #FLAUNT
Sat, 04 Oct at 11:00 pm 2FACE IDIBIA LIVE IN BIRMINGHAM (NIGERIA INDEPENDENCE SPECIAL) #FLAUNT

Cave

PARTIES ENTERTAINMENT
2BABA PERFORMING LIVE - NIGERIA INDEPENDENCE DAY SPECIAL
Sat, 04 Oct at 11:55 pm 2BABA PERFORMING LIVE - NIGERIA INDEPENDENCE DAY SPECIAL

Cave

ENTERTAINMENT PERFORMANCES
The Arc @ The Drakes Drum, Great Barr
Sun, 05 Oct at 05:00 am The Arc @ The Drakes Drum, Great Barr

The Drakes Drum

Bushi Judo Club Annual Championship
Sun, 05 Oct at 09:00 am Bushi Judo Club Annual Championship

National Event Centre Erdington Academy Kingsbury Rd Birmingham B24 8RE

SPORTS
Qigong \u2013 Cultivate Your Core Energy
Sun, 05 Oct at 09:00 am Qigong – Cultivate Your Core Energy

Therapy & Flow

HEALTH-WELLNESS WORKSHOPS
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
Reef Birmingham
Fri, 24 Jan Reef Birmingham

O2 Institute Birmingham

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
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
International AI Symposium 2025: AI FOR GOOD
Wed, 08 Oct at 09:00 am International AI Symposium 2025: AI FOR GOOD

Conference Aston - Hotel and Conference Centre

BUSINESS ARTIFICIAL-INTELLIGENCE
Canon Professional Print Range Workshop: Birmingham
Wed, 08 Oct at 10:00 am Canon Professional Print Range Workshop: Birmingham

Canon (UK) Ltd - Office and Showroom

WORKSHOPS ART
Cyber Security & Assurances: Stay Secure
Wed, 15 Oct at 04:00 pm Cyber Security & Assurances: Stay Secure

The Metro Club

BUSINESS
Network One: MedTech Founders & Innovators Meetup Birmingham
Wed, 15 Oct at 06:00 pm Network One: MedTech Founders & Innovators Meetup Birmingham

The Cocktail Club - Cocktail Bar in Birmingham

HEALTH-WELLNESS BUSINESS
Birmingham Network: Tech Startups, Professionals & Investors Connect Event
Wed, 15 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 - 15th October
Wed, 15 Oct at 06:00 pm BTW Club - Whoop Night - 15th October

Cuttle Bridge Inn

SPORTS WORKSHOPS

What's Happening Next in Birmingham?

Discover Birmingham Events