AI & Data

Fundamentals of Relational Databases Training

The Fundamentals of Relational Databases training is an introductory course aimed at familiarizing participants with the foundational concepts of relational databases.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 Anyone who wants to learn the basics of relational databases and start using them in their daily work.
2 Recommended for roles such as DevOps, Developer, Data Engineer, Data Scientist.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

Containerization

✓

Linux operating system (virtual environment acceptable)

✓

Windows

Program · 11 modules

What we actually do

M01
Introduction to Databases
  • · What is a database?
  • · Relationships
  • · Best practices in database design
  • · Setting up the working environment (optional)
M02
Creating Data Structures
  • · Creating and modifying tables
  • · Attributes and constraints
  • · Relationships (primary and foreign keys)
  • · Dropping tables
  • · Inserting data into tables
M03
Basics of Data Retrieval
  • · SELECT keyword
  • · Unique rows
  • · Sorting and aliases
  • · Limiting returned rows
M04
Built-in Functions
  • · Numeric and mathematical functions
  • · Text functions
  • · Date and time functions
  • · Converting and formatting functions
M05
Filtering Data
  • · WHERE clause
  • · Logical operators
  • · BETWEEN and IN operators
  • · IS NULL and LIKE operators
M06
Grouping Data
  • · Aggregate functions
  • · GROUP BY clause
  • · HAVING clause
M07
Data Sets and Joins
  • · Subqueries
  • · JOIN operations
  • · UNION of data sets
M08
DML Commands
  • · Updating data (UPDATE)
  • · Deleting data (DELETE)
M09
Programming Basics
  • · Functions
  • · Procedures
  • · Triggers
M10
Database Objects
  • · Views
  • · Indexes
  • · Temporary tables
M11
ACID and Permissions
  • · Creating users
  • · Granting and revoking permissions
  • · Understanding the ACID acronym
  • · Transactions
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced Power BI Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced RPA Developer Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →