강의

멘토링

커뮤니티

BEST
Programming

/

Database

[CS Technical Interview 4] Database That Opens Up Your Speaking

A course that helps you understand core database concepts and practice explaining them verbally in interviews

(4.9) 13 reviews

266 learners

Level Beginner

Course period Unlimited

  • yiyj10305235
SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
Tech Interview
Tech Interview
SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
Tech Interview
Tech Interview

Reviews from Early Learners

Reviews from Early Learners

4.9

5.0

KJH

100% enrolled

You did a great job highlighting the key points within the short lecture time, which was very helpful. I really like how you always summarize everything once more at the end. Thank you.

5.0

든든한꼬마

100% enrolled

I knew how important databases are for developers, but I always found it boring whenever I studied the theory in this field. Yongjun's lecture explained the core database theory concisely and clearly, allowing me to learn with interest. The explanations through real-world examples were a great help in understanding the theory intuitively! I'm also taking the SQLD exam soon, and I think this will be very helpful for exam preparation as well. Thank you for the great lecture.

5.0

인섭

83% enrolled

It was great that you covered not only simple SQL syntax but also transactions and permissions. Especially when talking about databases, you can't leave out indexes, and it was a substantial lecture since it included discussions about indexes as well.

What you will gain after the course

  • Understanding Core Database Concepts

  • The ability to explain verbally in technical interviews

  • Practical Workbook PDF that Prepares You for Follow-up Questions

🥲 Have you ever had this experience in an interview?

1. Confusing concepts when answering

InterviewerWhat are the characteristics of object-oriented programming?
💬 Candidate The SOLID principles. First, S is..(omitted)...

This is a situation where the characteristics of object-oriented programming (abstraction, encapsulation, inheritance, polymorphism) and
object-oriented design principles (SOLID) are confused.
This can give the impression that the foundational framework of basic concepts is not established.

2. Knowing only What, but unable to explain How / Why

Interviewer What are the characteristics of TCP?
💬 Candidate It's a protocol that guarantees reliability.
Interviewer What mechanisms guarantee reliability?
💬 Candidate Uh... well... it makes transmission safe... like...

You only know the superficial definition and are not prepared to explain the underlying principles.
If the 3-way handshake, sequence numbers, ACK, retransmission, flow control, and congestion control
are not connected as a single flow, you will inevitably get stuck on follow-up questions.

3. Getting stuck on basic questions

Interviewer What is HTTP?
💬 Candidate Um... it's for sending and receiving data on the web... something like that...?

It's a concept you're very familiar with, but when you actually try to explain it in one sentence, the words don't come out.
This isn't a lack of knowledge, but rather a lack of experience organizing and articulating it.


Just knowing is not enough. It only becomes true skill when you can articulate it.

🔥 So we've structured it this way.

A cut above the rest, premium content for interview preparation

1⃣ CS Notes organized specifically for interview preparation

  • All essential concepts and principles you must review before interviews are compiled and provided as lecture materials.

  • It's structured to build your fundamentals while also being something you can review right before your interview.

  • Not just a simple summary, but with diagrams and easy explanations that even non-majors can fully understand.


Computer Architecture Lecture Material Example

2⃣ Appendix | Interview Practice Materials Provided

  • In interviews, the ability to explain clearly is far more important than simply knowing something.

  • However, organizing and practicing on your own is not easy and can be tedious work.

  • At the end of the lecture materials, we've included "answering in one or two sentences" practice to reduce the effort of organizing your thoughts.


Database Course Appendix Example

3⃣ Prepare for follow-up questions with our Technical Interview Practice Workbook PDFincluded

  • "Will this course alone really be enough for speaking practice?"
    After pondering this question,

    I created a Technical Interview Practice Workbook.

  • I designed it so you can practice speaking as if in a real interview even on your own.

  • You can find detailed information about the workbook structure and how to use it in the workbook introduction video at the beginning of the course.

