• 0208 432 6218
  • WhatsApp
  • Register

SQL for Beginners

A Beginner level 12-hour course delivered via Instructor-led Physical Classes or Virtual Classes.

Regular Price: £420
Batch Price: From £360   📅  View Dates & Prices

Group Booking Discount: From £240 per person  🧮 Calculate & Book

1-to-1 Training: £420  📋 Booking Request Form

Course Overview

SQL stands for Structured Query Language, designed for managing data in relational database management systems, and it is one of the most important, widely used programming languages in the business world. SQL is essential for any professional, including technical and non-technical roles like data/business analyst, marketing, operations, finance, sales, and support.

This training course will teach you the essentials of SQL. In this course you’ll learn how to use SQL to create a database & tables, retrieve data from a database, filter data, use aggregation, use functions, subqueries and join multiple tables.


Requirements

  • You should have basic computing knowledge.
  • Familiarity with relational database concepts is helpful but not essential.


Course Content

  1. Introduction to Database and SQL
    • Database and DBMS
    • Introduction to SQL
    • USE Command
    • Create Databases using SQL
    • Drop Databases using SQL
    • Creating, Altering and Removing Tables using SQL
    • Commenting and Saving SQL
  2. Data Manipulation Language
    • Introduction to DML
    • INSERT statements
    • UPDATE statements
    • DELETE statements
  3. Retrieving Data
    • Introduction to the SELECT Statement
    • Retrieving Columns
    • Using DISTINCT to find unique values
    • Concatenating Columns
    • Creating Calculated Field
    • Limiting Results by using TOP Clause
  4. Filtering Data
    • Using WHERE for filtering
    • Using the NOT operator
    • Using the LIKE operator
    • Using IS NULL and IS NOT NULL
  5. Sorting Data Using ORDER BY
    • Sorting Data
    • Sorting by Multiple Columns
    • Specifying Sort Direction
  6. Aggregation and grouping
    • COUNT, SUM, AVG, MIN, MAX
    • Grouping by fields
    • Using HAVING to filter results
  7. Built-In Functions
    • Introduction to Built-In Functions
    • Using System Functions
    • Conversion Functions - CONVERT
    • Using Mathematical functions
    • Using String Functions
  8. Date and Time Functions
    • GETDATE
    • DATEADD
    • DATEDIFF
    • DATENAME
    • DATEPART
    • DAY, MONTH and YEAR
    • Using CONVERT to format a date/time
  9. Combining multiple SELECT Results
    • UNION
    • UNION ALL
  10. Subqueries
    • Introduction of Subqueries
    • Subqueries vs Joining Tables
    • Subqueries with Comparison Operators
    • Subqueries with IN and NOT IN Operators
  11. Joins
    • Inner joins
    • Table aliases
    • Left and right outer joins
    • Full outer joins


Course Dates, Prices & Enrolment

Scroll right for more details
Delivery MethodDates & TimesHoursPriceEnrolment
Online Training using Zoom
02 Jun 2026 - 11 Jun 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
£360 £420
Enrol Now
Online Training using Zoom
07 Jun 2026 - 21 Jun 2026
3 Sundays
10:00 AM - 02:00 PM BT
12-hour over 3-day
£360 £420
Enrol Now
Classroom Training
09 Jun 2026 - 10 Jun 2026
Tuesday & Wednesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
£420
Enrol Now
Online Training using Zoom
09 Jun 2026 - 10 Jun 2026
Tuesday & Wednesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
£360 £420
Enrol Now
Online Training using Zoom
16 Jun 2026 - 25 Jun 2026
2 Tuesdays & 2 Thursdays
05:00 AM - 08:00 AM BT
12-hour over 4-day
£420
Enrol Now
Online Training using Zoom
06 Jul 2026 - 07 Jul 2026
Monday to Tuesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
£360 £420
Enrol Now
Classroom Training
06 Jul 2026 - 07 Jul 2026
Monday to Tuesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
£420
Enrol Now
Online Training using Zoom
07 Jul 2026 - 16 Jul 2026
2 Tuesdays & 2 Thursdays
05:00 PM - 07:00 PM BT
12-hour over 6-day
£360 £420
Enrol Now
Online Training using Zoom
14 Jul 2026 - 23 Jul 2026
2 Tuesdays & 2 Thursdays
05:00 AM - 08:00 AM BT
12-hour over 4-day
£420
Enrol Now
Online Training using Zoom
19 Jul 2026 - 02 Aug 2026
3 Sundays
10:00 AM - 02:00 PM BT
12-hour over 3-day
£360 £420
Enrol Now
Online Training using Zoom
04 Aug 2026 - 13 Aug 2026
Tuesday & Thursday
10:00 AM - 01:00 PM BT
12-hour over 4-day
£360 £420
Enrol Now
Classroom Training
04 Aug 2026 - 13 Aug 2026
Tuesday & Thursday
10:00 AM - 01:00 PM BT
12-hour over 4-day
£420
Enrol Now
Online Training using Zoom
11 Aug 2026 - 20 Aug 2026
2 Tuesdays & 2 Thursdays
02:00 PM - 05:00 PM BT
12-hour over 4-day
£420
Enrol Now
Online Training using Zoom
30 Aug 2026 - 13 Sep 2026
3 Sundays
10:00 AM - 02:00 PM BT
12-hour over 3-day
£360 £420
Enrol Now
Online Training using Zoom
07 Sep 2026 - 08 Sep 2026
Monday to Tuesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
£360 £420
Enrol Now
Classroom Training
07 Sep 2026 - 08 Sep 2026
Monday to Tuesday
10:00 AM - 04:00 PM BT
12-hour over 2-day
£420
Enrol Now

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:


