Introduction to SQL

Objective

This course provides detailed information about the basics of the query language SQL.

Audience

Application developers and database administrators

Prerequisites

A fundamantel knowledge of data processing and database administration

Content


SQL Overview
Data Definition Language (DDL)

  • Create Tables
  • Alter Table Structures
  • Delete Tables
  • Indexes
  • Relations between Tables (Foreign Key Contraints)

Data Query Language (DQL)

  • Select Data
  • Join Tables

Data Manipulation Language (DML)

  • Insert Data
  • Update Data
  • Delete Data

Introduction to Views
Introduction to Transactions

  • ACID Model
  • Transaction Isolation Level

Course Information

Course No:5225E
Duration: 3 days
Price: € 1.650,00

Registration

For this course we haven't scheduled any public classes.


Any questions?

We would be pleased to help:

Burkhard Borkowski
Managing Director
+49 511 123119-10

E-Mail



Olga Ferderer
Account Manager
+49 511 123119-26

E-Mail