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/04/08 - 19/04/12 German Herzogenaurach
Sign up now
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
Carlsberg Danmark A/S Anheuser Busch InBev, USA Tucher Bräu GmbH & Co. KG, Germany Glockenbrot Bäckerei GmbH & Co. oHG, Germany FRANKEN BRUNNEN GmbH & Co. KG, Germany J. Bauer GmbH & Co. KG, Germany Privatbrauerei Erdinger Weißbräu Werner Brombach GmbH, Germany BASF Construction Polymers GmbH, Germany WARSTEINER Brauerei Haus Cramer KG, Germany Heineken Jiashan, China Brillux GmbH & Co. KG, Germany
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.