From: S Hoffman <hoffman7043@gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (1.0)
Subject: Re: Where to learn PostgreSQL for free?
Date: Thu, 16 May 2024 07:17:04 -0700
Message-Id: <E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com>
References: 
 <CA+wokJ-rwfhB-JkKMPKx+j7kNXNM1ggP8R5YEfg3QgM1BdJ76w@mail.gmail.com>
Cc: pgsql-admin@lists.postgresql.org
In-Reply-To: 
 <CA+wokJ-rwfhB-JkKMPKx+j7kNXNM1ggP8R5YEfg3QgM1BdJ76w@mail.gmail.com>
To: Edwin UY <edwin.uy@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/E70F2E8F-B1BE-4C29-A559-B67462912A65%40gmail.com>
Precedence: bulk

Good morning, Edwin,

I understand your concerns about security, especially with your previous exp=
erience on the AWS Free Tier. It=E2=80=99s essential to approach this with a=
 strategy that enhances security while using AWS or any other cloud service.=
 Here are a few steps to help you safeguard your environment:

	1.	Strong Access Controls: Always use strong, unique passwords=
 for your AWS account and databases. Implement Multi-Factor Authentication (=
MFA) to add an extra layer of security.
	2.	Minimal Privilege Principle: Assign the least privilege nec=
essary to your AWS roles and permissions. This limits potential damage if an=
 account is compromised.
	3.	Security Groups and Network ACLs: Configure these to contro=
l inbound and outbound traffic to your instances strictly. This helps preven=
t unauthorized access.
	4.	Regular Monitoring and Audits: Use AWS CloudTrail and other=
 monitoring tools to keep track of activities and detect unusual access patt=
erns or potential security threats.
	5.	Data Encryption: Use AWS=E2=80=99s built-in tools to encryp=
t your data at rest and in transit. This ensures that your data is secure, e=
ven if intercepted.

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

I hope these tips help you feel more confident in using cloud environments s=
ecurely. Wishing you the best in your learning journey!

Best regards,
Sondra

Sent from my iPhone

> On May 15, 2024, at 11:22=E2=80=AFPM, Edwin UY <edwin.uy@gmail.com> wrote:=

>=20
> =EF=BB=BF
> Hi,
>=20
> I need to learn PostgreSQL and some other new skills, worried about findin=
g a new job sort of.
> Budget wise, I don't have the means to do so, especially financially.
>=20
> Does anyone know of any site that is offering free resources to learn Post=
greSQL, install, scripting, backup and recovery.
> I had AWS Free Tier before but that was hacked so I was a bit worried abou=
t going back. Also, I will want to do some install exercise, not sure if tha=
t is something that is possible with AWS as they are pre-build, isn't it?
>=20
> I am sure performance tuning will take a lifetime to learn.
>=20
> Regards,
> Edwin
>=20