Trainings for MS SQL Server and Oracle

For decades, the first contact with a database has been the query language SQL, and I teach T-SQL for MS SQL Server and Oracle SQL. You can then use T-SQL and Oracle PL/SQL to develop database applications. PL/SQL even allows you to carry out data science and Data Mining directly in Oracle DB.

These seminars are aimed at database developers, analysts and administrators who want to deepen their SQL knowledge or use PL/SQL and T-SQL for complex business logic.

MS SQL Server

A T-SQL seminar teaches the basics and advanced techniques for the Microsoft SQL Server query language. In order to develop business intelligence solutions, you will then need additional technologies such as MS Power BI or SSAS.

DB Development

  • Queries and analyses with T-SQL
  • DB development
  • Administration
  • XML/JSON integration

Business Intelligence

  • Integration Services / SSIS
  • Analysis Services / SSAS for Tabular Model and DAX
  • MS Power BI withPower Query / M

Oracle

These seminars teach both classic SQL techniques and PL/SQL, the procedural extension of SQL in Oracle. In addition, PL/SQL can be used to perform data mining with the Oracle DB.

DB Development

  • Queries and analyses with Oracle SQL
  • DB development with Oracle PL/SQL
  • XML/JSON integration

Business Intelligence

  • Oracle Data Mining withOracle Data Miner
  • Oracle Data Mining with PL/SQL
  • Oracle Statistik with SQL