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

Spread the word! Share your result with friends and discover their opinions!

The Ritz London

Luxury Hotels

Four Seasons Hotel London at Park Lane

The British Museum

Best Things to Do

Museums

Dannywu

On May 21, I took the elderly to visit the British Museum, and the tour guide service was warm and professional. If you visit the museum without a tour guide, it may be completed in half an hour. The main reason is that the historical geography has not been learned well. Under the tour guide&#39;s explanation, the three hours feel very fast. This is the second time I have decided to come to the British Museum for the tour guide service of Trip.com . I still feel that the meaning is still not enough. The first time I came, I also decided that the tour guide service of Trip.com was very good.

Westminster Abbey

Book now for tomorrow

Night view

205***29

🏰 Westminster Abbey, it&#39;s really shocking! 📍 It&#39;s located in central London, close to the Parliament Building and Big Ben. The church is a prominent representation of British Gothic architecture, towering spires, exquisite carvings and beautifully painted glass windows, each detail shows an unparalleled artistic charm. Walking into the church, as if through time and space, is the holy place of the crowning of the British royal family, witnessing countless important moments in history. It is also a resting place for many celebrities, and great figures such as Newton, Darwin, Dickens have slept here, making people respect their contributions. Walking around, you can feel the solemnity of religion and the deep historical and cultural heritage. The church&#39;s Henry VII chapel is exquisite, with a fan-shaped arched roof and densely carved decorations, like a fairy tale fairyland. Whether it is an architecture lover or a historical and cultural fan, Westminster Abbey is definitely worth a visit. I believe you will be deeply impressed by its charm like me. 💕 highly recommend it to everyone! 💕

The Peninsula London

Near Victoria Railway Station|Belgravia, London

Raffles London at the Owo

Near London Eye|Buckingham Palace, London

The Cadogan, A Belmond Hotel, London

Buckingham Palace

Historic buildings

Lola Coveñas

Buckingham Palace is a must-visit for history lovers, featuring stunning architecture and beautiful gardens. The official residence of the British monarch, it dates back to 1703 and serves as the venue for royal ceremonies and events. Visitors can enjoy a glimpse into royal life, with the Changing of the Guard being a popular attraction.

London Eye

Immediate access

Book now for today

Anonymous User

London Eye (The London Eye), full name British Airways London Eye, located on the banks of the Thames in London, UK, is the world&#39;s first and largest viewing Ferris wheel as of 2005, and is one of London&#39;s landmarks and famous tourist attractions.

Windsor Castle

The Queen&#39;s favorite palace is very luxurious, but it is not allowed to take pictures. It can only be taken outside. When entering, a photo was taken and was stopped by the staff. Knowing the life of the royal family, Windsor Castle is generally very quiet.

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

The Ritz London

Four Seasons Hotel London at Park Lane

The British Museum

Westminster Abbey

ColumbusLondon

The Peninsula London

Raffles London at the Owo

The Cadogan, A Belmond Hotel, London

Buckingham Palace

London Eye

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

The Ritz London

Four Seasons Hotel London at Park Lane

The British Museum

Westminster Abbey

ColumbusLondon

The Peninsula London

Raffles London at the Owo

The Cadogan, A Belmond Hotel, London

Buckingham Palace

London Eye

Windsor Castle

More contents about London