• Register
  • FAQs
  • Contact
  • Time Zone
  • Chat on WhatsApp

SQL for Beginners

Batch Price From £360 (approx. $474 USD) View Dates & Prices
Custom Price From £240 (approx. $316 USD) Price Calculator & Booking
Total Duration: 12 Hours
Course level: Beginner
Delivery Method: Instructor-led Physical Classes or Virtual Classes
Certification: Certificate of Completion will be provided after completing the course

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, aggregation, use functions, subqueries, join multiple tables and create views.

Requirements

  • You should have basic computing knowledge.
  • Familiarity with relational database concepts is helpful but not essential.
Software to download
  • Microsoft SQL Server 2017 Developer Edition: View installation guide. Other releases (i.e. SQL Server 2012/2014/2019) and editions (i.e. Express, Developer, Trial, Standard/Enterprise) can be used too.
  • SQL Server Management Studio (SSMS): View installation guide
If you are unable to download and install the Microsoft SQL Server then you may use the online SQL editor https://sqliteonline.com

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Time Zone:
Training MethodDates and TimesPrice 
Online Training using Zoom 22 Oct 2024 - 07 Nov 2024
3 Tuesdays & 3 Thursdays
01:00 PM - 03:00 PM ET
£360 £420
(approx. $474 USD)
Closed
Online Training using Zoom 30 Oct 2024 - 15 Nov 2024
3 Wednesdays & 3 Fridays
11:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Closed
Online Training using Zoom 11 Nov 2024 - 29 Nov 2024
3 Mondays & 3 Fridays
01:00 PM - 03:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Classroom Training 12 Nov 2024 - 15 Nov 2024
Mon, Tue, Thu, Fri
09:00 AM - 12:00 PM ET
£420
(approx. $553 USD)
Enrol Now
Online Training using Zoom 16 Nov 2024 - 24 Nov 2024
2 Saturdays & 2 Sundays
05:00 AM - 08:00 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 03 Dec 2024 - 19 Dec 2024
3 Tuesdays & 3 Thursdays
01:00 PM - 03:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Classroom Training 07 Dec 2024 - 15 Dec 2024
2 Saturdays & 2 Sundays
05:00 AM - 08:00 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 07 Dec 2024 - 15 Dec 2024
2 Saturdays & 2 Sundays
05:00 AM - 08:00 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 09 Dec 2024 - 20 Dec 2024
Mon, Wed & Fri (2 wks)
10:00 AM - 12:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Classroom Training 16 Dec 2024 - 17 Dec 2024
Monday to Tuesday
05:00 AM - 11:30 AM ET
£420
(approx. $553 USD)
Enrol Now
Online Training using Zoom 07 Jan 2025 - 23 Jan 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 11 Jan 2025 - 19 Jan 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 15 Feb 2025 - 23 Feb 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 25 Feb 2025 - 13 Mar 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 22 Mar 2025 - 30 Mar 2025
2 Saturdays & 2 Sundays
11:00 AM - 02:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 15 Apr 2025 - 01 May 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 26 Apr 2025 - 04 May 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 31 May 2025 - 08 Jun 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 03 Jun 2025 - 19 Jun 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 05 Jul 2025 - 13 Jul 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 22 Jul 2025 - 07 Aug 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 09 Aug 2025 - 17 Aug 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 09 Sep 2025 - 25 Sep 2025
3 Tuesdays & 3 Thursdays
09:30 AM - 11:30 AM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 13 Sep 2025 - 21 Sep 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 18 Oct 2025 - 26 Oct 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 28 Oct 2025 - 13 Nov 2025
3 Tuesdays & 3 Thursdays
10:30 AM - 12:30 PM ET
£360 £420
(approx. $474 USD)
Enrol Now
Online Training using Zoom 22 Nov 2025 - 30 Nov 2025
2 Saturdays & 2 Sundays
10:00 AM - 01:00 PM ET
£360 £420
(approx. $474 USD)
Enrol Now

Course Content

  1. Understanding Databases and DBMS
    • Database and DBMS
    • Introduction to MS SQL Server
    • Introduction to Azure SQL Database
  2. Structured Query Language (SQL) and T-SQL
    • Introduction to SQL and Transact-SQL (T-SQL)
    • USE Command
    • Create Databases using SQL
    • Drop Databases using SQL
    • Creating, Altering and Removing Tables using SQL
    • Commenting and Saving SQL
  3. Data Manipulation Language
    • Introduction to DML
    • INSERT statements
    • UPDATE statements
    • DELETE statements
  4. 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
  5. Filtering Data
    • Using WHERE for filtering
    • Using the NOT operator
    • Using the LIKE operator
    • Using IS NULL and IS NOT NULL
  6. Sorting Data Using ORDER BY
    • Sorting Data
    • Sorting by Multiple Columns
    • Specifying Sort Direction
  7. Aggregation and grouping
    • COUNT, SUM, AVG, MIN, MAX
    • Grouping by fields
    • Using HAVING to filter results
  8. Built-In Functions
    • Introduction to Built-In Functions
    • Using System Functions
    • Conversion Functions - CONVERT
    • Using Mathematical functions
    • Using String Functions
  9. Date and Time Functions
    • GETDATE
    • DATEADD
    • DATEDIFF
    • DATENAME
    • DATEPART
    • DAY, MONTH and YEAR
    • Using CONVERT to format a date/time
  10. Combining multiple SELECT Results
    • UNION
    • UNION ALL
  11. Subqueries
    • Introduction of Subqueries
    • Subqueries vs Joining Tables
    • Subqueries with Comparison Operators
    • Subqueries with IN and NOT IN Operators
  12. Joins
    • Inner joins
    • Table aliases
    • Left and right outer joins
    • Full outer joins
    • Aggregate Queries with Multiple Tables

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

“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 01/12/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/10/2019

“Hands on training”

Roberta 10/06/2019

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

Rebecca 30/05/2019

“Recommend for all levels of ability. Great course”

David 07/03/2019

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

Mohammad 11/02/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/02/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/01/2019

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

Catherine McGahey, 22/09/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/09/2015

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

Keely Cooper, 01/09/2015

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

10/11/2014

Share This Course

Save Money with Packages

SAVE up to 20% by booking this course with other related courses as shown below:

SQL Beginner to Advanced

£672 (save £168)

This package combines
Find out more & book now

Data Analyst SQL & Power BI

£504 (save £126)

This package combines
Find out more & book now

Data Analysis Immersive

£1,008 (save £252)

This package combines
Find out more & book now

Related Videos

Installing SQL Server in Mac using Docker

Installing Microsoft SQL Server 2012 Service Pack 2 (SP2) Express

Newsletter Sign-up

Have a Question?