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 $

Duration:
5 days.

Content:

  • 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

Target: 
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. 

Prerequisite:
Initial programming experience with PLCs or PC systems is advantageous.

<< back



References
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

Register

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.

Captcha

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.