SQL Fundamentals In-Depth («SQLV2»)

• Extension and deepening of the solid SQL Fundamentals acquired in the SQL Standard course
• Lab- and practice-oriented learning
• In the final project, there is the opportunity to practically incorporate the entire scope of SQL basics

1 Data Definition Language (DDL)

• CREATE, ALTER, DROP
• DATABASE, TABLE, VIEW
• ADD CONSTRAINT
  • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE
  • DEFAULT
  • CHECK

2 Extension of SQL Basic Elements

• CASE Statement: Simple and Searched
• COUNT(DISTINCT)

3 Working with Functions

• Working with Text Functions
• Working with DATETIME Functions
• Working with NULL Values
• Data Type Conversion and Formatting
• Notes on Dialect Differences

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)

• Exploring the Database Model of Existing Databases
  • Meta Information Tables
  • Database Diagrams
• Data Control Language (DCL)
  • Transaction Management
  • COMMIT & ROLLBACK
  • GRANT & REVOKE
• Extended Q&A
• Practical Tips for Everyday SQL

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.

• Attendance of the Standard SQL-3 course is a prerequisite; the same course database is used
• Enjoyment of analytical thinking as well as abstraction and imagination skills

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.