Subsidized course „Jsem v kurzu“

Fundamentals of SQL Language for Users

This two day training is designed for those who are starting their journey in SQL. It offers an introduction to relational databases as well as writing simple queries. The purpose of this course is to get you familiar with basic knowledge required for constructing SQL queries and is aimed for users who need it for writing uncomplicated SELECT statements and who also want to display and filter data or know how to order it. If any extension of the gained knowledge is required, we offer additional courses Writing Queries Using SQL and Writing Advanced Queries Using SQL.
The course uses Microsoft platform with the Transact-SQL dialect.

Code
SQL-Jazyk 0

Course length
2 days (8:30 – 16:00)

Form
In our classroom or online

Main course tutor

Ing. David Kovařovic

Ing. David Kovařovic

Cisco a Linux instructor

More about tutor

Dates

12/09/2024 – 12/10/2024 Prague Free date Guaranteed date 11 800 CZK
without VAT
Add to cart
Buy with the subsidy program "Jsem v kurzu" 11 800 CZK 2 124 CZK
without VAT
Order on Integrated
MoLSA Portal  

This course is intended for

Users who want to learn SQL for basic simple querying, reporting or data analysis.

Syllabus

Module 1: Introduction to SQL and Relational Databases

  • History
  • Relational databases (entities, atributes, relations)
  • Vendors & Tools

Module 2: Introduction to SQL Language

  • Types of Commands (DML, DDL, DCL)
  • Language Elements (Expressions, Operators, Variables)

Module 3: Data Types and Built-In Function

  • Data Types
  • Built-In Functions

Module 4: The SELECT Statemoent

  • Syntax
  • Distinct
  • Aliases

Module 5: Joining Tables and Sets

  •  JOIN
  • SET Operators (Union, Except, intersect)

Module 6: Sorting and Ordering Data

  • ORDER BY
  • WHERE

Students will be able to

  • Understand the principles of relational databases
  • Construct simple queries in SQL, join tables and filter data

Course requirements

  • WIlling to learn something new, gain knowledge about relational databases and the concept of querying data.

Hardware

Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

Literature

All participants will get internal materials.

PDF to download

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.

Similar courses

Take a look at some similar courses from our wide range.

Subsidized course „Jsem v kurzu“

Performance Tuning and Optimizing SQL Databases DB-TUNING


22 000 CZK Course detail
Subsidized course „Jsem v kurzu“

Writing Advanced Queries Using SQL SQL-Jazyk 2


17 700 CZK Course detail
Subsidized course „Jsem v kurzu“

Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM


27 500 CZK Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.