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
On request English Chicago
Sign up now

Legend: Seats availableFew seats leftBooked up

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.

<< back

KWS SAAT AG, Germany Heineken Jiashan, China Privatbrauerei Erdinger Weißbräu Werner Brombach GmbH, Germany Brillux GmbH & Co. KG, Germany Hilti GmbH Industriegesellschaft für Befestigungstechnik, Germany WARSTEINER Brauerei Haus Cramer KG, Germany Glockenbrot Bäckerei GmbH & Co. oHG, Germany Grolsche Bierbrouwerij Nederland B.V., Netherlands Carlsberg Danmark A/S FRANKEN BRUNNEN GmbH & Co. KG, Germany Anheuser Busch InBev, USA
to our references


Do you wish to download specialist articles, application stories or brochures from ProLeiT? Then please complete the mandatory fields * and confirm your entries by clicking on the “Submit” button. A link will be subsequently sent to the stated e-mail address. Click on this link to log on and to download all available files.


By sending the contact form that I have completed I agree to the use and storage of my information by ProLeit AG for the purposes of processing this enquiry and that I agree to the online privacy statement.