inflearn logo

Essential Database Concepts You Must Know When Coding with AI ①

AI-generated SQL ran without errors—but does that mean the result is correct? Learn to identify missing criteria in a row’s meaning, values, queries, aggregations, changes, and concurrent requests, as well as which data rules to communicate to AI and what evidence to use when reviewing the results.

3 learners are taking this course

Level Basic

Course period Unlimited

SQL
SQL
PostgreSQL
PostgreSQL
DBMS/RDBMS
DBMS/RDBMS
concurrent
concurrent
database
database
SQL
SQL
PostgreSQL
PostgreSQL
DBMS/RDBMS
DBMS/RDBMS
concurrent
concurrent
database
database

What you will gain after the course

  • Even if the SQL generated by AI runs without errors, you can determine whether the result meets the requirements by examining what each row represents and what was counted as a single item.

  • I can identify where the numbers differ—such as NULL versus 0, units and time zones, or an increase in rows after a join—and explain which stage the issue occurred in.

  • You can provide the AI with the row’s grain, relationships, allowed values, and change conditions instead of table names, and have it evaluate even concurrent requests and query costs based on supporting evidence.

Recommended for
these people

Who is this course right for?

  • Beginner to intermediate developers building services with AI but lacking the criteria to determine whether the generated SQL and table designs are correct

  • Those who want to understand the principles of how data is stored and retrieved while working in product planning or frontend development

  • Those who have learned SQL syntax but still find it unclear why results differ with NULLs, JOINs, transactions, and indexes.

Need to know before starting?

  • You don’t need experience with SQL or server development. There are no coding exercises or environment setup required.

  • It’s enough if the rows and columns of the table are readable.

Hello
This is haeyeomiso

Career Verified

479

Learners

22

Reviews

39

Answers

4.7

Rating

10

Courses

Nice to meet you!

I am Haeyeo, someone who explores the infinite possibilities of AI and computer science and wishes to share that journey with all of you.

During my undergraduate years, my passion for my major was so intense that I was nicknamed a 'Computer Science Addict.' I graduated at the top of my class with a major GPA of over 4.4. I then earned my Master's degree in AI from Seoul National University and further deepened my expertise through a doctoral program.

However, as I felt as much of a fascination for solving real-world problems with AI as I did for theoretical exploration, I took a break from my doctoral studies to gain valuable hands-on experience by working on AI-based LLM and video analysis projects at a startup.

Currently, I am working as an LLM project developer and PM at one of the top three conglomerates in Korea, contributing to creating positive changes that AI technology will bring to our lives. I will generously share with you the challenges I faced, the problem-solving processes I went through, and the vivid know-how I gained in the field. I will be your reliable guide on this journey into the exciting world of AI.

Inquiries and Proposals: haeyeo.open@gmail.com

More

Curriculum

All

40 lectures ∙ (6hr 49min)

Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

haeyeomiso's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$35.20

33%

$52.80