Course # MS1/SQL - US – SQL Server 2014

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

Legend: Booked upFew seats leftSeats available

Price per Person:
3.100,00 $

5 days.


  • Basics of databases:
    Basic concepts; requirements; Entity Relationship Model (ERM)
  • DDL (Data Definition Language):
    Create/change/delete databases and tables; save/restore databases; data types; field attributes
  • DML (Data Manipulation Language):
    Queries on tables; aggregation functions; create/change/delete data sets
  • Programming:
    Variables; case differentiation; conversion of data types; dynamic SQL; error handling; views; temporary tables; user-defined functions; stored procedures; cursor; trigger; transactions
  • Further features:
    Agent; Profiler; Linked Server 
  • Examples Plant iT (dbIdc):
    Data organisation of the automation objects; DBCom (example: counter); FiFo User SP (lock tank); Create SP to generate an order name

Understanding of MS SQL Server 2014 basic functions. Analysis and creation of queries, functions and procedures. 
Understanding of Management Studio and programming basic extensions in the Plant iT database. 

Initial programming experience with PLCs or PC systems is advantageous.