SQL Standard Intensive Training (SQL02)

 

Course Overview

In this training you will learn everything you need to know and be able to query your database on the basis of standard SQL-3.

Who should attend

Developers, analysts, businessmen and other interested persons who want to work with an SQL-capable database or create applications using the SQL possibilities of the database system. People who want to get well-founded information about SQL, its possibilities, limitations and meaning.

Prerequisites

General practical experience with computers, pleasure in analytical thinking as well as abstraction and imagination. Basic knowledge of relational databases is advantageous

Course Objectives

After this training you will be able to query and modify all common relational databases with the standard tools.

Course Content

1. basic terms of relational databases
  • Database
  • Table (entities, attributes)
  • Data types (value ranges)
  • primary, foreign key
  • Relations
  • Data consistency, referential integrity
  • View
  • Index
2. basics about SQL
  • History
  • Application (basic concept)
  • SQL Properties
  • SQL Syntaxdiagram
  • Naming conventions for objects
3. data retrieval, data evaluation and 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. add data
  • INSERT (VALUES, SELECT)
  • UPDATE
  • DELETE
5. data definition language (DDL)
  • CREATE DATABASE
  • CREATE TABLE
  • Constraints (PRIMARY- , FOREIGN KEY, UNIQUE )
  • DROP TABLE
  • CREATE VIEW
  • ALTER VIEW
  • DROP VIEW
  • CREATE PROCEDURE
6. data control language (DCL)
  • Transaction Management
  • COMMIT & ROLLBACK
  • GRANT & REVOKE

ceny & Delivery methods

Szkolenie online
Modality: L

Trwa 2 dni

Cena
  • on request
Classroom training
Modality: C

Trwa 2 dni

Cena
  • on request

harmonogram

Angielski

Strefa czasowa: Central European Summer Time (CEST)   ±1 Godzinę

Szkolenie online This is a FLEX course. Strefa czasowa: Central European Summer Time (CEST)
Szkolenie online This is a FLEX course. Strefa czasowa: Central European Summer Time (CEST)
Szkolenie online This is a FLEX course. Strefa czasowa: Central European Summer Time (CEST)
Szkolenie online This is a FLEX course. Strefa czasowa: Central European Summer Time (CEST)
Szkolenie online This is a FLEX course. Strefa czasowa: Central European Time (CET)
Szkolenie online This is a FLEX course. Strefa czasowa: Central European Time (CET)
To jest kurs FLEX, który jest prowadzony zarówno wirtualnie, jak i stacjonarnie.

Europa

Niemcy

Hamburg Enroll
Hamburg Enroll
Düsseldorf Enroll
Stuttgart Enroll
Berlin Enroll

Szwajcaria

Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
Zurych This is a FLEX course.   Strefa czasowa: Europe/Zurich Enroll:
for online training
for classroom training
+ show all dates

Włochy

milano This is a FLEX course.   Strefa czasowa: Europe/Rome Enroll:
for online training
for classroom training
To jest kurs FLEX, który jest prowadzony zarówno wirtualnie, jak i stacjonarnie.