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 advanced training

Online
2 days
German
Download PDF
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
42149
Venue
Online
2 dates
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
42149
Venue
Online
2 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 just for your employees - exclusive and effective.
Inquiries
In cooperation with
This course extends, deepens and completes the generally valid, solid SQL basics acquired in the SQL standard course.
Contents

1. data definition language (DDL)

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

 

2. extension of the SQL base elements

CASE Statement: Simple and Searched

COUNT(DISTINCT)

 

3. working with functions

  • Working with text functions
  • Working with DATETIME functions
  • Dealing with NULL values
  • Data type conversion and formatting
  • Notes on dialect differences

 

4. final project

The final project summarizes all topics of the courses "SQL Standard" and "SQL Advanced":
SELECT, INSERT, UPDATE, DELETE, CREATE/ALTER TABLE, ADD CONSTRAINT, JOIN, GROUP BY, HAVING, ORDER BY.

 

5. optional topics (if there is time/in consultation with the group)

  • Explore the database model of existing databases
    • Use meta information tables
    • Create database diagrams
  • Data Control Language (DCL):
    • Transaction management
    • COMMIT & ROLLBACK
    • GRANT & REVOKE
  • Extended Q&A
    • Practical tips for everyday SQL work

Requirements: 

Basic knowledge of SQL is a prerequisite; enjoyment of analytical thinking and the ability to abstract and imagine

Additional info:

With the exception of the "Functions" chapter, this course is manufacturer-independent and uses standard SQL, which is supported by all relational databases (Access, Oracle, DB/2, SQL Server, MySQL, SQL Server Express etc.). Dialect differences are pointed out in the "Functions" chapter.

 

Your benefit
  • Expand and deepen the solid SQL basics 
  • Learning with lab and practical relevance
  • Integrating the entire scope of SQL fundamentals into practice as part of the final project
trainers
Thanam Pangri
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

This course is aimed at 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. It is also intended for anyone who wants to find out more about SQL, its possibilities, limitations and significance.

Start dates and details

Form of learning

Learning form

7.10.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured
18.12.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured

The training is carried out in cooperation with an authorized training partner. This partner 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.