MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led

MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led

This SQL for advanced SQL topics is online instrcutor-led, Have a fun and very useful day with us.

1.3k followers
By PCWorkshops
1.3k followers
29.2k events hosted 📈

Select date and time

Tue, 6 May 2025 11:00 - 17:00 BST

Location

London Trafalgar Square

Golden Cross House London WC2N 4JF United Kingdom

Refund Policy

No Refunds

About this event

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.)

Frequently asked questions

Which Database is used?

Request your SQL Database, MS SQL Server, MySQL, etc

What software do I need

You will need to have your database available on your device for the couse

Do I need to know SQL Basics

Yes, you need to know select clauses, joins and group bys, at least

If I don't know the basics, can I join the beginners course

Yes, discounts are available for booking SQL Basics and Advanced courses together.

Tags

Organised by

PCWorkshops
1.3k followers
29.2k events hosted

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 Terms and Conditions:

By booking a course with us, you agree to the terms and conditions specified on our website: https://pcworkshopslondon.co.uk/termsandconditions.html