pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhere to learn PostgreSQL for free?
7+ messages / 7 participants
[nested] [flat]
* Where to learn PostgreSQL for free?
@ 2024-05-16 06:21 Edwin UY <edwin.uy@gmail.com>
2024-05-16 06:26 ` Re: Where to learn PostgreSQL for free? Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-16 06:27 ` Re: Where to learn PostgreSQL for free? =?Windows-1252?Q?Gabriel_Guillem_Barcel=F3_Soteras?= <gbarcelo@parlamentib.es>
2024-05-16 08:24 ` Re: Where to learn PostgreSQL for free? Alvaro Herrera <alvherre@alvh.no-ip.org>
2024-05-16 11:24 ` Re: Where to learn PostgreSQL for free? Peter Gram <peter.m.gram@gmail.com>
2024-05-16 11:40 ` Re: Where to learn PostgreSQL for free? hubert depesz lubaczewski <depesz@depesz.com>
2024-05-16 14:17 ` Re: Where to learn PostgreSQL for free? S Hoffman <hoffman7043@gmail.com>
0 siblings, 6 replies; 7+ messages in thread
From: Edwin UY @ 2024-05-16 06:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 install exercise, 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where to learn PostgreSQL for free?
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
@ 2024-05-16 06:26 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
5 siblings, 0 replies; 7+ messages in thread
From: Kashif Zeeshan @ 2024-05-16 06:26 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi
There alot of resource available, I have shared some links as well, you can
also watch videos on Youtube.
https://www.postgresql.org/docs/online-resources/
https://www.postgresqltutorial.com/
https://www.enterprisedb.com/news/edb-makes-postgres-training-free
For practice you can use Oracle Virtual Box and use Linux VM or you can use
any online available cloud lab environments.
Regards
Kashif Zeeshan
Bitnine Global
On Thu, May 16, 2024 at 11:22 AM 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 install exercise, 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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where to learn PostgreSQL for free?
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
@ 2024-05-16 06:27 ` =?Windows-1252?Q?Gabriel_Guillem_Barcel=F3_Soteras?= <gbarcelo@parlamentib.es>
5 siblings, 0 replies; 7+ messages in thread
From: Gabriel Guillem Barceló Soteras @ 2024-05-16 06:27 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
You would ‘only’ need Virtual Box or VMWare Workstation Pro (now it’s free). Test virtual Machine do not need a lot of resources. E.G. 1 core and 1GB of RAM is ok. Then your friend will be PostgreSQL docs, and some tutorials you can find.
From: Edwin UY <edwin.uy@gmail.com>
Date: Thursday, 16 May 2024 at 08:22
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Where to learn PostgreSQL for free?
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 install exercise, 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where to learn PostgreSQL for free?
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
@ 2024-05-16 08:24 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
5 siblings, 0 replies; 7+ messages in thread
From: Alvaro Herrera @ 2024-05-16 08:24 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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)
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where to learn PostgreSQL for free?
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
@ 2024-05-16 11:24 ` Peter Gram <peter.m.gram@gmail.com>
5 siblings, 0 replies; 7+ messages in thread
From: Peter Gram @ 2024-05-16 11:24 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi Edwin
There is the manual https://www.postgresql.org/docs/16/index.html and
together with https://edu.postgrespro.com/postgresql_internals-14_en.pdf
you get well educated :-)
Med venlig hilsen
Peter Gram
Sæbyholmsvej 18
2500 Valby
Mobile: (+45) 5374 7107
Email: peter.m.gram@gmail.com
On Thu, 16 May 2024 at 08:22, 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 install exercise, 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
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where to learn PostgreSQL for free?
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
@ 2024-05-16 11:40 ` hubert depesz lubaczewski <depesz@depesz.com>
5 siblings, 0 replies; 7+ messages in thread
From: hubert depesz lubaczewski @ 2024-05-16 11:40 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Where to learn PostgreSQL for free?
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
@ 2024-05-16 14:17 ` S Hoffman <hoffman7043@gmail.com>
5 siblings, 0 replies; 7+ messages in thread
From: S Hoffman @ 2024-05-16 14:17 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Good morning, Edwin,
I understand your concerns about security, especially with your previous experience on the AWS Free Tier. It’s 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 necessary to your AWS roles and permissions. This limits potential 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 detect unusual 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 data is secure, even 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 management 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 securely. Wishing you the best in your learning journey!
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 install exercise, 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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-05-16 14:17 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-16 06:21 Where to learn PostgreSQL for free? Edwin UY <edwin.uy@gmail.com>
2024-05-16 06:26 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-16 06:27 ` =?Windows-1252?Q?Gabriel_Guillem_Barcel=F3_Soteras?= <gbarcelo@parlamentib.es>
2024-05-16 08:24 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2024-05-16 11:24 ` Peter Gram <peter.m.gram@gmail.com>
2024-05-16 11:40 ` hubert depesz lubaczewski <depesz@depesz.com>
2024-05-16 14:17 ` S Hoffman <hoffman7043@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox