PostgreSQL 14 training - Getting started

Description

Our PostgreSQL 14 Getting Started training course is designed to provide participants with a solid foundation in the fundamentals of PostgreSQL. Over the course of four days, participants will learn the basics of PostgreSQL database architecture, SQL commands, and data modeling. They will also gain practical experience through a series of hands-on lab exercises that reinforce the concepts learned.

Whether you're a database administrator, IT professional, or developer, this training course is an excellent opportunity to learn the basics of PostgreSQL and gain valuable skills that can be applied in a variety of settings.

Day 1:

  • Introduction to PostgreSQL
  • Basic PostgreSQL Architecture
  • PostgreSQL Installation and Configuration
  • Introduction to psql

Day 2:

  • Basic SQL Commands
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Advanced SQL Commands

Day 3:

  • Data Modeling Concepts
  • Entity-Relationship Diagrams (ERD)
  • Normalization
  • Creating Tables and Relationships

Day 4:

  • Performance Tuning
  • Database Security
  • Managing User Access
  • Backup and Recovery

This training course is suitable for IT professionals, database administrators, and developers who are new to PostgreSQL and want to gain a strong foundation in the basics of PostgreSQL.

Participants should have basic knowledge of databases and be familiar with SQL concepts. Some experience with programming concepts and the Linux command line is recommended but not required.

By the end of this course, participants will be able to:

  • Understand the fundamentals of PostgreSQL database architecture
  • Use basic SQL commands to query and manipulate data
  • Design and implement a relational database schema
  • Optimize database performance and ensure data integrity
  • Secure PostgreSQL databases and manage user access

Training Details

  • Reference : COT-POSTGRESQL3
    Training location : Cotonou
    Date :
    Duration : 4 Days (30 hrs)
    Price : FCFA750,000

Currency

Training location

We design, build and support digital products for clients who want to make a positive impact in their industry. Creative with technology, we develop great solutions to help our clients grow and especially by strengthening our relationships based on continuous improvement, maintenance, support and hosting services.

Follow us