Course Content
- 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
- Data Manipulation Language
- Introduction to DML
- INSERT statements
- UPDATE statements
- DELETE statements
- 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
- Filtering Data
- Using WHERE for filtering
- Using the NOT operator
- Using the LIKE operator
- Using IS NULL and IS NOT NULL
- Sorting Data Using ORDER BY
- Sorting Data
- Sorting by Multiple Columns
- Specifying Sort Direction
- Aggregation and grouping
- COUNT, SUM, AVG, MIN, MAX
- Grouping by fields
- Using HAVING to filter results
- Built-In Functions
- Introduction to Built-In Functions
- Using System Functions
- Conversion Functions - CONVERT
- Using Mathematical functions
- Using String Functions
- Date and Time Functions
- GETDATE
- DATEADD
- DATEDIFF
- DATENAME
- DATEPART
- DAY, MONTH and YEAR
- Using CONVERT to format a date/time
- Combining multiple SELECT Results
- Subqueries
- Introduction of Subqueries
- Subqueries vs Joining Tables
- Subqueries with Comparison Operators
- Subqueries with IN and NOT IN Operators
- Joins
- Inner joins
- Table aliases
- Left and right outer joins
- Full outer joins
Course Dates, Prices & Enrolment
Scroll right for more details
| Delivery Method | Dates & Times | Hours | Price | Enrolment |
Online Training using Zoom
|
02 Jun 2026 - 04 Jun 2026
Tue, Wed & Thu
10:00 AM - 02:00 PM
BT
| 12-hour over 3-day |
| Enrol Now |
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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Enrol Now |
Note: Online classes are usually delivered through Zoom video conferencing.
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:
Frequently Asked Questions
What is SQL and why is it important?
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.
Do I need any prior experience to learn SQL?
No, this course is designed for beginners and requires no prior programming or technical experience.
Is SQL difficult to learn?
SQL is considered one of the easiest programming languages to learn. Most beginners can understand the basics quickly with hands-on practice.
What will I learn in this SQL course?
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.
How long does it take to learn SQL?
You can learn the basics of SQL in a few days, but becoming confident may require practice with real datasets and projects.
Will I get hands-on practice?
Yes, the course includes practical exercises to help you apply SQL concepts and build real skills.
Is SQL useful for my career?
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.
Can SQL help me become a data analyst?
Yes, SQL is a fundamental skill for data analysts. It allows you to query data, generate reports, and extract insights for decision-making.
What tools or software will I use?
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/.
Is SQL used with other tools like Python or Power BI?
Yes, SQL is often used alongside tools like Python and Power BI for data analysis, reporting, and visualisation.
How is the course delivered?
The course is instructor-led and can be attended online or in person.
Will I receive a certificate?
Yes, you will receive a certificate of completion after successfully finishing the course.