Operating System Workbook Example

4⃣ A course that keeps growing with a one-time purchase

  • This course is provided with an unlimited enrollment period.

  • The content will continue to expand with new explanations, additional examples, and more.

  • Even if the price increases as content is added, students who have already purchased
    can access all content at no additional cost.

  • It's a CS fundamentals book you can keep coming back to whenever you need it.

💡 Here's how to make the most of this abundant content

1⃣ Download the materials and learn key concepts while watching the lectures.
2⃣ Take notes on important parts to create your own CS interview notebook.
3⃣ Save it on your phone and review briefly whenever you have time.

If you have an interview coming up,
and don't have much time → Use the appendix [Interview Practice] in the course materials to quickly sharpen your interview skills.
If you have time → Complete your speaking practice like a real interview with the Technical Interview Practice Workbook..

🎯 Recommended for

Non-majors, job seekers, career changers, and anyone preparing for technical interviews who needs to be able to articulate CS fundamentals verbally

CS majors who need to review

I've studied it before, but
I can't bring myself to reorganize all that CS knowledge again

Don't open those thick textbooks
again.
We'll cover only the essentials clearly.

Non-CS majors who find CS overwhelming

I'm preparing for a technical interview
for the first time and don't know
where to start

By following the roadmap, you can
focus on learning only
the core CS concepts..

Job seekers with limited time

I don't have time for that.
I just need to quickly review

only the CS topics that come up in interviews

You can quickly review on your own with
lecture materials and
interview chapters available.

🔥 Reviews from students who experienced it first

A truly helpful course.
Already proven by 3,000+ students.

⭐️⭐️⭐️⭐️⭐️

1. A lecture that shows how much the author has thought and considered from the student's perspective (seems to consider the learner's flow of understanding)
2. Easy to understand with diverse visual materials and examples
3. When learning knowledge, mentions and reminds previous content while connecting knowledge. Knowledge connects and the big picture emerges.
4. The depth of knowledge is not shallow. I'm taking OS right after Computer Architecture, and the synergy is great.
5. Scratches all the itches about "why" & "why it's used".
ps. Sorry to the author, but.. this is a lecture I want to keep to myself.

-'Operating Systems' Course Review

⭐️⭐️⭐️⭐️⭐️

Despite the short lecture duration, I really appreciate how you clearly explain only the important parts. Since it was somewhat theory-focused, I didn't expect SQL queries to be covered, but it was great that you showed examples one by one while teaching basic syntax and how to write queries. After that, the coverage of joins, normalization, transactions, indexes and data optimization, and security was excellent. I haven't tried other paid courses yet, but the last lecture appendix titled "Interview Practice" showed actual questions and answers, which was great for self-study and practice. The lecture duration isn't too long if you focus, so I think I'll go through it multiple times. Thank you

-'Database' Course Review

⭐️⭐️⭐️⭐️⭐️

The core content was explained clearly with a logical flow, which helped me quickly organize my understanding of data structures. Thank you for the great lecture.

-'Data Structures' Course Review

⭐️⭐️⭐️⭐️⭐️

Wow... this is really so good...;;;; I need to save up money and buy the entire roadmap.. I'm curious if you're planning to do lectures on Spring as well.. I'll buy it right away..

-Review of 'Java and Object-Oriented Programming'

⭐️⭐️⭐️⭐️⭐️

This is a lecture where you can organize the key concepts of JavaScript all at once by setting aside a day! Great for a reminder before interviews👍



-'JavaScript' Course Reviews

⭐️⭐️⭐️⭐️⭐️

As a non-CS major, I was worried about how to study computer architecture and operating systems among CS knowledge, but the appropriate amount of content made it easy to learn without pressure, and it felt like getting tutored by an expert, which was great. I'm planning to take the operating systems course as well and looking forward to it. Thank you!

-'Computer Architecture' Course Review

🖐 Hello! Let me introduce myself! 🙇

