Queries with PostgreSQL

SpiralTrain BV

In the course Queries with PostgreSQL from SpiralTrain, participants learn the syntax and use of the query language SQL in the context of a PostgreSQL database.

Price

from €1,999

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

SQL Intro After an introduction to relational databases, the SQL standard and PostgreSQL, the installation of PostgreSQL, the PostgreSQL environment and tooling are discussed. PostgreSQL, like other DBMS systems, has added extra features of its own to standard SQL and these are also covered in the course. SQL Data Definition In the first place it is covered how SQL statements can be created and executed in PostgreSQL. Subsequently, the various components of SQL are discussed step-by-step, such as Data Definition Language with CREATE TABLE and Data Manipulation Language with INSERT and UPDATE. SQL Select Queries Next attention is paid to writing SELECT queries. This includes clauses such as WHERE, ORDER BY, LIKE and BETWEEN .. AND. The grouping of data by means of GROUP and HAVING clauses is also on the course schedule. SQL Functions The various standard SQL functions are also discussed. Among other things, the mathematical, conversion and aggregation functions for calculating sum and average are treated. Attention is also paid to PostgreSQL specific functions for pattern matching and the processing of geometric and XML data.