Course # MS1/SQL – 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
19/10/14 - 19/10/18 German Herzogenaurach
Sign up now
On request English Herzogenaurach
Sign up now

Legend: Seats availableFew seats leftBooked up

Price per person:
1,900.00 €

Duration:
5 days. Drinks and lunch are included.

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
Grolsche Bierbrouwerij Nederland B.V., Netherlands Glockenbrot Bäckerei GmbH & Co. oHG, Germany WARSTEINER Brauerei Haus Cramer KG, Germany Privatbrauerei Erdinger Weißbräu Werner Brombach GmbH, Germany Hilti GmbH Industriegesellschaft für Befestigungstechnik, Germany Carlsberg Danmark A/S Heineken Jiashan, China FRANKEN BRUNNEN GmbH & Co. KG, Germany JUHAYNA, Egypt BASF Construction Polymers GmbH, 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.