Understand the fundamentals of relational databases & apply SQL in practice

Databases are a central component of modern IT solutions. They enable the structured storage, management, and analysis of large volumes of data. This seminar provides you with a solid understanding of database concepts and working with SQL — independent of any specific database system. You will learn the essential elements of relational databases, understand key principles such as keys, normalization, and referential integrity, and work extensively with SQL commands based on the ANSI standard.

Our experienced trainers will show you:

• how relational databases are structured and how database design works
• how SQL is structured and how different SQL dialects vary
• how to query, filter, sort, group & combine data
• how to join tables (JOINs), use subqueries & perform set operations
• how to insert, update, delete data and create or modify tables
• how to manage transactions & user permissions

Your benefits at a glance

• Solid foundation for working with relational databases
• Understand and apply ANSI SQL independently of specific systems
• Practical preparation for use with IBM, Oracle, MS SQL, MySQL and more
• Clearly structured introduction to database design & normalization
• Confident use of SELECT, JOIN, subqueries & DML commands
• Immediately applicable for business departments, IT projects, reporting & development

Seminar Content

Overview of Database Design

• Database models & structure of relational systems
• Designing & organizing databases
• Relational data model
• Primary & foreign keys
• Normalization
• Referential integrity

SQL Overview & System Dialects

• ANSI SQL fundamentals
• Differences between SQL variants (Oracle, IBM, Microsoft, Sybase, etc.)

SELECT – Creating Queries

• Basics of the SELECT statement
• Column selection, aliases, WHERE filters
• ORDER BY for sorting
• DISTINCT / UNIQUE to remove duplicates
• LIKE, IN & BETWEEN as search operators

Grouping, Functions & Conditions

• GROUP BY and HAVING
• String, date & mathematical functions
• Logical operators & complex condition chains

JOIN – Linking Tables

• INNER JOIN
• OUTER JOIN (LEFT / RIGHT)
• FULL JOIN
• Set operations: UNION, INTERSECT

Subqueries & Advanced Queries

• Subqueries in the FROM clause
• Subqueries in the WHERE clause
• Nested query concepts

Modifying Data (DML)

• INSERT – adding records
• UPDATE – making changes
• DELETE – removing records

Creating & Managing Tables (DDL)

• CREATE – creating new tables
• ALTER – modifying tables
• DROP – deleting tables
• Overview of additional commands (transactions, user permissions)

Target Audience

• Employees from business departments
• Application developers
• Organizers & IT project managers
• Entry-level database administrators

Prerequisites

• Basic user skills in Windows
• Initial experience with a database system is helpful but not required