1 Data Definition Language (DDL)
2 Extension of SQL Basic Elements
3 Working with Functions
4 Final Project
The final project brings together all topics from the courses "SQL Standard" and "SQL Fundamentals In-Depth": SELECT, INSERT, UPDATE, DELETE, CREATE/ALTER TABLE, ADD CONSTRAINT, JOIN, GROUP BY, HAVING, ORDER BY
5 Optional Topics (time permitting/in consultation with the group)
This course is aimed at programmers, PC support staff, and other individuals who work with a SQL-capable database or want to create applications using the SQL capabilities of the database system, as well as individuals who want practical knowledge about SQL, its possibilities, limitations, and significance.
This course is manufacturer-independent except for the "Functions" chapter and uses standard SQL, which is supported by all relational databases (Access, Oracle, DB/2, SQL Server, MySQL, SQL Server Express, etc.). In the Functions chapter, dialect differences are noted.