Course
Digicomp Code SQLV2
SQL Fundamentals In-Depth («SQLV2»)
SQLV2
Course facts
- Extension and deepening of the solid SQL Fundamentals acquired in the SQL Standard course
- Lab- and practice-oriented learning
- In the final project, there is the opportunity to practically incorporate the entire scope of SQL basics
1 Data Definition Language (DDL)
- CREATE, ALTER, DROP
- DATABASE, TABLE, VIEW
- ADD CONSTRAINT
- PRIMARY KEY
- FOREIGN KEY
- UNIQUE
- DEFAULT
- CHECK
2 Extension of SQL Basic Elements
- CASE Statement: Simple and Searched
- COUNT(DISTINCT)
3 Working with Functions
- Working with Text Functions
- Working with DATETIME Functions
- Working with NULL Values
- Data Type Conversion and Formatting
- Notes on Dialect Differences
4 Final Project
The final project brings together all topics from the courses «SQL Standard» and «SQL Fundamentals In-Depth»: SELECT, INSERT, UPDATE, DELETE, CREATE/ALTER TABLE, ADD CONSTRAINT, JOIN, GROUP BY, HAVING, ORDER BY
5 Optional Topics (time permitting/in consultation with the group)
- Exploring the Database Model of Existing Databases
- Meta Information Tables
- Database Diagrams
- Data Control Language (DCL)
- Transaction Management
- COMMIT & ROLLBACK
- GRANT & REVOKE
- Extended Q&A
- Practical Tips for Everyday SQL
This course is aimed at programmers, PC support staff, and other individuals who work with a SQL-capable database or want to create applications using the SQL capabilities of the database system, as well as individuals who want practical knowledge about SQL, its possibilities, limitations, and significance.
- Attendance of the Standard SQL-3 course is a prerequisite; the same course database is used
- Enjoyment of analytical thinking as well as abstraction and imagination skills
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.