1. data definition language (DDL)
2. extension of the SQL base elements
CASE Statement: Simple and Searched
COUNT(DISTINCT)
3. working with functions
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)
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.
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.
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.
Form of learning
Learning form
No filter results
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.