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
New: Digicomp training material includes integrated LAB-Engine
Interested in even more SQL?
Standard SQL Bundle with In-depth Day
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
Optional Topics (if enough time available):
- 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
Programmers, PC administrators and other people who want to work with an SQL-enabled database or create applications using the SQL capabilities of the database system. Persons who want to systematically inform themselves about SQL, its possibilities, limitations and meaning.
Sound experience in dealing with EDP, basic knowledge of relational databases, enjoyment of analytical thinking as well as abstraction and imagination.
This course is manufacturer-independent. So it does not matter if you work with Access, Oracle, DB/2, SQL Server, mySQL, SQL Server Express or other database management systems – the basics are always the same.