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.)
Information Source: PCWorkshops | eventbrite

London

United Kingdom

Searching for information and tickets regarding MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square taking place in London on Apr 29, 2025 (UTC+1)? Trip.com has you covered. Check the dates, itineraries, and other information about MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square now! Trip.com has also prepared more similar exciting activities and discounted flight and hotel packages.

MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square: Tickets, Dates & Itineraries | Trip.com

MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square

MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | Trip.com

null | Trip.com

Share your results and see what your friends think!

Claridge's, Maybourne Hotel Collection

Cultural Hotels

The Dorchester

Luxury Hotels

Westminster Abbey

Book now for tomorrow

Best Things to Do

Night view

M33***70

It is definitely worth going. You can deeply feel the profound British culture and the importance Britain attaches to talents in various fields such as science, culture and art. When we went there, we queued for less than an hour to get in. The order arrangement in the venue was very reasonable and the Chinese translator was very useful.

The British Museum

Night Attractions

M29***10

I can attest to this: when visiting museums, you absolutely must purchase an guided tour. This morning I visited the British Museum. Luckily, I wisely chose the more expensive premium guided tour. Diana&#39;s explanation was lively, engaging, and undeniably professional. She not only told you what you saw but also provided an accessible explanation of the history behind the exhibits, allowing you to appreciate the characteristics of different cultures and even compare them with Chinese civilization. Diana, like a wise woman, not only shared the stories behind the exhibits but also showcased the unique humanistic appeal of Britain and the insights of someone who experienced it firsthand. Her profound knowledge and deep understanding of Beijing culture made us feel truly moved and reluctant to leave. My fellow travelers immediately decided to listen for an extra hour. Diana also shared the best camera angles, guaranteed to make your photos go viral on social media.

The Cadogan, A Belmond Hotel, London

Mandarin Oriental Hyde Park, London

Raffles London at the Owo

Near London Eye|Buckingham Palace, London

London Eye

300***84

One of the landmark buildings in London, England, it is very popular with tourists. It is very convenient to book tickets online. Now you can directly check your ticket and enter. The whole journey takes about 30 minutes. You can enjoy the beautiful scenery of London. It is one of the must-see attractions when traveling to the UK.

Buckingham Palace

Historic buildings

D27***80

This is a well-deserved attraction, ideally allowing at least two hours. It&#39;s grand yet unassuming, and historical yet not outdated. Each step is incredibly difficult to take, and the scenery is breathtaking. You won&#39;t want to stop until you&#39;ve seen enough. Photography is not permitted.

Windsor Castle

Robert_Tai

The view was beautiful. However the length of visit was a bit short compared to ticket price (personal perspective)

Time:	Apr 29, 2025 (UTC+1) ENDED
Location:	London Trafalgar Square

MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square

Details

Vote

Are you interested in MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led?

Recommended Products for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square

Claridge's, Maybourne Hotel Collection

The Dorchester

Westminster Abbey

The British Museum

The Cadogan, A Belmond Hotel, London

Mandarin Oriental Hyde Park, London

Raffles London at the Owo

London Eye

Buckingham Palace

Windsor Castle

MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square

Details

Vote

Are you interested in MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led?

Recommended Products for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led | London Trafalgar Square

Claridge's, Maybourne Hotel Collection

The Dorchester

Westminster Abbey

The British Museum

The Cadogan, A Belmond Hotel, London

Mandarin Oriental Hyde Park, London

Raffles London at the Owo

London Eye

Buckingham Palace

Windsor Castle

More contents about London