Program SQL Seminar

Duration: 2 days, start 09:00 am until 05:00 pm
Members: up to 6 persons

Targets:
Knowledges about the functionality of databases,
Qualifaction to create practice views,
Analysis of existing databases,
Data handling on databases

Course fee:
For each person for both days in summary 550,- Euro with additional 19% vat.
(In the fee of 550 50 for lunch are included)
Each participant will receive a personal license of our powerfull software tool SQL-Key Version 5 as CD (normal price 49,- Euro).
Within the delivery an ACCESS database is included. This contains multiple usefull informations about all common databases. An overview of the most common functions is added as an Excel file.

Agenda:
Overview on the 12 most popular databases
Methods to connect to a database
DSN and DBMS
Datbase analysis
Tables and field types
System tables
Views
General structure of a common view
Views with subselect
Views with aliases for fields and tables
Views with union/join
Aggregatet views (Pivot tables) with having
Case sensitivity of tables, field names and field contents
Handling of data with NULL, specials for oracle and sybase
Data statements
Functions
Functions on strings
Conversions
Date functions
Aggregation functions
Database design
Delete statements
Rights