Menu
  1. Home
  2. Programming
  3. SQL
  4. Short
  5. SQL Advanced 2-Day Course
Enquire Now

SQL Advanced 2-Day Course

Study Method
In-class
Locations
Birmingham, London, Manchester, Milton Keynes, Portsmouth
Institution
PCWorkshops
Start Date
Multiple start dates available

Course overview

  • Sub-queries
  • Views
  • CTE-tables
  • Stored procedures
  • Scalar functions
  • Table functions
  • Variables
  • Using variables
  • Triggers
  • Looping
  • Temp tables
  • Creating tables
  • Sequencing index
Expand all and read more

Campus locations

Study method

  • In-class
  • Blended
  • Online

Locations

  • England
    • Birmingham
    • London
    • Manchester
    • Milton Keynes
    • Portsmouth
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 2 Days

Course features

  • SQL course certificate on completion (assessment based)
  • SQL course notes
  • Practical SQL course exercises, SQL course homework/SQL course revision work
  • To assist after the course, 1 free session for questions online SQL course via Skype or Teamviewer
  • Max group size on this SQL course is 4

Subjects

Core Units
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
Views
  • 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
And more!
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £750

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.