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»)
Course facts
Key Learnings
- Deepening all the skills learned in the standard SQL course
- Learning additional SQL fundamentals that further cover today's workplace needs
Content
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
Target audience
Participants of our SQL standard course who want to consolidate their newly acquired practical SQL knowledge
Requirements
Completion of our Standard SQL course within the last 12 months:
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
We currently do not have any dates scheduled.
But we can arrange one for you. We will be happy to advise you individually on your course planning.
Contact us