MS SQL Course, Advanced, 2-Day, Live Online or In London

Actions Panel

MS SQL Course, Advanced, 2-Day, Live Online or In London

Advanced SQL Course. More about DML, DDL Queries and automation. Instructor-led. Practical. Online.

By PCWorkshops

Location

Online

Refund Policy

No Refunds

About this event

SQL Advanced Course

Duration: 2 consecutive days, the first thereof showing as the booking date

Pre-requisite: Basic understanding of SQL queries.

Location: Online, booking link emailed upon booking.

This SQL Advanced course is excellent for delegates who work daily on SQL. Read more

SQL Advanced Course details

Revising MS SQL Server query basics, joins, aggregates, string and date functions

SQL Sub-queries

  • Derived Tables and CTEs

Views, Indexes, Sequencing

SQL Stored Procedure 

  • Variables
  • Parameters and Return Values
  • Looping

Functions

  • User defined Functions
  • Table Valued Functions
  • Scalar Functions
  • Cursors
  • Triggers

Creating Tables in SQL

Constraints:

  • Not Null
  • Unique
  • Default
  • Check
  • Primary Key
  • Foreign Key
  • Identity / Auto-increments

SQL Temporary Tables and 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.)

System requirements: Your SQL Database, query interface and sample data must be ready before the course starts.

Read more: https://pcworkshopslondon.co.uk/sql-advanced-course.html

Organised by

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.

 

 

 

£600