Databases

Database courses for administration, analysis, and troubleshooting

Icon Datenbanken

Our database courses offer comprehensive knowledge of AWS™, Microsoft™ SQL, Oracle™, SAP™ HANA, and other systems. From administration and automation to data analytics, high availability, monitoring, and troubleshooting, experienced trainers impart practical know-how for efficient and secure database management.

Ideal for IT professionals who want to operate and evaluate their databases optimally.

AWS™

Data Analytics

AW271: Building Data Analytics Solutions using Amazon Redshift
Creating data analytics solutions with Amazon Redshift, Data Lakes, Pipelines; data ingestion, storage, processing, ML workloads; for Data Engineers; prerequisi...

1 Day

0 Dates

With instructor

AW272: Building Batch Data Analytics Solutions on AWS™
Batch Data Analytics Solutions with EMR; Apache Spark, Hadoop, Hive, HBase, AWS™ Glue Integration; for Data Engineers, Architects; AW120, AW210, AW470 required

1 Day

0 Dates

With instructor

AW274: Data Warehousing on AWS™
Designing cloud-based Data Warehouse solutions with Amazon Redshift; Data analysis, ML models, SQL QEV2, Security; DBAs, Architects; AWS™ fundamentals required

3 Days

0 Dates

With instructor

Databases

AW280: Build Modern Applications with AWS™ NoSQL Databases
Development of Modern Cloud Applications with AWS™ NoSQL Databases; DynamoDB, DocumentDB, ElastiCache, Redis; for Database Developers; AWS™/NoSQL Knowledge Requir...

1 Day

0 Dates

With instructor

AW950: Planning and Designing Databases on AWS™
Database Design and Planning for AWS™ Cloud Mastery; AWS™ RDS, Aurora, DynamoDB, DocumentDB, Neptune, QLDB, ElastiCache; Architects, Developers; AWS™ Fundamentals

3 Days

0 Dates

With instructor

Oracle™

Oracle™ SQL

DB100: Oracle™ SQL
Data modeling, DDL, DML, DCL, database objects, privileges, SQL scripts; for Developers, Programmers, Users; IT and Unix/Windows knowledge required

4 Days

0 Dates

With instructor

Administration

DB110: Oracle™ Admin Basics
Installation, configuration, and administration of Oracle™ databases; architecture, backup, recovery, user administration; for DB & System Admins; DB100 required

5 Days

0 Dates

With instructor

DB115: Oracle™ Admin Advanced
Advanced Oracle™ DB administration; partitioning, tuning, security, flashback, packages, memory management; for DB & System Administrators; prior knowledge requi...

5 Days

0 Dates

With instructor

NetBackup

BR320: NetBackup 10.x/11.x for Oracle™ Databases
Oracle™ DB backup/recovery with NetBackup; RMAN, backup mode, standby DB, intelligent policy, block level incremental; for Backup/DB Admins; BR300 required

5 Days

0 Dates

With instructor

Microsoft™

Administration

DB300: MS SQL Server 2022 Administration
Administration and configuration of MS SQL Server 2022; installation, security, backup, automation; for Administrators; server and AD knowledge required

5 Days

1:  2025-11-03 -  2025-11-07 (de)
2:  2026-03-16 -  2026-03-20 (de)

With instructor

Programming

DB310: SQL Server 2016/17/19 Programming with T-SQL
T-SQL programming and queries; SELECT, JOIN, stored procedures, functions, tables, indexes; for Developers, Administrators; basic DB knowledge required

4 Days

0 Dates

With instructor

Troubleshooting

DB320: SQL Server Troubleshooting & Tuning
Optimization of SQL Server performance through query techniques, indexes, configuration, high availability; for DBAs, SQL users; pior knowledge required

3 Days

0 Dates

With instructor

Additional Topics

PostgeSQL

DB200: PostgreSQL Administration Fundamentals
Productive PostgreSQL operations & database administration; installation, backup, recovery, tuning, security; for PostgreSQL Admins; prior knowledge required

4 Days

1:  2026-03-02 -  2026-03-05 (de)
2:  2026-10-05 -  2026-10-08 (de)

With instructor

Logfile Analysis

LI300: Logfile Analysis with Elasticsearch, Logstash, Kibana
Logfile analysis and monitoring; log sources, ElasticSearch, MongoDB, Logstash, Kibana, Graylog, Fluentd; for System Administrators; Linux knowledge required

4 Days

0 Dates

With instructor

Monitoring

LI310: Monitoring with Prometheus & Grafana
Set up and manage monitoring systems; Prometheus server, PromQL, Alertmanager, Grafana dashboards, metrics; for DevOps, Admins; Linux basics required

3 Days

1:  2025-12-01 -  2025-12-03 (de)
2:  2026-03-16 -  2026-03-18 (de)
3:  2026-06-29 -  2026-07-01 (de)

With instructor