Course

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

This course extends, deepens and completes the solid SQL General Fundamentals acquired in the SQL Standard Course.
Duration 1 day
Price 1'800.–
Course documents Digicomp courseware (German; digital)
Course duration From December 2024, we will be offering this course as a 2-day training.
Alternative learning format available: SQL Fundamentals In-Depth («SQLV2»)
Register

Course facts

  • In-depth practical day that summarizes all the skills learned in the standard SQL course
  • Additional SQL fundamentals that further cover today's workplace requirements
 Over time, the demands on SQL fundamentals have increased in practice, and most participants in our standard SQL course want more time to practice their new skills. 

This course follows the proven methodology of “learning SQL by building SQL” and effectively covers both needs.

Practical repetition of the SQL basics as part of a larger course project:
  • SELECT, WHERE
  • GROUP BY, HAVING
  • INNER and OUTER JOINS
Further topics:
  • DATETIME functions
  • FORMATTING functions
  • CASE STATEMENT
  • VIEWS
  • Extended Q&A 

Participants of our SQL standard course who want to consolidate their newly acquired practical SQL knowledge. 

 Completion of our Standard SQL course within the last 12 months.

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

Download course details as PDF

Questions