Thread: Where to learn PostgreSQL for free?

On 2024-May-16, Edwin UY wrote:

> Hi,
> 
> I need to learn PostgreSQL and some other new skills, worried about finding
> a new job sort of.
> Budget wise, I don't have the means to do so, especially financially.
> 
> Does anyone know of any site that is offering free resources to learn
> PostgreSQL, install, scripting, backup and recovery.

There are tons of videos from conferences and meetups; if you start at
https://wiki.postgresql.org/wiki/Category:PostgreSQL_Events
and follow the links, you'll likely find plenty of useful material.

It's sad that the conferences this decade have stopped posted their
stuff to the wiki, at least a single page with a talk listing.  You can
of course visit each conference site, but that's tedious ...

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Cada quien es cada cual y baja las escaleras como quiere" (JMSerrat)

On Thu, May 16, 2024 at 06:21:59PM +1200, Edwin UY wrote:
> Does anyone know of any site that is offering free resources to learn
> PostgreSQL, install, scripting, backup and recovery.

1. Install pg on your computer. It's free, and you can do whatever you
   want to/with it.
2. Read manual: https://www.postgresql.org/docs/current/tutorial.html
3. Join IRC/Slack/Discord and ask for clarification if something isn't
   clear.

Best regards,

depesz

Good morning, Edwin,

I understand your concerns about security, especially with your previous experience on the AWS Free Tier. It’s
essentialto approach this with a strategy that enhances security while using AWS or any other cloud service. Here are a
fewsteps to help you safeguard your environment: 

    1.    Strong Access Controls: Always use strong, unique passwords for your AWS account and databases. Implement
Multi-FactorAuthentication (MFA) to add an extra layer of security. 
    2.    Minimal Privilege Principle: Assign the least privilege necessary to your AWS roles and permissions. This
limitspotential damage if an account is compromised. 
    3.    Security Groups and Network ACLs: Configure these to control inbound and outbound traffic to your instances
strictly.This helps prevent unauthorized access. 
    4.    Regular Monitoring and Audits: Use AWS CloudTrail and other monitoring tools to keep track of activities and
detectunusual access patterns or potential security threats. 
    5.    Data Encryption: Use AWS’s built-in tools to encrypt your data at rest and in transit. This ensures that your
datais secure, even if intercepted. 

Regarding your interest in installation exercises, while AWS does offer pre-built options, you can also configure
customPostgreSQL installations on EC2 instances. This allows you to practice installation, configuration, and
managementas if you were handling a server in your own data center. 

I hope these tips help you feel more confident in using cloud environments securely. Wishing you the best in your
learningjourney! 

Best regards,
Sondra

Sent from my iPhone

> On May 15, 2024, at 11:22 PM, Edwin UY <edwin.uy@gmail.com> wrote:
>
> 
> Hi,
>
> I need to learn PostgreSQL and some other new skills, worried about finding a new job sort of.
> Budget wise, I don't have the means to do so, especially financially.
>
> Does anyone know of any site that is offering free resources to learn PostgreSQL, install, scripting, backup and
recovery.
> I had AWS Free Tier before but that was hacked so I was a bit worried about going back. Also, I will want to do some
installexercise, not sure if that is something that is possible with AWS as they are pre-build, isn't it? 
>
> I am sure performance tuning will take a lifetime to learn.
>
> Regards,
> Edwin
>