Introduction to SQL

Introduction to PostgreSQL

Duration: 3 Days
Level: Beginners
Date: on request
06.03. – 08.03.2017 in Wr. Neustadt, Austria (German)
Audience: This workshop has been designed for people who want to get in touch with SQL and PostgreSQL. You will learn how to use PostgreSQL and how to write proper SQL statements.

 

Content:

Defining tables

  • Creating / dropping tables
  • Using data types
  • Intelligent data structures
  • Normalization
  • ALTER TABLE: Modifying data structures
  • Using schemas

Simple instructions

  • INSERT / UPDATE / DELETE
  • Simple SELECT statements
  • WHERE-conditions
  • Sorting data
  • Limiting output
  • Filtering duplicate entries

Joins

  • Inner joins
  • Outer joins

Advanced SQL

  • NULL values
  • Aggregations (sum, count, etc.)
  • Understanding HAVING
  • Subselects
  • Set operations
  • Constraints
  • Integrity constraints and foreign keys
  • Views
  • Using cursors
  • Temporary tables

Indexing

  • Creating indexes
  • Speeding up queries using indexes
  • Avoiding unnecessary indexes

Transactions

  • ACID transactions
  • Data security and consistency
  • Locking
  • Savepoints
  • Transaction Isolation
  • Error handling