Course Objectives

This course covers the basics of SQL scripting regardless of the database infrastructure.

Contents

1. RDBMS & SQL Introduction

1.1 General RDBMS Concepts

1.2 SQL Introduction

2. Data Definition Language

2.1 Create Table

2.2 Column Data Types

2.3 Primary and Foreign Key Constraints

2.4 Database Schema Design

3. Data Manipulation Language

3.1 Insert – Update – Delete

3.2 Transactions

4. Retrieving Data

4.1 Select Command Introduction

4.2 Limiting and Combining Columns

4.3 Inline Functions

4.4 Limiting Rows

5. Combining Data

5.1 Join types

5.2 Union

5.3 Subqueries

6. Data Aggregation

6.1 Group by Concept

6.2 Multiple Row Functions

6.3 Having vs Where

7. SQL in Analytics

7.1 Normalization and de-Normalization

7.2 Big Data

7.3 SQL in Various Platforms

 

Entry Requirements

Basic IT concepts understanding preferably with hands-on background is required from the participants.

Target Group

Technical personnel involved in retrieving data using SQL

 Mode of Delivery:  Distance-instructor-led learning in a virtual classroom

 Duration:  The duration of this course is 3 full training days

Language: Greek

Participants: The maximum number of participants for this course is 12 persons

 Time schedule

The time required always depends on the knowledge of the attending participants and the schedule stated below can be used as estimate.

Course Structure				Hours	Days
RDBMS & SQL Introduction		General RDBMS Concepts		1	Day 1
		SQL Introduction
Data Definition Language		Create Table		2
		Column Data Types
		Primary and Foreign Key Constraints
		Database Schema Design
Data Manipulation Language		Insert – Update – Delete		3
		Transactions
Retrieving Data		Select Command Introduction		2	Day 2
		Limiting and Combining Columns
		Inline Functions
		Limiting Rows		1
Combining Data		Join types		2
		Union
		Subqueries		1
Data Aggregation		Group by Concept		2	Day 3
		Multiple Row Functions
		Having vs Where		1
SQL in Analytics		Normalization and de-Normalization		1
		Big Data		1
		SQL in Various Platforms		1