As someone from a non-CS background, when I first prepared for a developer job, I only focused on algorithms and coding tests.
I gained some confidence and passed most coding tests, but I kept failing at the next hurdle—technical interviews. What was the problem? It was the lack of CS (Computer Science) knowledge.

I know the thirst for fundamentals (CS knowledge, programming languages, etc.) better than anyone. I dug through countless materials through self-study and built my own know-how, and now I'm working as a 🧑🏻‍💻 Kakao developer.

Since I was young, I've been more confident than anyone in combining and restructuring various materials to create 'my own consolidated notes'. This course is that secret notebook containing all that know-how and passion.

🚀 The fourth course in the CS Series That Makes You Fluent is Database.

  • Can't quite remember the transaction isolation levels and don't know what problems each level solves?

  • Did you just roughly learn that sharding is vertical partitioning and partitioning is horizontal partitioning and move on?

  • Or do you know that indexes are good for performance, but are still confused about their complex structure and how they work?

📖 Curriculum packed with only the essentials chỉ chứa những nội dung cốt lõi

This is the curriculum and key topics you'll learn in this course.

If there are any unfamiliar keywords, make sure to grasp them firmly this time.

  1. Database Overview

    • Database characteristics, RDBMS, database modeling

  2. Working with SQL

    • SQL Basics CRUD, aggregate functions, subqueries, SQL joins, paging, NoSQL

  3. Normalization

    • Anomalies, various normalization stages (1NF~3NF)

  4. Transaction

    • ACID, transaction states, transaction recovery, transaction isolation levels (level 1~4)

  5. Index and Data Optimization

    • Index types and data structures (B-Tree, B+Tree), composite indexes, sharding, partitioning

  6. Database Security

    • User permission management, SQL injection defense

  7. [Appendix] Interview Practice

    • Review key concepts once more in Q&A format

✏ What we'll cover

1⃣Database Fundamentals Summary for Both Practical Work and Interviews

  • Organize core concepts like SQL, normalization, transactions, indexes, sharding, and security in a logical flow

  • Designed around the context of concepts (why this feature was created)

Course Detailed Curriculum

2⃣ 'Why' Use It - SQL: Learning Core Syntax and Principles

  • Beyond simply listing SQL syntax, you'll learn what the core SQL statements mean, such as JOINwhy we use GROUP BYand in what situations it's needed.

  • You will clearly understand the practical context of frequently used SQL syntax, from basic SELECT to INSERT, UPDATE, DELETE, complex JOIN, subqueries, pagination queries, and more.

Inner Join Process

SQL Basic Syntax Examples

Advanced SQL syntax examples

3⃣Easy explanations of confusing DB concepts (transactions, normalization, indexes, etc.) centered on diagrams

  • You will clearly understand the characteristics of each isolation level, the stages of normalization (1st, 2nd, 3rd normal forms) and anomalies, as well as the complex data structure of indexes (B+Tree) and their operating principles, through intuitive diagrams and visual materials instead of complex text that many beginners find difficult.

  • We help you grasp at a glance through diagrams why each concept is necessary, what problems it solves, and how it impacts actual performance, so you can remember it for a long time.

B+tree data structure of indexes

Anomaly examples

Transaction isolation level examples

👀 Course Preview

If the video is frozen, please refresh :)

Explanation of the DB modeling process

Explanation of transaction isolation levels 1 through 4

Things to note before enrollment

  • Provided learning material format: PDF

Recommended for
these people

Who is this course right for?

  • A non-CS major who feels lost because they're new to studying computer science

  • A computer science major who needs to organize CS concepts before a technical interview

  • A job seeker preparing for a career change who has limited time before a technical interview

Hello
This is

3,787

Learners

170

Reviews

24

Answers

4.9

Rating

7

Courses

