Course overview
Perfect for those who have an interest in SQL and those with aspirations of a career in the IT sector. The SQL Advanced 2-Day Course, Live Virtual Classroom course is here to provide you with the skills and understanding you’ll need to succeed in the world of IT.
Below is some of what you will be learning on this course.
- Sub-queries
- Views
- CTE-tables
- Stored procedures
- Scalar functions
- Table functions
- Variables
- Using variables
- Triggers
- Looping
- Temp tables
- Creating tables
- Sequencing index
Campus locations
Study method
- In-class
- Blended
- Online
Locations
- England
- Birmingham
- London
- Manchester
- Milton Keynes
- Portsmouth

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
- 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
- Using SQL derived tables
- SQL Common Table Expressions (CTEs)
- Recursive CTEs
- Create, alter and drop Views
- Indexes
- Stored procedure principles
- Creating stored procedures
- Executing stored procedures
- System stored procedures
- Declaring variables
- SET versus SELECT
- Passing parameters
- Default values and WHERE clauses
- Output parameters
- Using RETURN
- Testing Conditions
- The IF/ELSE statement
- CASE
- CHOOSE
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.