CYBERTEC Logo

SQL Basics

LEVEL: Basic
Training Buchen

Kurs Inhalte

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)

Kurs Info

Level Basic

Keine Vorkenntnisse erforderlich. Anfänger willkommen.

Sprache

English or German

Dauer

4 Tage

Ort und Datum

Im Moment ist leider kein Kurs zu diesem Thema geplant. Wenn Sie trotzdem an einem Training interessiert sind, können Sie gerne eine Anfrage stellen.
Kursanfrage
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram