inflearn logo

A Silicon Valley AI Developer's PostgreSQL for Handling 200+ Billion Records

This course goes beyond basic CRUD-level database operations, equipping you with practical PostgreSQL skills essential for the AI era from a real-world perspective. Drawing on AI development experience in Silicon Valley, you will learn step-by-step how to design and leverage JSON, indexing, transactions, and pgvector in actual production services, and master the techniques to resolve complex data structure and performance issues.

(4.6) 14 reviews

348 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

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

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.

What you will gain after the course

  • Proficiency in PostgreSQL-based database and table schema design

  • Proficiency in practical SQL development and applying data retrieval, update, and deletion patterns.

  • Expertise in performance optimization leveraging indexes, JOINs, and aggregate queries.

  • Data Processing Capabilities in the AI Era Powered by JSONB, Extensions, and pgvector

  • Understanding Practical Data Modeling and Operational Perspectives in PostgreSQL

  • Various Plugins in the PostgreSQL Ecosystem

Recommended for
these people

Who is this course right for?

  • Backend developers who are new to PostgreSQL but want to gain a solid understanding of it with a focus on real-world applications.

  • Developers looking to go beyond basic CRUD operations and gain an in-depth understanding of indexes, transactions, and JOIN structures.

  • Developers looking to handle JSON, vector data, and extensions using PostgreSQL in the AI era

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

  • Job seekers and working developers looking to enhance their database design and SQL skills for interviews and practical work.

  • For those curious about PostgreSQL's diverse plugin ecosystem

Hello
This is Hong

Inflearn Verified

Career Verified

9,984

Learners

629

Reviews

165

Answers

4.7

Rating

32

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

14 reviews

4.6

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

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

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

    • fireking59972259님의 프로필 이미지
      fireking59972259

      Reviews 3

      Average Rating 5.0

      5

      36% enrolled

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

        25% off for new members

        $87.70

        25%

        $117.70