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
- Relation modelling
- Relation modelling on examples
- Normal forms, best practices
- Natural and surrogate keys
- Most common methods of notation database schemas
- Data types
- Types available in PostgreSQL
- Range types
- Defining your own types and domains
- Coherence constraints
- Basic types of coherence constraints
- The most common business requirements and their modelling
- Exclusion constraints
- Designing efficient database schemas
- Indexes using
- Denormalization
- Partitioning
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.
