Postgresql from zero to hero course

PostgreSQL: From Zero to Hero

Welcome to our 🐘 PostgreSQL Course: «From Zero to Hero» 🐘.

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

PostgreSQL has become one of the fastest growing database engines in recent years. So much so, that in 2017 it was awarded as the most popular Database Management System by DB-Engines.

We are going to start our course learning about its history and its main characteristics. We will also teach you how to install and configure PostgreSQL properly. To take this course, the only requirement is being willing to learn and having motivation to learn PostgreSQL.

If you got these two, this course is completely meant for you.

IMPORTANT!👇

👨‍🏫 Abatic Academy is your place Start Learning!

🐘 PostgreSQL Training From Zero to Hero 🐘

👉 Course Content 👈

  1. Introduction to PostgreSQL
  2. Standard Client: psql
  3. pgAdmin 4
  4. Backups
  5. High Availability and Replication

👨‍🎓 – Course Quizzes
🏆- Course Certificate of Excellence from Abatic Academy

Contenido del Curso

Introduction to PostgreSQL
Introduction to PostgreSQL
PostgreSQL history and main features
How to install PostgreSQL on Windows
How to install PostgreSQL on MacOS
How to install PostgreSQL on Ubuntu
How to install PostgreSQL on CentOS
Data Structure
Inserting Data Into a PostgreSQL
Updating data – PostgreSQL
Query data – PostgreSQL
Deleting data – PostgreSQL
Introduction Module Quiz 1 Cuestionario
Contenido de la Lección
PotsgreSQL Standard Client
Introduction to PostgreSQL Standard Client
Standard psql client
Syntax
Meta-Commands
Meta-Commands II
.pgpass & .psqlrc files
Standar Client Module Quiz 1 Cuestionario
Contenido de la Lección
pgadmin4
Introduction to pgAdmin4
Installation and configuration on Windows
Installation and Configuration on MacOS.
Installation on Ubuntu.
Installation in Ubuntu through Repository.
Configuration and use
PGADMIN Module Quiz 1 Cuestionario
Contenido de la Lección
Backups in PostgreSQL.
Introduction to Backups in PostreSQL
Logical Copies in PostgreSQL
Logical copies with pg_dumpall
Restore using psql
Restore using pg_restore
Physical backups.
Backups Module Quiz 1 Cuestionario
Contenido de la Lección
PostgreSQL High Availability and Replication
Introduction to PostreSQL High Availability and Replication
Concepts of High Availability and Replication
WAL Shipping PostgreSQL
Streaming Replication, Asynchronous
Streaming Replication, Synchronous.
Hot StandBy.
High Availability and Replication Module Quiz 1 Cuestionario
Final Quiz
Resumen de privacidad

Esta web utiliza cookies para que podamos ofrecerte la mejor experiencia de usuario posible. La información de las cookies se almacena en tu navegador y realiza funciones tales como reconocerte cuando vuelves a nuestra web o ayudar a nuestro equipo a comprender qué secciones de la web encuentras más interesantes y útiles.