qSkills Logo

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

On request

With instructor

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

On request

With instructor

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

On request

With instructor

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

On request

With instructor

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

On request

With instructor

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

On request

With instructor

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

On request

With instructor

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

On request

With instructor

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:  2026-03-16 -  2026-03-20 (de)
With instructor

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

On request

With instructor

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

On request

With instructor

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

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

On request

With instructor

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:  2026-03-16 -  2026-03-18 (de)
2:  2026-06-29 -  2026-07-01 (de)
With instructor

With instructor