tark.ee
tark.ee

SQL Fundamentals

This 3-day SQL Basics course is suitable for those with little prior knowledge. It teaches about the structure and operating principles of SQL databases, Familiarizes participants with the main SQL commands and functions and practically teaches them how to create simple SQL requests.

BCS Koolitus
Who it is for
  • Oracle, MySQL, PostgreSQL etc.
  • SQL database users;
  • Data analysts;
  • Specialists who have desire to learn about the SQL language and its application in various database management systems.
Prerequisites
Without prior knowledge. It will be easier for those who know any programming language.
Programme
  1. Introduction to SQL language, databases and database management systems;
  2. Key SQL commands and functions:
    • Basic SELECT;
    • ORDER BY;
    • DISTINCT;
    • Basic WHERE;
    • WHERE expressions;
    • Functions;
    • CAST;
    • GROUP BY and HAVING;
    • Subqueries;
    • Join.
    • Study methods: You can participate in the study by joining the training through the online environment Teams. The volume of training is 24 hours incl. 12 hours of practical exercises or group work in the training environment.
Skills you will gain
  • Understand the structure and basic principles of database operation and management systems
  • Make simple SQL queries to databases in various database systems
Certificate
Each participant receives a certificate of attendance after the course.
Additional information
Technology needed for the course: Computer with a camera and a microphone. Ability to install Microsoft SQL Server and SSMS. Assessment method: The achievement of learning outcomes is assessed based on feedback-based practical exercises or group works carried out during the training. No certification exam The price includes: Study materials, Coffee breaks in the training center and joint lunches.
Price

Price on request

Ask when it runs
OrganiserBCS Koolitus

BCS Koolitus

View the organiser's profile
✨
Vajan seda oma tiimile
Aitame koostada päringu
›

This course last ran in September 2026. We do not know yet whether or when it will run again — that is why it is still here. Ask us if you are interested.

Sarnased koolitused, mis praegu toimuvad

Andmeanalüüs

SQL päringukeele meistriklass

Kursus on mõeldud huvilistele, kes tunnevad juba SQL keele põhitõdesid ning puutuvad kokku olukordadega, kus põhitõdedest enam ei piisa.

12.11 – 13.11 · veebikoolitus · 16 akadeemilist tundi

Silver Toompalu

Silver Toompalu

OfficePoint

OfficePoint

485€Vaata

Administreerimine

SQL andmete puhastamiseks ja andmeanalüüsiks koos generatiivse tehisaru (AI) mooduliga

Kolmepäevase praktilise koolituse tulemusel, saavad osalejad teadmised SQL päringukeele olemusest, dialektitest.

11.11 – 13.11 · Aia 7 või videokonverentsi keskkonnas Zoom · 27 ak. tundi

Virve Räni

Virve Räni

BCS Koolitus

BCS Koolitus

990€+kmVaata

Administreerimine

Administering a SQL Database Infrastructure (55316A)

55316A Administering a SQL Database Infrastructure on koolitus, kust saad kõik praktilised oskused ja teadmised SQL andmebaaside infrastruktuuri haldamisest.

16.11 · Lõõtsa 5

15.03 · Lõõtsa 5

Henn Sarv

Henn Sarv

Nordic Koolitus

Nordic Koolitus

1090€+kmVaata

Andmeanalüüs

Andmebaaside päringukeel SQL - algajast edasijõudnuks

Kursus on mõeldud osalejatele, kes oma igapäevatöös puutuvad kokku relatsioonilisest andmebaasist andmete kättesaamiseks vajalike SQL päringute koostamisega ning puutuvad kokku olukordadega, kus ainult SQL keele põhitõdedest ei piisa.

05.11 – 13.11 · veebikoolitus · 32 akadeemilist tundi

Silver Toompalu

Silver Toompalu

OfficePoint

OfficePoint

970€Vaata

Tell me when this course runs again

This course is not running at the moment. Leave your contact details and we will let you know when it, or a similar course, is back in the calendar.

Notify me withinmonths.
✨

Otsid midagi muud?

Aitame leida sarnase koolituse või koostada tiimile eraldi pakkumise — vestle meiega.

Ask when it runs ↓