MS SQL Server Advanced 2-Day Course, Birmingham

MS SQL Server Advanced 2-Day Course, Birmingham

By PCWorkshops

Select date and time

Thu, 15 May 2025 11:00 - 17:00 GMT+1

Location

One Victoria Square

Birmingham B1 1BD United Kingdom

Refund Policy

No Refunds

Description

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

Tags

Organised by

PCWorkshops

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

 

From £647.39