Behind every dashboard, report, and business decision sits a database, and the person who can query it well controls the information everyone else is waiting for. This Training Course from the Arab British Fellowship Training Academy takes participants from writing their first SELECT statement to optimizing complex queries against real relational databases using SQL.

Across ten intensive days, the course builds skill in layers: starting with core commands and table design, moving through joins, filtering, and aggregate functions, and finishing with performance tuning, stored procedures, and security. It suits developers, data analysts, and database administrators alike, along with anyone who wants SQL to become a genuine professional skill rather than a set of memorized commands.

Who Should Attend?

• Developers and IT professionals who need to query and manage relational databases daily
• Data analysts and anyone building advanced queries for reporting and analysis
• Database administrators responsible for structure, performance, and access control
• Beginners who want a structured path into SQL and relational database management

Knowledge and Benefits:

After completing the program, participants will be able to master the following:

• Write and troubleshoot SQL queries confidently, from simple SELECT statements to multi-table joins
• Create, modify, and manage databases and tables using SQL commands
• Apply advanced functions, including aggregation, filtering, and joins, to solve real data problems
• Understand the fundamentals of query performance and how to optimize slow queries
• Build a foundation for advancing into database administration or data analysis roles

Module 1: Relational Database Foundations and SQL Syntax

• How relational databases are structured and why SQL is the standard language for them
• Core commands: SELECT, INSERT, UPDATE, DELETE, and the DML versus DDL distinction
• Working with SQL data types: text, numbers, and dates

Module 2: Creating, Modifying, and Querying Data

• Creating and altering tables with CREATE TABLE, ALTER TABLE, and DROP TABLE
• Inserting, updating, and deleting records safely
• Retrieving data with SELECT, filtering with WHERE, and sorting with ORDER BY

Module 3: Combining and Filtering Data Across Tables

• Joining tables with INNER, LEFT, RIGHT, and FULL JOIN
• Building complex conditions with AND, OR, NOT, BETWEEN, IN, and LIKE
• Handling NULL values and missing data correctly

Module 4: Aggregating and Nesting Queries

• Aggregate functions: COUNT, SUM, AVG, MAX, MIN with GROUP BY and HAVING
• Writing subqueries inside SELECT and WHERE clauses
• Correlated versus non-correlated subqueries

Module 5: Transactions, Access Control, and Query Optimization

• Transactions, COMMIT, and ROLLBACK for data integrity
• Managing permissions with GRANT and REVOKE
• Indexing, execution plans (EXPLAIN), and techniques for faster queries

Module 6: Working with Dates, Location Data, and Custom Functions

• Date and time functions for formatting, comparison, and filtering
• Introduction to geospatial data and location-based queries
• Creating and using user-defined functions (UDFs)

Module 7: Automating Logic with Procedures and Triggers

• Building and calling stored procedures
• Automating actions with triggers for INSERT, UPDATE, and DELETE events
• Working across multiple databases and linked queries

Module 8: Managing Large Datasets and Protecting Data

• Temporary tables and techniques for handling large datasets
• Backup and recovery strategies for SQL databases
• Enforcing data integrity with primary keys, foreign keys, and constraints