Webinars

EDB POSTGRES et SETRA Conseil : Comment sécuriser vos bases de données PostgreSQL?

Pour participer à ce webinar, vous pouvez vous inscrire dès maintenant à cette session de 45 mn sur le sujet suivant :

• SETRA CONSEIL et le partenariat avec EDB Postgres

• Présentation d’EDB Postgres

• La plateforme EDB Postgres Standard & Advanced Server

• Sécuriser la disponibilité des données PostgreSQL

Protecting Sensitive Data within EnterpriseDB Postgres Database

Databases by design centrally aggregate data and, in turn, can expose your organization to fraud and data breaches. Fortunately, EnterpriseDB and Thales team together to address this security and compliance concern.

This webinar will provide some level-setting on the current state of database security, outline today’s best-practices, and offer a vision as to where data storage security is heading.

The agenda for this webinar is:
• Overview of EnterpriseDB and Thales
• Database Security Fundamentals

The Magic of Window Functions in Postgres

Window functions are often used to simplify complex queries and for data analytics. They allow analysis that is normally performed in client applications to be more efficiently processed by the database server.

This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.

In this webinar you will learn:

Why you should use native packages to install PostgreSQL on Linux

When it comes to installing PostgreSQL on a Linux distribution, using a native package is considered to be a better choice compared to installing from the source. In this webinar, we will discuss some benefits of using native packages to install PostgreSQL.

Optimizing Performance: Installers are shipped with “the lowest common denominator” and native packages use the OS libraries resulting in performance and maintenance benefits.

How to use postgresql.conf to configure and tune the PostgreSQL server

Tuning your PostgreSQL server plays an important role in making sure you get the most out of your server resources, and running with default parameters is not always enough. Using the PostgreSQL server configuration file postgresql.conf, we can tune the right area and make the most out of the server resources. The postgresql.conf file tuning parameters are classified into different categories including database connections, memory, optimizers, and logging.

In this webinar, you will learn:

Automating Postgres Deployments on AWS and VMware, with Terraform and Ansible

Deploying Postgres on AWS and VMware shouldn’t be a clunky, manual task. In 2020 and beyond, automation and Postgres will go hand in hand.
Highly available, fault-tolerant PostgreSQL database cluster creation and monitoring can now be deployed in a matter of minutes using Terraform and Ansible scripts. In this webinar, you will learn how developers, devOps, and DBAs can automate cloud and on-premise Postgres deployment with the help of Terraform and Ansible.

We will cover: