Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
The training takes 4 days.
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.
- History of SQL and PostgreSQL
- Connecting to the server with «psql, pgAdmin and other clients
- How to use psql
- SQL syntax elements: keywords, identifiers, constants
- binary data
The NULL value
Basic CREATE TABLE
- NOT NULL
- PRIMARY KEY
- FOREIGN KEY constraints
- Cascading delete
Sequences, serial, identity columns
Basic SELECT: the SELECT list
- Aggregates, FILTER
SELECT: the FROM clause
- Table functions
- CROSS JOIN
- INNER JOIN
- OUTER JOIN
SELECT: the WHERE clause
- IN (with lists and subqueries)
- EXISTS / NOT EXISTS
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
Database Design und Normalization
- Deferred Constraints
SQL Injection and Security
- LATERAL Joins
- Grouping Sets
- Window Functions
- Common Table Expressions (CTE)
Other courses that might interest you
Migration TutorialMore about this course
PostgreSQL High Availability & Patroni Cluster ManagerMore about this course
PostgreSQL in KubernetesMore about this course
Machine Learning para toma de decisionesMore about this course
Introducción a Machine LearningMore about this course
Administración de PostgreSQL y ajustes de PerformanceMore about this course
PostgreSQL para Business Intelligence y análisis de grandes volúmenes de datosMore about this course
Introduction to PostGISMore about this course
Introducción a PostgreSQLMore about this course
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.