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

Legend: Booked upFew seats leftSeats available

Price per Person:
2.300,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