SQL Basics

Course code: ZAKLSQL

This training has been designed for people who want to get familiar with SQL. You will learn how SQL works and how to write proper SQL statements using practical examples that will be useful for your daily work.

Designed for the product: PostgreSQL
Group size: Group of up to 15 students
Type of exam: 30 min, theoretical
Requirements: None
Course language: Czech
Course length: 4 DAYS

Additional information

Each participant will be provided with a PDF of the presentations
2 000 EUR

2 420 EUR including VAT

The earliest date from 10.06.2024

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 10.06.2024

Type: In-person/Virtual

Course duration: 4 days

Language: cz/sk

Price without VAT: 2 000 EUR

Register

Starting date: 05.08.2024

Type: In-person/Virtual

Course duration: 4 days

Language: cz/sk

Price without VAT: 2 000 EUR

Register

Starting date: 14.10.2024

Type: In-person/Virtual

Course duration: 4 days

Language: cz/sk

Price without VAT: 2 000 EUR

Register

Starting date: 09.12.2024

Type: In-person/Virtual

Course duration: 4 days

Language: cz/sk

Price without VAT: 2 000 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 4 days

Language: cz/sk

Price without VAT: 2 000 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
10.06.2024 In-person/Virtual 4 days cz/sk 2 000 EUR Register
05.08.2024 In-person/Virtual 4 days cz/sk 2 000 EUR Register
14.10.2024 In-person/Virtual 4 days cz/sk 2 000 EUR Register
09.12.2024 In-person/Virtual 4 days cz/sk 2 000 EUR Register
Upon request In-person/Virtual 4 days cz/sk 2 000 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course structure

Day 1 

  • History of SQL and PostgreSQL
  • Connecting to the server using different tools
  • SQL syntax elements: keywords, identifiers, constants
  • Data types
  • The NULL value
  • Basic CREATE TABLE
  • Schemas

Day 2 

  • Basic INSERT
  • Basic DELETE
  • Temporary tables
  • Constraints
  • ALTER TABLE
  • Sequences, serial, identity columns

Day 3 

  • Basic SELECT: the SELECT list
  • SELECT: the FROM clause
  • SELECT: the WHERE clause
  • SELECT: the GROUP BY clause, HAVING
  • SELECT: the ORDER BY clause
  • SELECT: LIMIT and OFFSET
  • UNION, EXCEPT, INTERSECT
  • UPDATE, UPDATE … FROM
  • DELETE … USING
  • INSERT … SELECT
  • INSERT … ON CONFLICT
  • Views

Day 4 

  • COPY
  • Database Design and Normalization
  • Transactions
  • SQL Injection and Security
  • Advanced SELECT
ComGate payment gateway MasterCard Logo Visa logo