Education and Experience

  • Graduate of Seoul National University

  • Current Kakao Server Developer

    Course Introduction I am creating the "Fluent CS" series to help you articulate CS concepts during interviews. Course Philosophy Having started development as a non-computer science major, I understand the importance of CS...

Course Introduction I am creating the "CS for Speaking" series to help you articulate CS concepts during interviews. Course Philosophy Having started development as a non-computer science major, I...

Course Introduction

I am creating the
CS Speaking series to help you articulate CS concepts during interviews.

Teaching Philosophy

I started my development career as a non-CS major and went through a lot of trial and error while personally organizing everything from CS fundamentals to technical interviews. Based on the learning methods and conceptual organization know-how accumulated through that process, I create content that makes core concepts encountered in practice and interviews easy to understand through illustrations.
"I am creating the lectures that I needed back then."

Blog yiyj1030.tistory.com → Running a tech blog that simplifies CS, algorithms, and practical concepts. Contact yiyj1030@gmail.com

Blog

  • yiyj1030.tistory.com
    → Running a tech blog that simplifies and organizes CS, algorithms, and practical concepts

Contact

yiyj1030@gmail.com

Curriculum

All

26 lectures ∙ (3hr 19min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

13 reviews

4.9

13 reviews

  • junkim46857399님의 프로필 이미지
    junkim46857399

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    You did a great job highlighting the key points within the short lecture time, which was very helpful. I really like how you always summarize everything once more at the end. Thank you.

    • yiyj10305235
      Instructor

      Thank you for the course review. I hope this lecture isn't the end and that we can continue the learning journey together. I look forward to seeing you again in the next series :)

  • uiop58096770님의 프로필 이미지
    uiop58096770

    Reviews 4

    Average Rating 5.0

    5

    67% enrolled

    • yiyj10305235
      Instructor

      Thank you for the course review. I hope this lecture isn't the end and that we can continue the learning journey together. I look forward to seeing you again in the next series :)

  • myhwc님의 프로필 이미지
    myhwc

    Reviews 3

    Average Rating 5.0

    5

    83% enrolled

    It was great that you covered not only simple SQL syntax but also transactions and permissions. Especially when talking about databases, you can't leave out indexes, and it was a substantial lecture since it included discussions about indexes as well.

    • yiyj10305235
      Instructor

      Thank you for the course review. I hope this lecture isn't the end and that we can continue the learning journey together. I look forward to seeing you again in the next series :)

  • calculator님의 프로필 이미지
    calculator

    Reviews 113

    Average Rating 4.9

    5

    100% enrolled

    I knew how important databases are for developers, but I always found it boring whenever I studied the theory in this field. Yongjun's lecture explained the core database theory concisely and clearly, allowing me to learn with interest. The explanations through real-world examples were a great help in understanding the theory intuitively! I'm also taking the SQLD exam soon, and I think this will be very helpful for exam preparation as well. Thank you for the great lecture.

    • yiyj10305235
      Instructor

      Thank you for the course review. I hope this lecture isn't the end and that we can continue the learning journey together. I look forward to seeing you again in the next series :)

  • zoseonghun님의 프로필 이미지
    zoseonghun

    Reviews 9

    Average Rating 5.0

    5

    100% enrolled

    Even though the lecture time is short, I really appreciate how you clearly explain only the important parts. I thought it would be mostly theoretical lectures and wouldn't cover SQL query statements, but it was great that you showed examples one by one while teaching basic syntax and how to write query statements. After that, the coverage of joins, normalization, transactions, indexes and data optimization, and security was excellent. I haven't tried other paid lectures yet, but the appendix of the final lecture was titled "Interview Practice" and showed actual questions and answers, which was good for self-study and practice. The lecture time doesn't take too long if you focus and listen, so I think I'll go through it several times again. Thank you.

    • yiyj10305235
      Instructor

      Thank you for the course review. I hope this lecture isn't the end and that we can continue the learning journey together. I look forward to seeing you again in the next series :)

$29.70

yiyj10305235's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!