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
- Entity-relationship model (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, CROSS)
- Subqueries
- UNION query
4 Adding, updating and deleting records
- SELECT INTO
- INSERT (VALUES, SELECT)
- UPDATE
- DELETE
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.