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 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.
Expand all and read more
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
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
Sub-queries in the WHERE, SELECT, From or Having clauses
Using SOME, ALL, ANY and IN clauses in the Where Clause
Sub-queries with the EXISTS predicate
Derived tables and CTEs
Using SQL derived tables
SQL Common Table Expressions (CTEs)
Create, alter and drop Views
SQL stored procedure basics
Stored procedure principles
Creating stored procedures
Executing stored procedures
System stored procedures
SET versus SELECT
Parameters and return values
Default values and WHERE clauses
The IF/ELSE statement
Want more information about the subjects for this course?
Get the course guide
Course fees – £600
No government funding available for this course
Find out more about the payment options for this course
Get the course guide
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.
Want to know more about this course? Complete the form and learn about:
Pricing and payment options
How to get help and contact information
Everything you need to know before enrolling!
Want to know more about this course?
Get your free course guide now! Complete this easy form and you'll receive a course guide and consultation from PCWorkshops
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
This website uses additional cookies to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Keeping this cookie enabled helps us to improve our website.
Please enable Strictly Necessary Cookies first so that we can save your preferences!