SQL for beginners

Course code: SQLB

SQL is an essential language for everyone working with data. In this course we provide the fundamentals to get started developing general-purpose queries. We will use the popular PostgreSQL database.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data.

Objectives:

You’ll learn how to read and write complex queries to a database using one of the most in demand skills – PostgreSQL.
Help you understand and apply SQL with MySQL, including Database Design and Data Analysis.

SELECT and WHERE statements.
Creating aggregates with GROUP BY and HAVING.
Modify, delete and create tables in the database.

460 EUR

557 EUR including VAT

The earliest date from 19.02.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

View soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates
Course structure

Course dates

Starting date: 19.02.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Starting date: 08.04.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Starting date: 03.06.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Starting date: 12.08.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Starting date: 07.10.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Starting date: 02.12.2024

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

Starting date: Upon request

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 460 EUR

	Starting date	Place	Type	Course duration	Language	Price without VAT
	19.02.2024		In-person/Virtual	2 days	en/cz	460 EUR	Register

	08.04.2024		In-person/Virtual	2 days	en/cz	460 EUR	Register

	03.06.2024		In-person/Virtual	2 days	en/cz	460 EUR	Register

	12.08.2024		In-person/Virtual	2 days	en/cz	460 EUR	Register

	07.10.2024		In-person/Virtual	2 days	en/cz	460 EUR	Register

	02.12.2024		In-person/Virtual	2 days	en/cz	460 EUR	Register

	Upon request		In-person/Virtual	2 days	en/cz	460 EUR	Register
G	Guaranteed course

Didn't find a suitable date?

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

Course structure

Course Introduction
Installation and Setup
Data Definition Language
More On Alter Table
Data Manipulation Language
Selecting from a Table
Selecting from Multiple Tables
Database Design
Creating a Cinema Booking System Database
Aggregate Functions

Follow-up courses

MongoDB Developer en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MongoDB Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

885 EUR without VAT

MySQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

MySQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL for DB Developers en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

PostgreSQL Performance en/cz

Vendor: EDU Trainings

Area: Databases

Price from

620 EUR without VAT

SQL for intermediate users en/cz

Vendor: EDU Trainings

Area: Databases

Price from

460 EUR without VAT

MS SQL Server administration comprehensively and efficiently en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

Optimization and monitoring of T-SQL queries en/cz

Vendor: EDU Trainings

Area: Databases

Price from

790 EUR without VAT