Cybertec

Introduction to PostgreSQL
Duration: 4 Days
Level: Beginners
Price: contact us today
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

www.cybertec.at | www.postgresql.at | www.postgresql-support.de | CONTACT | +43 / 664 / 3933 974
Cybertec is a company offering a comprehensive set of services for the world's most advanced Open Source database, PostgreSQL. Our products work on all platforms including Linux, Solaris, and Windows. No matter whether your application is small or complex - we have the right solution for you.

WordPress SEO fine-tune by Meta SEO Pack from Poradnik Webmastera