Course

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.

Download

Questions

Choose your date

Further courses

Lernen Sie Ihre Trainer kennen