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 |
|---|
Legend: Booked upFew seats leftSeats available
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.