Course PRG/SQL – MS SQL 2019 Basic training

Database basics with examples from the Plant iT database

Online registration:
Please select one of the available dates and click the red "Sign up now"-button next to it. You will be forwarded to the registration form. Should you have any questions regarding registration you can contact us: +49 9132 777 0.

Date Language Location Status Registration
03/13/23 - 03/17/23 German Herzogenaurach
Sign up now
10/09/23 - 10/13/23 German Herzogenaurach
Sign up now

Legend: Booked upFew seats leftSeats available

Price per Person:
2.450,00 €

Duration:
5 days.

Target: 
In this course, the participants learn the structure of a database and how to handle data within a database management system. After the training, you will be able to independently retrieve and manipulate data from a database. You will also get to know the basic relationship between a database and the ProLeiT systems.

Prerequisite: 
None

Contents:

  • Basics of databases (structure of databases)
  • Structured Query Language (database queries)
  • Data Definition Language (creation of database objects)
  • Data Manipulation Language
  • SQL programming (case discrimination, error handling, procedures, etc...)
  • Useful applications (performance analysis, SQL jobs)
  • Database reference to ProLeiT systems (depending on participant which system)

Back