As a result:
This course is only available as a private booking for an individual or group.
Our private courses can run online, in-person at your offices or at one of our training centres.
Please contact us for full details.
Payment Of Invoices
For bookings from established businesses, we do not require payment at the point of booking.
We will send you an invoice which you can submit to your accounts payable system.
Purchase Orders
If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.
PAYMENT METHODS:
You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.
We accept payment either via direct bank transfer or card
Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.
Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.
Award-winning, small, friendly SQL courses in London, online & across the UK
Hands-on training using real-world examples for all levels from beginner to advanced
All courses CPD-certified and include 6 months post-course support
Learn how to query and manage databases using Structured Query Language
1,500+ third party reviews
Filter by category:
This course leads beginners through the basics of SQL step-by-step.
This course leads beginners through the basics of SQL step-by-step.
Introduction to SQL
Relational database essentials
SELECT & WHERE statements
Mathematical calculations
Grouping & Counting data
Date functions
We start this session with an overview of relational databases and how SQL works within that context. We also have a look at the database that we will be running out SQL queries on during this course and get comfortable with the interface.
The key topics trained are:
• How to write aggregate queries
• COUNT, SUM(), MAX(), MIN()
• GROUP BY
• HAVING
• The principle of including data from multiple tables in queries
This is a beginners’ SQL course, so you do not need prior experience with SQL to attend.
It is recommended that you have good experience of working in Windows and some experience of relational databases.
Please note that for live online courses you are responsible for installing a functioning version of SQL and MS SQL Server Management Studio on your PC prior to the course. On standard PCs this should take less than 10 minutes.
Our usual trainer for this course is Serena.
Serena began her career as a business analyst before moving into IT training.
She is a Microsoft certified and TPMA qualified trainer and has 20+ years’ experience of leading training courses, managing training projects and writing training materials.
Build on your SQL skills and learn to use more advanced functions.
Build on your SQL skills and learn to use more advanced functions.
Advanced SELECT statements
Transactions & rollback
Using sub-queries
Views & Window functions
Building stored procedures
Managing Views
Download full course details
Click the sections below to see the full course syllabus for this advanced SQL course.
• Overview of the database used in the workshop
• Good practice when writing SQL queries
• Writing sub queries
• Over() and Over(Partition by)
• Row() v Rank()
This is an advanced SQL course, which assumes that you have some experience of working with databases.
Before attending you should have a basic understanding of SQL select statements, have attended our introductory SQL course or have achieved equivalent practical knowledge.
Please note that for live online courses you are responsible for installing a functioning version SQL and MS SQL Server Management Studio on your PC prior to the course. On standard PCs this should take less than 10 minutes.
Our usual trainer for this course is Serena.
Serena began her career as a business analyst before moving into IT training.
She is a Microsoft certified and TPMA qualified trainer and has 20+ years’ experience of leading training courses, managing training projects and writing training materials.
Save £130 when you book our Introduction and Advanced SQL courses at the same time.
Go from complete beginner to SQL expert with 3 days of intensive classroom training led by a tutor with over 15 years of experience.
Save £130 when you book our Introduction and Advanced SQL courses at the same time.
Go from complete beginner to SQL expert with 3 days of intensive classroom training led by a tutor with over 15 years of experience.
Please see the individual courses above to see the full syllabus of the two courses that make up our combined SQL course.
Learn how to configure, administer, maintain and troubleshoot Microsoft SQL Server.
Learn how to configure, administer, maintain and troubleshoot Microsoft SQL Server.
Installing & configuring SSMS
Database & server security
Backing up and restoring data
Automating day-to-day tasks
Optimising performance
Troubleshooting errors
This course assumes that you already have some experience of working in the Microsoft Windows Server operating system environment.
You should also have an understanding of the fundamental design of relational databases including the purpose of primary and foreign keys, entity relationships, and data normalization.
A working knowledge of the SQL language will also be assumed.
Easy booking & payment
Money back guarantee
Post-course support
If you are unsure about anything please don’t hesitate to get in touch and we’ll be delighted to help.
Our SQL basics course is for total beginners. You do not need any previous experience with SQL to attend, there are no prerequisites for this course.
This course is designed for people who are learning SQL so that they can:
1. Working with advanced SQL queries and stored procedures that have been created by a database analyst / SQL developer.
2. Creating simple SQL queries and SQL statements from scratch.
3. Going on to attend our advanced SQL course as they develop their database knowledge.
Our advanced course is for basic SQL users who want to develop their SQL skills further.
It is designed for people who will be creating complex queries and views, working with multiple tables and subqueries and managing databases.
The combined course is a combination of our Introduction to SQL course and our Advanced course.
We offer a discount when these two classes are booked at the same time.
Our teaching is very hands-on.
Each lesson starts with the tutor explaining a topic from the curriculum.
Once the tutor has clearly explained a topic the course moves on to practice exercises which let the class practice that topic.
The instructor is on-hand throughout to ensure everyone has a good understanding.
We also regularly provide private classes where our instructor runs private lessons for a group from one company.
These courses can be run as classroom courses or remote courses, and we can customise the curriculum if required.
Our teaching style remains the same with lots of practice at the end of each lesson to ensure you have fully understood the topics that you have been studying.
We run a full schedule of remote courses over Zoom.
This courses are instructor-led as our in-person courses are.
We also deliver private virtual courses over Teams, if requested.
We look forward to meeting you at your course.
It’s very helpful for us to understand what you are looking to get out of your course.
