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.
This course leads beginners through the basics of SQL step-by-step.
Build on your SQL skills and learn to use more advanced functions.
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.
Learn how to administer and troubleshoot MS SQL Server.
Learn how to implement SSIS for data transfer and ETL operations.
Use SSRS to design and manage reports in MS SQL Server.
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.
Directions
Everything you need for a great day's training.
A full-colour course manual
Your course exercises to practice at home
Pens & pads to take notes
Plenty of tea, coffee and biscuits
6 months of post course support
A comfortable, modern air-conditioned training room
This SQL training course is carried out using MS SQL Server 2017.
You will be provided with a PC running a SQL database and MS SQL Server Management Studio (MS SQL SMS) when you attend one of our classes.
Yes, the basics of SQL are the same no matter the environment.
The differences when using a derivative of SQL (for example, T-SQL,) or when working in different environments (like MySQL, MariaDB, PostgreSQL and Oracle) are small.
SQL is short for structured query language.
It is the standard language used to manipulate data held in relational databases.
Oracle, Sybase, Microsoft SQL Server and Access are all real world relational databases that use SQL.
Learning SQL is not difficult if you have some experience with computers and information technology.
As with anything new, it is easiest if done with help from a tutor who has real-world experience of working with a SQL database which our tutors all do.
We do not offer formal professional SQL certification.
We do provide everyone that completes one of our courses a course certificate.
