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