Name: Structured Query Language (SQL)
Price: 25 GBP
Availability: InStock

Structured Query Language (SQL)

This course is designed for absolute beginners who want to learn SQL from scratch and start working with databases confidently. Students will learn how to store, retrieve, filter, sort, and manage data using SQL queries. The course focuses on building a strong foundation through practical examples and hands-on exercises using real-world database scenarios.

By the end of this course, learners will be able to write SQL queries, work with tables, filter data, use functions, and perform basic database operations confidently.

Course Prerequisites:

None

What you will learn?

1. Introduction to Databases

What is a database?
Types of databases
Relational databases
Tables, rows, and columns
Primary keys and foreign keys
Introduction to SQL

2. Setting Up the Environment

Installing database software
Introduction to MySQL / Oracle / PostgreSQL
Database tools overview
Writing and executing SQL queries

3. SQL Basics

SQL syntax
Understanding statements
Comments in SQL
SQL keywords

4. Retrieving Data

SELECT statement
Selecting specific columns
Selecting all columns
Using aliases

5. Filtering Data

WHERE clause
Comparison operators
Logical operators
BETWEEN
IN
LIKE
NULL values

6. Sorting and Limiting Data

ORDER BY
ASC and DESC
LIMIT / FETCH / ROWNUM basics

7. Working with Single Row Functions

String functions
Number functions
Date functions
Conversion functions

8. Aggregate Functions

COUNT
SUM
AVG
MIN and MAX

9. Grouping Data

GROUP BY
HAVING clause

10. Creating and Managing Tables

CREATE TABLE
Data types
Constraints
PRIMARY KEY
FOREIGN KEY
UNIQUE
NOT NULL

11. Modifying Data

INSERT
UPDATE
DELETE

12. Basic Joins

INNER JOIN
LEFT JOIN
RIGHT JOIN

13. Practice Exercises

Real-world query exercises
Mini database projects
Query challenges

14. Final Project

Design a simple database
Create tables
Insert sample data
Write business queries

Join us: to stay updated on new courses, discounts, free learning opportunities, and more

Join us toGrow Skills,together!

Get Updates