Course: Designing Databases in PostgreSQLPgSQL-designing

The course is available on demand.

No suitable dates? Suggest a time that suits your schedule

Remote training: online live with a trainer and a group. Available on demand, at time and place convenient to you, for groups of at least 5 participants.

exempt from VAT

Price: 590 EUR

refreshments included

computer station included

Category: PostgreSQL

The training is recommended for people who know SQL language basics and who want to master the principles of effective database schema designing. PostgreSQL system gives database architects unique opportunities such as exclusion constraints and functional indexes. We will show how to design the database schema so that the application working with it runs smoothly and programmers are always sure of integrity of the inside data.

Our instructors have many years of experience with PostgreSQL, both as administrators and as programmers. One of our trainers is a PostgreSQL contributor and a regular speaker at the world’s largest conference on the topic.

Duration

1 day

Agenda

  1. Relation modelling
    • Relation modelling on examples
    • Normal forms, best practices
    • Natural and surrogate keys
    • Most common methods of notation database schemas
  2. Data types
    • Types available in PostgreSQL
    • Range types
    • Defining your own types and domains
  3. Coherence constraints
    • Basic types of coherence constraints
    • The most common business requirements and their modelling
    • Exclusion constraints
  4. Designing efficient database schemas
    • Indexes using
    • Denormalization
    • Partitioning

Download as PDF

Audience and prerequisites

We recommend that the participants have ability of using PostgreSQL at least at intermediate level and good knowledge of SQL.

Certificates

Course participants receive completion certificates signed by ALX.

There are currently no entries
Enter your e-mail address and we will notify you about future dates