Course # MS1/SQL – SQL Server 2014
Database basics with examples from the Plant iT database
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.
|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:
5 days. Drinks and lunch are included.
- 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
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.