PostgreSQL for Silicon Valley AI Developers Handling 200 Billion+ Data Records

This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

(4.6) 17 reviews

390 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

  • PostgreSQL-based database design and table structure design skills

  • Practical SQL writing and the ability to use data retrieval, modification, and deletion patterns

  • Performance optimization skills using indexes, JOINs, and aggregate queries

  • Data Processing Capabilities for the AI Era Using JSONB, Extensions, and pgvector

  • Practical Data Modeling and Operational Understanding Based on PostgreSQL

  • Various Plugins in the PostgreSQL Ecosystem

Recommended for
these people

Who is this course right for?

  • A backend developer who is new to PostgreSQL but wants to understand it thoroughly with a practical, real-world focus

  • Developers who want to learn in depth about indexes, transactions, and JOIN structures beyond the CRUD level

  • A developer who wants to handle JSON, vector data, and extensions with PostgreSQL in the age of AI

  • Junior and mid-level developers who frequently encounter database performance issues and query optimization challenges

  • Job seekers and working developers who want to strengthen their database design and SQL skills for interviews or real-world work.

  • Anyone interested in PostgreSQL’s diverse plugin ecosystem

Hello
This is Hong

Inflearn Verified

Career Verified

10,585

Learners

655

Reviews

175

Answers

4.8

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

17 reviews

4.6

17 reviews

  • 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!!

  • 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.

    • jhong
      Instructor

      Thank you for your kind review, haha. We’ll do our best to provide even more useful content going forward. Have a great day!!

  • gjsu540607534님의 프로필 이미지
    gjsu540607534

    Reviews 15

    ∙

    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!

  • 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!