Course
Digicomp Code SQL
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.
Vendor code
SQL
Duration
2 days
Price
1'800.–
Course documents
New: Digicomp training material includes integrated LAB-Engine
Interested in even more SQL?
SQL Fundamentals In-Depth
Course facts
- Gaining basic SQL knowledge and everything that is important for the secure mastery of standard SQL
- Completing numerous practical exercises for immediate added value in everyday work
- Receiving helpful practical tips from the specially developed Digicomp course materials
1 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
2 SQL basics
- History
- Application (basic concept)
- SQL properties
- SQL syntax diagrams
- Naming conventions for objects
3 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
4 Adding data
- INSERT (VALUES, SELECT)
- UPDATE
- DELETE
5 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. People who want to systematically inform themselves about SQL, its possibilities, limitations and meaning.
- Sound experience in dealing with EDP
- Basic knowledge of relational databases
- Enjoy analytical thinking as well as abstraction and imagination skills
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.