Databases and SQL Language 1

Course/Event Essentials

Event/Course Start
Event/Course End
Event/Course Format
Online

Venue Information

Country: Slovakia
Venue Details: Click here

Training Content and Scope

Scientific Domain
Level of Instruction
Intermediate
Advanced
Sector of the Target Audience
Research and Academia
Industry
Public Sector
Other (general public...)
HPC Profile of Target Audience
Application Users
Data Scientists
Language of Instruction

Other Information

Organiser
Supporting Project(s)
EuroCC2/CASTIEL2
Event/Course Description
  1. Introduction to databases

    • Database Systems and Databases

    • MySQL, Microsoft SQL, PostgreSQL

    • Database Objects

    • Tables

    • Queries

  2. SQL language

    • SELECT, SELECT DISTINCT

    • LIMIT

    • WHERE

    • Operátor zreťazenia (+)

    • CONCAT()

    • IS NULL

    • BETWEEN

    • IN

    • LIKE

    • ORDER BY

    • GROUP BY

    • CAST function