350.00

Mastering PostgreSQL

Dates: 23-November-18 till 01-December-18

Elias Chatzigeorgiou

Technical Director: Ε. Chatzigeorgiou (in)

Academic Director: I. Nikolakopoulos (in)

Express Your Interest

This is a certified program by Athens Tech College, the first educational institution in Greece that specialises in computer science and ICT studies.

Participant’s registration (payment’s completion) implies full compliance and acceptance of  Code.Learn Terms & Conditions.

Description

Duration

  • This specific Code.Learn program lasts 2 weeks (2 Fridays, 2 Saturdays) with 25 hours of lectures and hands-on exercise on a real life project.

Key Objectives – Curriculum:

This program will present, explore and adequately cover with extended hands-on sessions & real-life case studies the following areas:

  • Jump start with PostgreSQL:
    – Architecture
    – Server configuration
    – DBeaver
    – Database object types
    – Data types
    – Schemas & Indexes
    – Audit tables & Triggers
  • Administration:
    – Database administration
    – User administration
    – Permissions & Security
    – Monitoring
    – VACUUM
    – Maintenance
  • Replication:
    – Terminology, Overview & Architecture
    – Startup and setup
    – Switchover, failover & failback
    – Physical streaming replication & Hot Standby
    – Replication Manager
  • Backup & Disaster Recovery:
    – Physical backup
    – Point in time recovery
    – Barman
    – Logical backup
    – Logical replication
    – Bi-directional replication
  • PostgreSQL Security:
    – User authentication levels
    – Schema level security
    – Data encryption
    – Backup security
    – Row level security
    – SCRAM

Target Audience

Database administrators, db engineers, data warehouse engineers, BI developers and data engineers that want to boost their career are welcome to participate to this code.learn program and unlock the full potentiality of the topics taught by upskilling their future career.

Express Your Interest

Additional information

Certification Institute:

Athens Tech College

Save the Dates:

– Fridays:
23/11, 30/11: 18.00-21.15
– Saturdays:
24/11, 01/12: 10.00-18.00

Duration:

23-November-18 till 01-December-18
25 Hours

Premises:

Athens Tech College

Registration Policy

Early Bird: 300€ (Until 11-November; Limited number of tickets available)

Normal Registration: 350€ (Limited number of tickets available)

Participant’s registration (payment's completion) implies full compliance and acceptance οf Code.Learn – Terms & Conditions.