Introduction to SQL

Level:

Beginner

Date:

06.08 - 08.08.18

Duration:

3 Days

Sign up for this course

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
Sign up for this course