Course
Standard SQL-3 («SQL»)
In this course you will learn the standard version of SQL. In many practical exercises, you will deepen and consolidate them, focusing on general concepts.
Duration
2 days
Price
1'800.–
Course documents
Digicomp Courseware (German)
Course facts
- This course will provide you with solid SQL basics. You will learn everything you need to know to thoroughly master Standard SQL.
- The many practical exercises provide an immediate plus in your daily work routine.
- The specially developed Digicomp course documentation also provides you with helpful practical tips after the course.
- Repetition of the basic concepts of relational databases
- Database
- Table (entities, attributes)
- Data types (value ranges)
- Primary, foreign key
- Relations
- Data Consistency, Referential Integrity
- View
- Index
- ERM
- SQL basics
- History
- Application (basic concept)
- SQL properties
- SQL syntax diagrams
- Naming conventions for objects
- Data retrieval, data evaluation and data manipulation (DML)
- SELECT
- Simple queries
- Constant Columns, Calculated Columns, Aliases
- DISTINCT
- ORDER BY
- TOP
- WHERE
- Aggregate functions
- GROUP BY / HAVING
- JOIN (INNER, OUTER, FULL, SELF, CROSS)
- Subqueries
- UNION
- SELECT INTO
- Adding data
- INSERT (VALUES, SELECT)
- UPDATE
- DELETE
- Data Definition Language (DDL)
- CREATE DATABASE
- CREATE TABLE
- Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE )
- DROP TABLE
- CREATE VIEW
- OLD VIEW
- DROP VIEW
- CREATE PROCEDURE
- Data control language (DCL)
- Transaction management
- COMMIT & ROLLBACK
- GRANT & REVOKE