Standard SQL-3 («SQL»)

1 Repetition of the basic concepts of relational databases

• Database
• Table (entities, attributes)
• Data types (value ranges)
• Primary, foreign key
• Relations
• Data Consistency, Referential Integrity
• View
• Index
• ERM

2 SQL basics

• History
• Application (basic concept)
• SQL properties
• SQL syntax diagrams
• Naming conventions for objects

3 Data retrieval, data evaluation and data manipulation (DML)

• SELECT
• Simple queries
• Constant Columns, Calculated Columns, Aliases
• DISTINCT
• ORDER BY
• TOP
• WHERE
• Aggregate functions
• GROUP BY / HAVING
• JOIN (INNER, OUTER, FULL, SELF, CROSS)
• Subqueries
• UNION
• SELECT INTO

4 Adding data

• INSERT (VALUES, SELECT)
• UPDATE
• DELETE

5 Optional Topics (if enough time available):

• Data Definition Language (DDL)
  • CREATE DATABASE
  • CREATE TABLE
  • Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE )
  • DROP TABLE
  • CREATE VIEW
  • OLD VIEW
  • DROP VIEW
  • CREATE PROCEDURE
• Data control language (DCL)
  • Transaction management
  • COMMIT & ROLLBACK
  • GRANT & REVOKE

Programmers, PC administrators and other people who want to work with an SQL-enabled database or create applications using the SQL capabilities of the database system. People who want to systematically inform themselves about SQL, its possibilities, limitations and meaning.

• Sound experience in dealing with EDP
• Basic knowledge of relational databases
• Enjoy analytical thinking as well as abstraction and imagination skills

This course is manufacturer-independent. So it does not matter if you work with Access, Oracle, DB/2, SQL Server, mySQL, SQL Server Express or other database management systems – the basics are always the same.