Course

SQL Fundamentals In-Depth («SQLV2»)

This course extends, deepens and completes the solid SQL General Fundamentals acquired in the SQL Standard course.
Duration 2 days
Price 1'800.–
Course documents Digicomp Courseware (German)
Alternative learning format available: SQL-Standard – In-depth («SQLV»)

Course facts

Key Learnings
  • 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
Content

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
Target audience

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.

Requirements
  • 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

    Standard SQL-3 («SQL»)

    2 days
    • Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
    CHF
    1'800.–
Additional information

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.

Download

Questions

Any questions?
First name
Last name
Company optional
Email
Phone
I would like to book this course as a company course
First name
Last name
Company optional
Email
Phone
Number of participants
Desired course location
Start date (DD.MM.YYYY)
End date (DD.MM.YYYY)

Choose your date

19
May
2025
20
May
2025
Zürich
German
Timetable
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.
7
Oct
2025
8
Oct
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
7
Oct
2025
8
Oct
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
18
Dec
2025
19
Dec
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
18
Dec
2025
19
Dec
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
Next date
19
May
2025
20
May
2025
Zürich
German
Timetable
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.
If you register now, this course is guaranteed to take place!
CHF 1’800.-
exkl. 8.1% Mwst.

Further courses

Advanced Hands-on SQL Experience («ADVSQL»)

2 days
CHF
1'950.–