Course

Standard SQL-3 («SQL»)

In this course you will learn the standard version of SQL. In many practical exercises, you will deepen and consolidate them, focusing on general concepts.
Duration 2 days
Price 1'800.–
Course documents New: Digicomp training material includes integrated LAB-Engine
Interested in even more SQL? SQL Fundamentals In-Depth

Course facts

Key Learnings
  • Gaining basic SQL knowledge and everything that is important for the secure mastery of standard SQL
  • Completing numerous practical exercises for immediate added value in everyday work
  • Receiving helpful practical tips from the specially developed Digicomp course materials
Content

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

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.

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

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.

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

7
Apr
2025
8
Apr
2025
Lausanne
French
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.
14
Apr
2025
15
Apr
2025
Virtual Training
German
Timetable
Guaranteed to take place. Register now!
CHF 1’800.-
exkl. 8.1% Mwst.
Guaranteed to take place. Register now!
CHF 1’800.-
exkl. 8.1% Mwst.
12
May
2025
13
May
2025
Berne
German
Timetable
Guaranteed to take place. Register now!
CHF 1’800.-
exkl. 8.1% Mwst.
Guaranteed to take place. Register now!
CHF 1’800.-
exkl. 8.1% Mwst.
13
May
2025
14
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.
22
May
2025
23
May
2025
Geneva
French
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
16
Jun
2025
18
Jun
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
16
Jun
2025
18
Jun
2025
Basel
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
16
Jun
2025
18
Jun
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
3
Jul
2025
4
Jul
2025
Lausanne
French
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
16
Jul
2025
17
Jul
2025
Virtual Training
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
11
Aug
2025
12
Aug
2025
Geneva
French
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
25
Aug
2025
26
Aug
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
25
Aug
2025
26
Aug
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
25
Aug
2025
26
Aug
2025
Basel
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
23
Sep
2025
24
Sep
2025
Lausanne
French
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
30
Sep
2025
1
Oct
2025
Virtual Training
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
28
Oct
2025
29
Oct
2025
Zürich
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
6
Nov
2025
7
Nov
2025
Geneva
French
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
19
Nov
2025
20
Nov
2025
Virtual Training
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
10
Dec
2025
11
Dec
2025
Berne
German
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
10
Dec
2025
11
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
Lausanne
French
Timetable
CHF 1’800.-
exkl. 8.1% Mwst.
CHF 1’800.-
exkl. 8.1% Mwst.
Next date
7
Apr
2025
8
Apr
2025
Lausanne
French
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

SQL-Standard – In-depth («SQLV»)

1 day
CHF
1'800.–

SQL Fundamentals In-Depth («SQLV2»)

2 days
CHF
1'800.–

Introduction SQL Server Administration («SQLADM»)

2 days
CHF
1'800.–

Advanced Hands-on SQL Experience («ADVSQL»)

2 days
CHF
1'950.–