강의

멘토링

로드맵

BEST
Programming

/

Database

Database - SQL

This course is for those who are learning database programming for the first time or those who have some knowledge but want to learn systematically. From concepts to practical exercises, you will master the database query language by organizing examples of types that frequently occur in real life.

(4.8) 61 reviews

744 learners

  • kjlee
SQL
Data Engineering

Reviews from Early Learners

What you will learn!

  • Programming using database SQL query language

  • Basic understanding of SQL

The database query language is broadly referred to as CRUD. It refers to creating, retrieving, updating, and deleting data in database tables. Because there's no other use for tables, the information storage unit, other than CRUD, you'll learn these four functions using a query language.

This course uses Microsoft SQL Server as the RDBMS server. However, since the course adheres to ANSI SQL standards, you can also use MySQL, ORACLE, or other databases. We chose MS SQL Server because this course will be integrated with the .NET Framework, ADO.NET, and other platforms.

It's understandable that database query languages are initially challenging. Because databases are based on set theory, they require a way of thinking you rarely use in your daily life. For example, if you were to find the most frequently ordered products by first-year female students in a school who are in the top ten of their class, you'd have to create a subset of many sets based on conditions, then combine the information in the product set with the student subset to obtain the desired answer. This is rarely done in real-world situations. However, database query languages are based on this type of set theory from beginning to end, which is why queries can be confusing.

However, after completing this course with me, you'll have a clear understanding of how to structure queries. Of course, following this course, the course on database modeling is a must-have for developers. I'm confident that if you understand both of these courses, you'll never regret it. Because I also struggled to learn databases, and considering why it took so long and so difficult, I've structured it so that anyone can easily learn it.

* If you feel the speed is slow, we recommend listening at 1.25 or 1.5 speed :)

Recommended for
these people

Who is this course right for?

  • For those who want to learn database from scratch

  • Anyone working on a project in the DA part

  • Anyone working on database related projects

Need to know before starting?

  • Although not required, this program is open to those who can do it.

Hello
This is

5,062

Learners

352

Reviews

148

Answers

4.8

Rating

7

Courses

대략적인 학력  경력을 소개드리겠습니다.

학력

1987년 2월 인하대학교 전자계산학과 졸업

1989년 2월 인하대학교 전자계산학과 대학원 졸업

2009년 8월 한국항공대학교 컴퓨터공학과 응용소프트웨어 박사과정 수료

주요 경력

1989년 1월 ~ 1992년 12월 삼보컴퓨터 기술연구소 

1993년 1월 ~ 1995년 5월 삼성전자 워크스테이션 개발팀

1998년 1월 ~ 2005년 12월 주식회사 아이티에이 대표이사 (소프트웨어 개발, 데이터베이스 설계 및 구축)

2006년 1월 ~ 2017년 12월 국가 기록물 데이터베이스 구축사업 (PM)

2018년 5월 ~ 2019년 3월 코리아IT 컴퓨터 학원 강사 (C#, JAVA, Database)

2019년3월 ~ 현재 ERP, MES Database 설계 

Curriculum

All

32 lectures ∙ (12hr 37min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

61 reviews

4.8

61 reviews

  • m60kys0848님의 프로필 이미지
    m60kys0848

    Reviews 3

    Average Rating 4.7

    4

    31% enrolled

    I took about half of the class. Overall, the lecture quality itself is not bad. If I had to compare, it would be the style of a school professor. I am taking a database class at school, so I took this class to prepare for the exam, and it is enough for the exam. But there is a downside. The person above said that it is okay to follow the class with MYSQL, but in my personal opinion, It seems a little difficult. Of course, the concept itself is similar. For example, there is no SELECT INTO in MYSQL. However, there is a part in the class that teaches SELECT INTO. And because it is so grammatically different, WORKBENCH keeps saying that it is an incorrect SQL grammar. The class is 15~20 minutes long, but if you Google it for 10~15 minutes, you will get really angry. Please refer to it.

    • enni님의 프로필 이미지
      enni

      Reviews 26

      Average Rating 5.0

      5

      100% enrolled

      Looking at the career of the knowledge sharer, you worked as a computer academy instructor for exactly one year, and I think the students who learned directly from you during that time are very lucky. Everyone has their own preferences, but this is exactly the style of lecture I was looking for. Honestly, it doesn't even take 3 minutes to search for MySQL commands, but those who say it's difficult will probably have a hard time studying development in the future.

      • guswns16590934님의 프로필 이미지
        guswns16590934

        Reviews 14

        Average Rating 4.8

        5

        31% enrolled

        It teaches you about the basics and principles that are easy to miss when studying SQL. It is a great lecture. It is composed of more substantial content than the offline lecture that costs 300,000 won. (The 300,000 won lecture is my experience.) I was worried because it felt crude when I first saw the preview lecture, but I have no regrets. However, I think that those who have encountered SQL at least once will understand it better than those who are new to it. I will leave an additional comment! The instructor teaches based on MSSQL, but I took the class with MySQL. The basic principles are the same, but there are small differences in the grammar, so if you are taking the class with MySQL and you practiced according to the instructor but it doesn't work, you can just Google it! In the end, I think understanding the principles comes first, and you can memorize the grammar later.

        • kjlee
          Instructor

          Thank you for your positive review. I plan to continuously update this lecture. I think it is a bit crude, haha. If I update it several times, it will be completed someday. I am glad that it was helpful and I am preparing a follow-up database design lecture. I am also ambitiously preparing it to explain all of my database experience.

      • dhkang2889님의 프로필 이미지
        dhkang2889

        Reviews 1

        Average Rating 4.0

        4

        31% enrolled

        • santachang5698님의 프로필 이미지
          santachang5698

          Reviews 1

          Average Rating 4.0

          4

          100% enrolled

          Limited time deal ends in 5 days

          $33.00

          23%

          $42.90

          kjlee's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!