I felt much more confident in my job role following the session.
Introduction to SQL Training Course
-
1 Day
-
Private Online Only
Gain the practical skills and confidence to write SQL queries, extract exact business data and streamline your reporting on this 1-day, 5-star rated course. Available in Manchester, Liverpool, and Live Online, or as bespoke private training UK wide
Private Course
-
Small class sizes
-
5 Star Rated Course
-
Practical courses
-
3 month support
Introduction to SQL Course Overview
If you want to retrieve data directly for business reporting, or currently rely on other teams to pull reports for you, this course will give you the practical skills to query database systems efficiently, accurately, and with complete confidence.
You will master the essential foundations of query syntax, moving from basic data extraction to filtering and joining tables. By the end of the day, you will be able to retrieve the exact datasets required for your daily business tasks without needing manual spreadsheet work.
We also cover practical shortcuts, query troubleshooting, and read-only best practices to ensure you can navigate live database platforms safely.
Exercises are conducted using open-source tools (PostgreSQL & pgAdmin), but the core SQL principles taught apply across all major database systems, including Microsoft SQL Server, MySQL, and Oracle.
Key Takeaways of this SQL Course
This 1 day course focuses on immediate workplace application, giving you the practical skills to find, extract and work with the exact data you need with speed and accuracy:
- Increase Reporting Speed: Query database systems directly to retrieve accurate datasets in seconds, cutting lead times.
- Eliminate Manual Spreadsheet Cleanup: Retrieve only the specific rows and columns you need directly from the database, so your data arrives clean and ready for analysis without extra Excel work.
- Combine Data Accurately: Understand relational table connections to merge information from separate business sources cleanly.
Following the training, you will receive comprehensive course reference notes and 3 months email support.
Introduction to SQL Course Outline
-
Introduction
- What is SQL?
- What is a database?
- SQL vs database tools
- Tables, rows, and columns
- Understanding relational data
Sorting Data
- Sorting data with ORDER BY
- Removing duplicates with DISTINCT
- Limiting results with LIMIT
Summarising Data
- COUNT
- COUNT DISTINCT
- SUM
- AVG
- MIN & MAX
-
Data Setup
- Setting up the Data Environment
- Setting up the database
Filtering Data
- Filtering data with WHERE
- Using AND / OR logic
- Filtering with a list of values IN
- Filtering within a range BETWEEN
- Working with NULL values
GROUP BY
- Grouping Data
- HAVING
- Order of Operations
-
Retrieving Data
- Writing SELECT statements
- Specifying a table with FROM
- Selecting specific columns
Working with Dates
- Filtering dates with WHERE
- Extracting parts of a date (EXTRACT)
- Current date functions (CURRENT_DATE, NOW())
- Date arithmetic (adding/subtracting days)
Working with Multiple Tables
- Why data is split into tables
- Primary keys & foreign keys
- How relationships enable joins
- Combining Data
- INNER JOIN
- Filtering Combined Data
Why Choose M Training
-
Small class sizes
We run small classes so that there is more interactivity, opportunity for questions and is more personal.
-
Private Online Courses
Private courses can be held online via Zoom or Teams.
-
Course Materials
Detailed course materials are provided for each delegate as well as a certificate of completion
-
Expert Trainers
Run by an experienced trainer and consultant
-
Follow up support
Along with the course notes, you also recieve 3 months email support for any follow up questions that you may have.
-
5 Star Rated
Our courses are rated 5 stars by delegates, through post-course feedback forms, on Google and Facebook.
Who Should Attend this SQL Training?
This 1-day course is designed specifically for beginners and non-technical business professionals who need to retrieve and analyse data with greater speed, efficiency and accuracy.
It is ideal for Business Analysts, Digital Marketers, Finance Teams, HR Administrators and anyone currently relying on spreadsheets who wants to query relational database systems directly.
SQL Course Requirements
No prior programming or coding experience is required. This is a practical, step-by-step introduction suitable for complete beginners.
This course will be conducted using PostgreSQL and PGAdmin. These can be downloaded for free from: https://www.postgresql.org/download/
SQL Training Course Day Details
Our 5-star rated Introduction to SQL courses are highly practical and run with a maximum of 6 delegates on public sessions.
This small class size ensures a personalized learning environment with plenty of opportunity to ask questions and work through exercises with your trainer.
Training is delivered either in-person at our physical classroom hubs or as a live, interactive course online via Zoom. Sessions run from 9:30 am to 4:30 pm, with regular breaks scheduled throughout the day.
Private & Bespoke Corporate SQL Training
If you have a group of 4 or more colleagues who require training, our private SQL courses are the most cost-effective solution.
Course content can be tailored to your requirements.
Private courses are delivered online via Zoom or MS Teams
Prices starting from £750 + VAT for Online. Get in touch to request a bespoke quote on 0161 226 6032 or info@mtraining.co.uk
Course Reviews
Course Reviews
I just wanted to take the time to let you know how much I and the team have enjoyed your training sessions. Overall, the trainers we have met have all been really easy to get along with, they're dedicated, have our interests at heart and we would have no hesitation coming back to M Training, should we need you again in the future. All classes have been online, but the way this year has gone, it's something we've all become more used to! The class sizes are good though, as it means you can still have your voice heard when needed.
Kayleigh James
R52Course Reviews
[The trainer] was very friendly and insightful. Would recommend the course to others.
Steph Feather
We Are BoutiqueCourse Reviews
Really enjoyed the course and found it very helpful. The trainer had lots of advice to give.
Matthew Purdon
Alliance Automotive GroupCourse Reviews
Personal, practical and clear approach. I have found it really helpful. I am leaving feeling a lot more confident. Thank you.
Lauren Banks
Manchester CaresCourse Reviews
Excellent delivery, informative, great analogies and thorough explanations.
Tayla Toby
Crystal Collections LtdCourse Reviews
Great experience, Great tutor at a great central setting close to University of Manchester University. No negative points, would highly recommend.
Richard Allen
University of ManchesterCourse Reviews
I would like to take this opportunity to thank you for the 3 days I’ve spent training with you, the courses were very informative and presented in comfortable atmosphere which made participation very easy The content of the courses were really helpful and I feel I’ve gained a lot from both, I’ve given this feedback to management at Scholastic and recommended that we should use your company in the future
Miriam Clarke
ScholasticPrivate Intro to SQL Course Enquiry
Private Intro to SQL courses can be held online via Zoom or Teams.
Please complete the form below for more information
Other Courses You May Be Interested In
Intro to VBA in Excel
Learn VBA for Excel, build practical macros, and streamline business workflows with this 5 star rated practical VBA Training.
From £550
MORE INFO...
Power Query Course
One-day Power Query course to streamline Excel data tasks and improve reporting accuracy.
From £590
MORE INFO...
2 Day Power BI Course
Learn how to use Power BI to create dynamic, interactive visualisations of your business data on this 2-day course.
From £495
MORE INFO...
Advanced Excel Course
This is a one day training course that takes you through some of the more advanced features of Excel. It is designed for people who know the basics but want to extend their knowledge/skills in using Excel.
From £195
MORE INFO...
PEOPLE THAT HAVE ENJOYED OUR COURSES
Manchester: Base, Greenheys Lane, Manchester Science Park, Manchester, M15 6LR
Leeds: West One, 114 Wellington St, Leeds, LS1 1BA
Birmingham: Cornwall Buildings, 45 Newhall Street, Birmingham, B3 3QR
Liverpool: The Plaza
100 Old Hall Street
Liverpool
L3 9QJ
Click here to sign up for offers, advice and industry news
Subscribe
