PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

(4.6) 15 reviews

351 learners

Level Beginner

Course period Unlimited

MySQL
MySQL
PostgreSQL
PostgreSQL
Oracle
Oracle
DBMS/RDBMS
DBMS/RDBMS
database
database
MySQL
MySQL
PostgreSQL
PostgreSQL
Oracle
Oracle
DBMS/RDBMS
DBMS/RDBMS
database
database

Reviews from Early Learners

4.6

5.0

junki

64% enrolled

I enjoyed the lecture. I purchased it because I needed to perform PostgreSQL tuning, but it seems the tuning-related content isn't as deep as I expected. Personally, I think this course would be great for those who want to gain a broad understanding of PostgreSQL.

5.0

warna

92% enrolled

I think this is a level of lecture that is truly hard to find anywhere else. I have only used MySQL before, but this helped me understand the appeal of PostgreSQL even more. Thank you for the great content.

5.0

02년생 개발자

95% enrolled

This is the only instructor on Inflearn whose notifications I keep on and whose content I watch every single time... You always explain theories through various illustrations, and just as mentioned in the introduction, 90% of the course is hands-on practice. I think that makes it even more informative and fun. Rather than a rigid, pre-scripted lecture, you teach in a very realistic way, which fits my style much better. (You do make mistakes occasionally, lol, but you coolly admit to them!) I'm also participating in the community, and I'm always learning so much because you share useful information and answer questions so kindly every time. Thank you always. I write course reviews often, but this is the first time I've written one this long!!

What you will gain after the course

  • Ability to design PostgreSQL-based databases and table structures

  • Practical SQL writing skills and the ability to utilize data retrieval, modification, and deletion patterns.

  • Performance optimization capabilities utilizing indexes, JOINs, and aggregate queries

  • Data processing capabilities in the AI era utilizing JSONB, extensions, and pgvector

  • Practical Data Modeling and Operational Insights Based on PostgreSQL

  • Various Plugins in the PostgreSQL Ecosystem

Recommended for
these people

Who is this course right for?

  • A backend developer who is learning PostgreSQL for the first time but wants to properly understand it with a focus on practical application.

  • Developers who want to go beyond the CRUD level and gain a deep understanding of indexes, transactions, and JOIN structures.

  • Developers who want to handle JSON, vector data, and extensions with PostgreSQL in the AI era

  • Junior and intermediate developers who frequently encounter database performance issues and query optimization challenges

  • Job seekers and current developers who want to strengthen their database design and SQL application skills for interviews or practical work.

  • Those who are curious about PostgreSQL's diverse plugin ecosystem

Hello
This is Hong

Inflearn Verified

Career Verified

10,102

Learners

636

Reviews

165

Answers

4.7

Rating

34

Courses

I started studying development after becoming interested in it while idling at home, and I am currently responsible for platform server development in Pangyo. I am continuing my activities as a knowledge sharer because I want to provide you with the methods I used to study, as well as the various problems and solutions you may encounter in practice.

 

These lectures are not created solely through my own knowledge. There are others who collaborate on every lecture.

 

[Instructor Career]

[Former] Blockchain developer related to Sandbox IP

[Former] Metaverse Backend Developer

[Current] A server developer becoming a veteran in Pangyo

 

[Interview History]

[Other Inquiries]

[Official Site]

More

Curriculum

All

39 lectures ∙ (9hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

15 reviews

4.6

15 reviews

  • smaller님의 프로필 이미지
    smaller

    Reviews 15

    Average Rating 5.0

    5

    100% enrolled

    I've learned that Elephant SQL (PostgreSQL) is the mainstream now. As a user who has only used Oracle and MySQL, it was a very refreshing experience.

    • gjsu540607534님의 프로필 이미지
      gjsu540607534

      Reviews 13

      Average Rating 5.0

      5

      95% enrolled

      This is the only instructor on Inflearn whose notifications I keep on and whose content I watch every single time... You always explain theories through various illustrations, and just as mentioned in the introduction, 90% of the course is hands-on practice. I think that makes it even more informative and fun. Rather than a rigid, pre-scripted lecture, you teach in a very realistic way, which fits my style much better. (You do make mistakes occasionally, lol, but you coolly admit to them!) I'm also participating in the community, and I'm always learning so much because you share useful information and answer questions so kindly every time. Thank you always. I write course reviews often, but this is the first time I've written one this long!!

      • jhong
        Instructor

        Hello, developer born in '02! Thank you for leaving such a great review!! I will continue to provide even more helpful content in the future!! Have a great day today!

    • junjun님의 프로필 이미지
      junjun

      Reviews 1

      Average Rating 5.0

      5

      64% enrolled

      I enjoyed the lecture. I purchased it because I needed to perform PostgreSQL tuning, but it seems the tuning-related content isn't as deep as I expected. Personally, I think this course would be great for those who want to gain a broad understanding of PostgreSQL.

      • jhong
        Instructor

        Hello Junki, thank you for leaving a review. If you could share your thoughts on which specific parts you are curious about, I will provide a quick answer. I would appreciate it if you could ask your questions through Inflearn!! Also, it would be very helpful if you could join our community and share the things you've learned while proceeding with the tuning ㅎㅎ Have a great day!

      • Hello instructor. First of all, I enjoyed the lectures and they were very helpful. Thank you for taking the time to leave a reply. Actually, since there aren't many Korean lectures regarding PostgreSQL, I looked up several foreign lectures on YouTube. I noticed that regarding tuning, they cover not only query writing methods and index settings but also PostgreSQL's memory structure and its corresponding configuration values. In my personal opinion, I thought it would have been great if explanations on those parts were also included. (Additionally, on a very personal note, I thought it would be good if there were explanations for more complex and diverse cases regarding 'explain'.)

      • jhong
        Instructor

        Ah, I see. ㅠㅠ I covered the basic concepts slowly in hopes that this lecture would be beneficial even for those seeing it for the first time, so I'm sorry I couldn't get into the tuning perspective. ㅠㅠ I will work harder to cover more advanced topics in the future so that I can satisfy you as well, Junki!!

    • warna97725274님의 프로필 이미지
      warna97725274

      Reviews 13

      Average Rating 5.0

      5

      92% enrolled

      I think this is a level of lecture that is truly hard to find anywhere else. I have only used MySQL before, but this helped me understand the appeal of PostgreSQL even more. Thank you for the great content.

      • sangduck5380님의 프로필 이미지
        sangduck5380

        Reviews 1

        Average Rating 3.0

        3

        31% enrolled

        Hong's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!