I have been learning postgreSQL for few days now this is my first relational database, I have been using https://pgexercises.com/ for practice. could you guys suggest me some similar sites to practice and a postgreSQL playground as well.

Hello! I’m a beginner in my SQL journey. does anyone know of free practice for Joins and Subqueries? i’m working my way through Datacamps sql fundamentals now and want some targeted practice. all data camp has for practice are multiple choice questions and other free resources seem to use slightly different query styles than datacamp.

Hi! I'm looking to learn to use PostgreSQL. I already know some base about database and sql since i'm working regularly with GIS. My job is offering me to free some of my time to boost my skills in database and PostgreSQL seem really interresting. What are your best suggestion for where to educate myself with PostgreSQL? Idealy somewhere with pratical exercise since it help me a lot to learn. French is my first language but I read fluently in english so I'm open to suggestions for both languages.

Thanks a lot in advance

Edit : Thanks a lot everyone for all the suggestion!

I’ve recently completed two beginner SQL courses and tackled the SQL 50 LeetCode challenge. I’m soon starting a role as a data analyst where I’ll be extensively working with PostgreSQL. My responsibilities will include importing data from multiple sources using ETL pipelines and creating custom dashboards.

I want to become a PostgreSQL expert. Can you recommend tutorials that go beyond the basics into advanced PostgreSQL concepts, with practical applications and best practices, and coding exercises?

If you’ve taken or know of any high-quality resources that meet these criteria, I’d greatly appreciate your recommendations! Thank you in advance for your help!

I’ve recently completed two beginner SQL courses and tackled the SQL 50 LeetCode challenge. I’m soon starting a role as a data analyst where I’ll be extensively working with PostgreSQL. My responsibilities will include importing data from multiple sources using ETL pipelines and creating custom dashboards.

I want to become a PostgreSQL expert. Can you recommend tutorials that go beyond the basics into advanced PostgreSQL concepts, with practical applications and best practices, and coding exercises?

If you’ve taken or know of any high-quality resources that meet these criteria, I’d greatly appreciate your recommendations! Thank you in advance for your help!

Hello Everyone!

I've heard the PostgreSQL is widely used among the companies so im thinking to start learning it. I have no idea where to start. Can anyone share free resources( youtube tutorials or any websites). Also what tools/platform should i use for this. Where should i practice it?

Hi, I'm looking for some web hosting that would let me use PostgreSQL with a free plan on it. I'd like to experiment with triggers and listen/notifications, too.

I know there are some that offer this service, like AWS, but unlike it I would need that if my traffic/usage goes above the free plan the services just interrupts and let me choose if I wish to upgrade or not rather than directly billing me. Bonus points if it's easy to scale and not too expensive just in case my today's hobby becomes a production app some day.

If there's such a thing, please let me know. Appreciated!

I’m learning PostgreSQL and wondering what’s better: practicing SQL directly in the database, or mainly accessing it through Python (psycopg2)

Curious what you’d recommend for a beginner!

I'm still a beginner, or somewhere between beginner and intermediate.

I know React, Express, and a bit of MongoDB (not much—just built some CRUD apps and a few messy projects where I implemented basic search functionality). I'm currently diving deep into authentication and authorization with Node.js.

I also know the basics of MySQL—up to joins, but nothing too advanced.

I’ve noticed a lot of people building projects with either MongoDB or PostgreSQL. From what I understand, MongoDB is great for building things quickly, but I’m not sure how well it scales for long-term or large-scale applications.

I’ve also heard (and seen in many YouTube videos) that PostgreSQL is more advanced and commonly used in serious, large-scale projects. So, I figured instead of mastering MySQL or MongoDB first, why not go straight for what’s considered the best—PostgreSQL?

Am I making the right move by jumping straight into Postgres? I do have solid basics in both MongoDB and MySQL.

If I’m on the right track, can someone recommend solid resources for learning PostgreSQL? I know everything’s on YouTube, but I’ve stopped learning from there—most tutorials are just clickbait or poorly made.

I’m looking for something like proper documentation or a clean, structured web-based course—something like javascript.info, LearnPython, or RealPython. That’s how I learned JS and Python on my own, and it worked really well for me.

I know many of you will say "just read the documentation," and I agree—but reading raw docs can be tough. I’d prefer something chapter-wise or topic-wise to help me stay consistent and focused.

Every opinion is welcome.

Also, please don’t downvote this post. I genuinely don’t get why some people (not all, of course) downvote posts just because they’re not “advanced” enough or don’t match Stack Overflow’s formatting obsession. This isn’t a code dump—it's a learning journey.

Could somebody please suggest any good youtube channels, resources in order to practice all the skills that I had learned throught out the PostgreSQL course . Any help is appreciated

Just want to dive in into learning postgreSQL, there are so many resources out there; I would like to know w/c ones are more suited for those who are already have background with MySQL.

Please do suggest resources to learn postgresql in depth. The content can be anything from courses to books to websites that offer hands on learning.

Thanks in advance. Any help and suggestions and advice is highly appreciated 👍

Hey there! I’m pursuing a CS degree, and I’m currently enrolled in a module about data and information. We did some SQL queries in September, but it was only a one-week introduction to databases. As you can imagine, playing around with SQL queries for just one week didn’t really lay a solid foundation for thinking through queries or tackling more advanced stuff. In this module, we started with views and indexes, and I found the latter a bit hard without really understanding how to write good queries and how they work internally. I mean, I can grasp the very basic things like retrieving information about an employee from table A and his vacation dates from table B. But I don’t understand how “JOIN” actually works, nor how to make more advanced queries. I need a good resource, like a book, that explains all the SQL stuff needed for a good start and understanding. I’ve been looking at some books specifically on PostgreSQL (it wasn’t actually my choice to learn this particular database system; it’s required for the project), but most of them assume that the reader has some experience with SQL. What would you guys recommend?

Is there any website on which I can practice PostgreSQL questions? Like Hackerrank, but they don't support PostgreSQL, or DatalLemur.

Yesterday I posted a question about the value of subqueries in everyday life. I’d like to thank this wonderful community for your replies. I’ll definitely persevere until I understand subqueries.

Now I need advice on practice platforms. I use LeetCode, but it only has 50 exercises. Which platform is the best for practicing SQL? Thanks again for your kindness. Much respect

I want to practice on something as close as possible to real-life database, where can I find such database?