Participant Reviews

“An excellent course experience covering many different topics in detail and practising much of the learning with practical exercises. The tutor was very good at breaking down the specific aspects and challenges in each of the topics and worked through examples that enabled a better learning experience. Very happy and look forward to undertaking further courses with LAIT in the future!”

Mohammed, 9 July 2025

“The Course was very good and the teacher was extremely helpful. I would, without doubt, recommend the London Academy of IT.”

Lee, 11 July 2023

“It was an excellent course, pitched perfectly for beginners to understand not just who to programme, but why things are done the way they are.

Younus was a brilliant tutor who went at my pace, and seemed as pleased as I was every time I had a success, and was extremely patient when I had a brain fade at the end of the sessions.

I will definitely be back for the Intermediate course once I've got some real-world practice of the basics under my belt.”

Sara, 4 July 2022

“The training was excellent. I only had lots of technical problems with my microphone, so the session broke down several times during the course in the Zoom call.”

Norbert, 25 March 2022

“The Database Design with Microsoft SQL Server course was excellent value for money and well taught. It took us from very basic what is SQL questions through to more complicated coding in a short period and although our group had differing levels of experience we still all learnt something. I would recommend this course to anyone wanting to jump in to SQL.”

Tom, 1 December 2020

“Well structured course, covering a huge content of information. The class was conducted in a way that each subject matter logically followed to the next, so that the subject was clear to understand, and enjoyable. The trainer was clearly an expert in the area and willing to answer all questions and ensure that all members understood the current topic before moving on. Will be attending more classes in the future”

Melanie 31 November 2019

“Hands on training”

Roberta 10 June 2019

“I highly recommend this SQL course by London Academy of IT for beginners and intermediate users”

Rebecca 30 May 2019

“Recommend for all levels of ability. Great course”

David 07 March 2019

“The class was one of the best educational experiences I have experienced”.

Mohammad 11 February 2019

“Very good course. Good pace and balance between theory and practical, with content clearly explained along the way. Would recommend to anyone not quite understanding the aspects of db design from online sources”.

Laura 11 February 2019

“The Database Design course is well structured and easy to comprehend from the start. The teacher is clearly knowledgeable and makes a great effort to clear all your doubts along the way. I highly recommend this course”

Katherine 25 January 2019

"Highly recommended intro to SQL - perfect for starting your MS SQL Server education."

Catherine McGahey, 22 September 2015

"Value for money. Lesson was well paced and explained so that each student could catch up and understand session. Very supportive teacher."

Claudia Adele, 15 September 2015

"Very informative class, teacher was very knowledgeable about his subject. Highly recommend."

Keely Cooper, 01 September 2015

"This course is essential for a beginner, it will give you fundamental tools to become competent working with SQL."

10 November 2014

Part of a Structured Career Pathway

This course is a critical milestone within our professional pipelines. Complete the complete track sequentially to achieve job-ready credentials.

BI Professional Path

Learn how to become a Business Intelligence (BI) Professional with training in Power BI, SQL, Excel, Python, data modelling, dashboards, reporting, and business analytics. Explore BI career opportunities and learning pathways.

Explore Full Pathway Track

Data Analyst Career Path

Follow a practical Data Analyst career path with instructor-led training in Excel, SQL, Power BI, Python, Pandas and data visualisation skills.

Explore Full Pathway Track

SQL Database Professional Path

Build a career as a SQL Database Professional with training in SQL, database design, Power BI, and Python data analysis. Learn how to manage, analyse, and report on business data.

Explore Full Pathway Track

Frequently Asked Questions

SQL (Structured Query Language) is used to store, manage, and retrieve data from databases. It is widely used in data analysis, business intelligence, and software development. You may view our 5 Reasons Every Business Pro Needs SQL NOW video.

SQL is considered one of the easiest programming languages to learn. Most beginners can understand the basics quickly with hands-on practice.

You can learn the basics of SQL in a few days, but becoming confident may require practice with real datasets and projects.

Yes, SQL is one of the most in-demand skills in data-related roles such as:

  • Data Analyst
  • Business Analyst
  • Data Scientist

It is widely used across industries, including finance, healthcare, and technology.

During the course, you will use industry-standard database systems such as MySQL, PostgreSQL, and SQL Server to practice writing SQL queries.

We also provide access to our online practice platform, where you can work on SQL exercises and build your skills in a structured environment:
https://sql.lait.co/.

The course is instructor-led and can be attended online or in person.

No, this course is designed for beginners and requires no prior programming or technical experience.

You will learn how to:

  • Write SQL queries (SELECT, INSERT, UPDATE, DELETE)
  • Filter and sort data using clauses
  • Work with tables and databases
  • Use joins to combine data from multiple tables

These are core SQL skills used in real-world data analysis.

Yes, the course includes practical exercises to help you apply SQL concepts and build real skills.

Yes, SQL is a fundamental skill for data analysts. It allows you to query data, generate reports, and extract insights for decision-making.

Yes, SQL is often used alongside tools like Python and Power BI for data analysis, reporting, and visualisation.

Yes, you will receive a certificate of completion after successfully finishing the course.

Related Posts

What we do?

At London Academy of IT, we provide instructor-led online and in-person IT training in Data Analytics, SQL, Python, Power BI, and more. Our cutting-edge courses are designed to boost performance and enhance employability, providing the competitive edge employers look for.

Our Contacts

London Academy of IT
64 Broadway
Stratford
London E15 1NT
United Kingdom

Regional Training

2012 - 2026 © London Academy of IT Limited. All Rights Reserved.
UKPRN: 10045491. Registered in England & Wales with company no. 07923992.