Introduction to SQL

Level:

Beginner

Duration:

3 days

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.

See dates  >>

 

This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.

Learn more about our customized training >>

 

This course takes 3 days with 8 hours each (on site) or 4 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.

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.

Available Language

This course can be held in English, German, Spanish, Polish, Estonian, Ukrainian and Russian.

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