SQL Fundamentals Training in Cork, Ireland

This course introduces participants to the fundamentals of Structured Query Language (SQL) and relational databases. Through a mix of concepts, guided labs, and exercises, learners will gain the ability to query, manipulate, and manage data using SQL. The training is designed for beginners and those looking to strengthen their data handling skills.

Introduction & Core Concepts

Session 1: Getting Started with Databases & SQL

• What is a database? (Relational vs Non-relational)
• Overview of RDBMS (MySQL, SQL Server, Oracle, PostgreSQL)
• SQL command categories: DDL, DML, DCL, TCL

Session 2: Working with Tables

• Schema, tables, rows, and columns
• Data types (string, numeric, date/time)
• Creating tables (CREATE TABLE)
• Modifying tables (ALTER, DROP)

Session 3: Basic Data Operations

• Inserting data (INSERT)
• Updating data (UPDATE)
• Deleting data (DELETE)
• Truncating tables

Session 4: Querying Data with SELECT

• SELECT basics (single column, multiple columns, all columns)
• Using aliases (AS) for readability
• Filtering data with WHERE
• Comparison operators (=, <>, <, >, BETWEEN, IN, LIKE)

Intermediate Querying & Best Practices

Session 5: Sorting & Limiting Results

• ORDER BY (ASC/DESC)
• LIMIT / TOP clauses

Session 6: Functions in SQL

• String functions (UPPER, LOWER, CONCAT, LENGTH, TRIM)
• Numeric functions (ROUND, CEIL, FLOOR)
• Date functions (NOW, DATEADD, DATEDIFF, EXTRACT)

Session 7: Aggregations & Grouping

• Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• GROUP BY and HAVING clauses

Session 8: Joins & Relationships

• Primary & foreign keys
• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
• Self-joins & cross joins (conceptual)

Session 9: Subqueries & Nested Queries

• Single-row subqueries
• Multi-row subqueries (IN, ANY, ALL)
• Correlated subqueries (intro)

Hands-on Exercises

Summary and Conclusion