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, businesspeople 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, 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 of 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

Prices & Delivery methods

Online Training
Modality: L

Duration 2 days

Classroom Training
Modality: C

Duration 2 days

Schedule

English

Time zone: Central European Time (CET)

Online Training Time zone: Central European Time (CET)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Guaranteed date:   We will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Europe

Germany

Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Enroll

Italy

Online Training This is a FLEX course in Italian language.   Time zone: Europe/Rome Enroll
Online Training This is a FLEX course in Italian language.   Time zone: Europe/Rome Enroll
Online Training This is a FLEX course in Italian language.   Time zone: Europe/Rome Enroll

Switzerland

Basel Enroll
Bern Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Zurich Enroll
Basel Enroll
Bern Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Zurich Enroll
Basel Enroll
Bern Enroll
+ show all dates
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).