SQL Basics
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.
Audience
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.
Agenda
Day 1
- 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
Data types
- numbers
- strings
- date/time
- binary data
The NULL value
Basic CREATE TABLE
- NOT NULL
- DEFAULT
Schemas
Day 2
Basic INSERT
Basic DELETE
Temporary tables
Constraints:
- CHECK
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY constraints
- Cascading delete
ALTER TABLE
Sequences, serial, identity columns
Day 3
Basic SELECT: the SELECT list
- Aliases
- Aggregates, FILTER
- DISTINCT
- CASE
- COALESCE
SELECT: the FROM clause
- Table functions
- JOIN
- CROSS JOIN
- INNER JOIN
- OUTER JOIN
SELECT: the WHERE clause
- BETWEEN
- 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
Views
Day 4
COPY
Database Design und Normalization
Transactions
- Deferred Constraints
SQL Injection and Security
Advanced SELECT
- LATERAL Joins
- Grouping Sets
- Window Functions
- Common Table Expressions (CTE)
Inne szkolenia, które mogą Cię zainteresować
Oferujemy te usługi
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 Infrastructure
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.