Introduction to SQL

Beginner
Physcially in Classroom
Total 6 hours in class

Multi-Day Course
2-7 learners per class

Requirements

Basic computer literacy

Familiarity with spreadsheet applications (Excel, Google Sheets)

Software Requirements

Primary Environment Setup

Database Engine: Microsoft SQL Server 2019 Express Edition (Free)

Management Tool: SQL Server Management Studio (SSMS) 17.0+

Compatibility: Also supports SQL Server 2012/2014/2017/2022

Alternative Options

MySQL Community Edition (free, cross-platform)

PostgreSQL (open-source alternative)

SQLite (lightweight, file-based)

Cloud-Based: Azure Data Studio with Docker

Online SQL Editor: SQLiteOnline.com

Available Dates & Times

Time Zone:

Dates	Price
Tue 18 Nov 2025 - Tue 18 Nov 2025 10:00 AM - 04:00 PM (BT) Tuesday (6-hour over 1-day)	£240 Enrol Now
Mon 26 Jan 2026 - Mon 26 Jan 2026 10:00 AM - 04:00 PM (BT) Monday (6-hour over 1-day)	£240 Enrol Now

Class Details

SQL (Structured Query Language) is the fundamental programming language for managing data in relational database management systems. As one of the most critical skills in today's data-driven business world, SQL proficiency is essential for professionals across various technical and business roles, including data analysts, developers, marketing, operations, finance, and sales specialists.

This comprehensive course provides a practical foundation in SQL, enabling you to interact with databases confidently. You'll progress from basic database concepts to advanced query techniques through hands-on exercises and real-world scenarios.

Course Outline

Database Fundamentals
- Understanding Databases and DBMS
- Introduction to Relational Database Concepts
- Exploring SQL Editors
- Database Design Principles

SQL Foundation
- Introduction to SQL
- Creating Your First Database
- Using the USE Command
- Drop Databases using SQL
- Creating and managing Tables
- Commenting and Saving SQL

Data Manipulation Language (DML)
- Introduction to DML Operations
- Inserting Data with INSERT Statements
- Updating Records Using UPDATE
- Removing Data with DELETE Statements

Data Retrieval Fundamentals
- Introduction to the SELECT Statement
- Retrieving Specific Columns
- Finding Unique Values with DISTINCT
- Column Concatenation Techniques
- Creating Calculated Fields
- Limiting Results with TOP Clause

Data Filtering and Sorting
- Precision Filtering with WHERE Clause
- Using Logical Operators (AND, OR, NOT)
- Pattern Matching with LIKE Operator
- Handling NULL Values (IS NULL, IS NOT NULL)
- Sorting Results with ORDER BY

SQL Built-In Functions
- Introduction to Built-In Functions
- Conversion Functions (CONVERT, CAST)
- Mathematical Operations and Functions
- String Manipulation Functions
- Date and Time Functions

Advanced SQL Concepts
- Introduction to Subqueries
- Using Aggregate Functions (COUNT, SUM, AVG, MAX, MIN)
- Data Aggregation with GROUP BY
- Combining Data from Multiple Tables (JOIN)

Tutors

Younus Kazi

A professional Online and Classroom Teacher

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, deve...
View More...