pds-it
['Product detail page','no']
Databases / SQL
The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration

SQL - The basic training

Online
2 days
German
Download PDF
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
36173
Venue
Online
6 dates
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
36173
Venue
Online
6 dates
Become a certified
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training for your Employees only - exclusive and effective.
Inquiries
In cooperation with
In this course you will get to know the standard version of SQL. You will deepen and consolidate your knowledge in many practical exercises, focusing on the generally applicable concepts.
Contents

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. basics of SQL

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

3. data retrieval, data evaluation and 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. add data

  • INSERT (VALUES, SELECT)
  • UPDATE
  • DELETE

 

5. optional topics (if there is enough time):

Data definition language (DDL)

  • CREATE DATABASE
  • CREATE TABLE
  • Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE )
  • DROP TABLE
  • CREATE VIEW
  • ALTER VIEW
  • DROP VIEW
  • CREATE PROCEDURE

Data control language (DCL)

  • Transaction management
  • COMMIT & ROLLBACK
  • GRANT & REVOKE

 

Requirements: 

  • Sound experience in dealing with EDP
  • Basic knowledge of relational databases
  • Enjoy analytical thinking and the ability to abstract and imagine

Additional info: 

This course is designed to be vendor-independent. So it doesn't matter whether you work with Access, Oracle, DB/2, SQL Server, mySQL, SQL Server Express or other database management systems - the basics are the same everywhere.

Your benefit
  • Acquisition of basic SQL knowledge and everything that is important for the secure mastery of standard SQL
  • Completion of numerous practical exercises for immediate added value in everyday working life
  • Receive helpful practical tips from the specially developed course materials
trainer
Peter Jacobs
Methods

This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.

Final examination
Recommended for
  • Programmers, PC administrators and other people who work with an SQL-capable database or want to create applications using the SQL possibilities of the database system.
  • People who want to find out systematically about SQL, its possibilities, limitations and significance.
Start dates and details

Form of learning

Learning form

16.7.2025
Online
Few places available
Implementation secured
Online
Few places available
Implementation secured
30.9.2025
Online
Few places available
Implementation secured
Online
Few places available
Implementation secured
28.10.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
19.11.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
10.12.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
23.2.2026
Online
Places free
Implementation secured
Online
Places free
Implementation secured

The training is carried out in cooperation with an authorized training partner.

The latter collects and processes data under its own responsibility. Please take note of the corresponding privacy policy

Do you have questions about training?
Call us on +49 761 595 33900 or write to us at service@haufe-akademie.de or use the contact form.