강의

멘토링

로드맵

Inflearn brand logo image
Programming

/

Database

Do it! Introduction to SQL with Oracle - Direct Instruction by the Author

Based on Oracle 21C, from concept to practice, the easiest way to learn SQL for the first time! Directly taught by the author of EGIS Publishing's 《Do it! SQL for Beginners with Oracle》! We'll teach non-majors and beginners step-by-step.

(4.2) 5 reviews

20 learners

  • groovysunday
저자 직강
SQL
Oracle
DBMS/RDBMS
database
data-analysis

Reviews from Early Learners

What you will learn!

  • Database Concept

  • SQL Basic and Use

  • Oracle database

🎓 Course Overview

Practical Database & SQL Course, finish it all with this one course

  • The course is directly conducted by an instructor selected as Oracle ACE for contributions to the Oracle technology community.

  • This is a lecture directly conducted by the author of 《Do it! Learning SQL with Oracle》.
    From beginners learning SQL and databases for the first time to working professionals who need to handle DBMS/RDBMS in practice, you can learn through a complete flow from concepts → practical examples → exercise solutions.

  • Based on an Oracle practice environment, this course includes SQL syntax, data manipulation/definition, permission management, and all review problem solutions, making this single course sufficient without needing any additional lectures.

※ For inquiries regarding corporate/institutional lectures and group training, please refer to [Corporate Lecture Inquiry Link] on the 🔗[Introduction] page.


👨‍🏫 Author & Instructor Introduction

A 15-year veteran developer & data scientist with experience in both industry and education


👥 Recommended for these people

  • Non-technical beginners with no SQL knowledge

  • Working professionals who need to handle Oracle, DBMS, RDBMS, and SQL in practice

  • Those who want to organize their SQL knowledge or feel like they haven't grasped the flow yet

  • Learners studying SQL in government-funded programs, bootcamps, university courses, etc.

  • For those who want to learn properly with just one course rather than multiple short lectures


📈 Expected Benefits After Taking the Course

  • You can clearly understand the structure of databases and the basic syntax of SQL.

  • You'll learn all the practical essentials including SELECT, GROUP functions, JOIN, subqueries, DML/DDL, and user/permission management.

  • We will practice and solve over 320 examples from the textbook along with all review problems (chapter-by-chapter practice problems).

  • You can grasp concepts by focusing on "why we write it this way" rather than simply listing grammar rules.

  • You can master SQL from the basics to practical application with just this one course.


📚 Course Structure Summary

  • Part 1: Database Fundamentals, Environment Setup
    → 5 lectures / 2 hours 49 minutes

  • Part Two: Data Retrieval Based on SELECT Statements
    → 25 lectures / 15 hours 14 minutes

  • Part Three: DML/DDL/Constraints/Objects
    → 17 lectures / 9 hours 35 minutes

  • Appendix A: User, Permission, and Role Management
    → 3 lectures / 1 hour 00 minutes

  • Wrap-up: Overall summary and review
    → Lecture 1 / 23 minutes

A total of 51 lectures, approximately 29 hours and 3 minutes in duration,
covering over 320 examples from the "Do it! Learning SQL with Oracle" textbook and
all review problems (chapter exercises) through hands-on practice and solutions.


🧠 What are review questions?

These are practice problems included at the end of each chapter in the textbook,
composed of SQL problem types that frequently appear in actual work and assessments.
In this course, we directly practice and solve all review problems to train not only grammar understanding but also SQL problem-solving skills.


🛠 Practice Environment and Tools

  • Oracle Database 21c Express Edition

  • SQL Developer (Oracle's official free GUI tool)

Operating System Requirements

  • Available for installation on Windows Pro / Enterprise / Education editions

  • Windows Home edition users need to install Oracle 11g Express Edition (21c installation not possible)

  • ※ While macOS is not an officially supported operating system by Oracle, it can be installed through separate configuration, and there will be no issues with proceeding with the classes after installation. (However, the macOS installation method is not covered in the lecture)

We provide the necessary content for installation guides and practice data files within the course.


📘 Prerequisites and Reference Information

  • You can take this course even without programming experience or specialized knowledge.

  • We explain everything step by step from basic concepts so that even non-majors can follow along.

  • This course absolutely requires the textbook "Do it! Learning SQL with Oracle for Beginners."
    The course follows the textbook's flow exactly and practices all examples and review problems together.


🌟 What Makes This Course Different

  • Direct instruction from an Oracle ACE selected instructor whose technical contributions have been recognized by Oracle headquarters

  • The only direct lecture by the official author of 《Do it! Learning SQL with Oracle》


  • 29 hours of extensive hands-on practice-focused lectures

  • 320+ textbook examples, complete problem solutions provided

  • Satisfying both beginners & professionals - a complete course


  • Complete learning design that flows from concept understanding → practical application → problem solving

  • Structured to master SQL from basics to practical application with a single course


🎁 Complete 100% of the course and receive bonus materials!

For those who complete 100% of the course and finish everything (we will guide you with an automatic message):

[1] Write Inflearn course review
[2] Complete Google Form survey


📘We will send you the following materials via email that are not included in the textbook and this course, but are currently being used in actual employee training programs:

  • Group Functions / Window Functions / Analytical Functions PDF

  • SQL Practice Code Appendix

Your feedback greatly helps improve the quality of our lectures.
We ask for your active participation. 😊

Recommended for
these people

Who is this course right for?

  • SQL first-timers

  • New Software Engineer and Developer

  • Various practitioners, including practical engineers, data analysts, and data scientists, who need to utilize databases in their work

Need to know before starting?

  • No! If the textbook is ready, you can start learning right away, even without basic prior knowledge. Just make sure you have enough passion and time!

Hello
This is

20

Learners

5

Reviews

3

Answers

4.2

Rating

1

Course

Oracle ACE 로 활동 중이며, 컴퓨터공학, IT컨설팅, AI, 통계학, 수학, 데이터사이언스 등을 전공하고, 소프트웨어 개발자이자 데이터사이언티스트로 활동하며 강의, 집필, 멘토링 등 다양한 대외 활동으로 IT 업계에 기여하고 있습니다. 개발자 팟캐스트 「생존형 개발자 성냥의 불친절한 코딩 이야기」를 기획 및 제작하여 다양한 실무 경험과 노하우를 전달하고 있습니다.

[🔗기업 출강 문의 바로가기] [🔗인프런 멘토링 바로가기] [🔗Oracle ACE 프로필 보기] [🔗팟캐스트 보기]

[경력]

· Oracle ACE 선정 (2025) – 오라클 기술 커뮤니티에 대한 기여를 공식적으로 인정받아 선정
· 행정안전부 도로명주소정보화사업, 고용노동부 내일배움카드, 국토 해양부 건설CALS 등 다양한 정부 프로젝트 참여
· 삼일회계법인, 우리은행, 신한카드, KDB생명, 삼성화재, 한국스마트카드, 현대자동차, BMW코리아, 롯데푸드, LG MMA, 메가존을 포함한 여러 소프트웨어, 데이터 및 AI 프로젝트에서 개발자, 컨설턴트, DBA, 소프트웨어 엔지니어 등으로 활동
· 삼성청년SW아카데미(SSAFY), 멀티캠퍼스, 팀스파르타, 코드스테이츠, 코리아교육그룹, 취준컴퍼니, 탈잉, 인프런, 크라우드웍스 등 다양한 기관과 프로그램을 통해 취업준비생, 일반인, 재직자 대상 소프트웨어 개발, 데이터, AI 강의와 코칭, 멘토링 진행

[저서] [🔗Link]
· 《Do it! 오라클로 배우는 SQL 입문》(이지스퍼블리싱, 2025)
· 《Do it! 오라클로 배우는 데이터베이스 입문》(이지스퍼블리싱, 2018)
· 《프리랜서 가이드라인(e-book)》(에스프레소북, 2018)
· 《JSP Web Programming》(예문사, 2014)

 

 

 

Curriculum

All

51 lectures ∙ (29hr 4min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

4.2

5 reviews

  • at0108428님의 프로필 이미지
    at0108428

    Reviews 5

    Average Rating 5.0

    Edited

    5

    92% enrolled

    I was a bit weak in SQL, so I was studying by purchasing various SQL books when a friend gave me a pre-revision version of a book called "Database Introduction with Oracle," which led me to find this course. I felt that this textbook was definitely more comfortable to read in terms of table of contents and flow compared to the SQL-related books I had purchased and studied before, so I thought since I'm going to study during vacation anyway, I might as well study with the revised edition. So I purchased the revised edition and am currently studying with the course... To get straight to the point, it's so good!! I'm definitely going to recommend this course first to everyone around me who says they're studying SQL. Because first of all, the textbook itself has a well-structured curriculum flow that's easy to read. For example, other SQL textbooks... In Chapter 1, they cover database theory, what relational databases are, database types, DBMS history, and all these theories, and for someone like me who lacks concentration, I get completely drained early on and end up not wanting to continue and getting exhausted. But this book just touches on the really important basic theoretical concepts at the beginning, skipping things like history, and immediately moves to hands-on practice, so the progression is speedy and good. At first, I wondered if I could listen to all the lectures because there were so many hours, but the reason for the long lecture time wasn't because it was like "pause the screen and follow along, you all followed along, right? I trust you followed along... next~" but because they actually provided separate practice time with a timer. If you subtract this timer time, the lecture time would probably be cut in half...? But providing separate practice time like this was really refreshing. In my case, I often pause the lecture midway and follow along a bit, then get distracted by other things, but since they give time with a timer without stopping the online lecture, I could focus entirely on practicing, which was great. Plus, while the practice time was actually a bit short at the beginning, later on I could follow along within that practice time, and the sense of achievement from that was really truly satisfying. Moreover, they explain really important functions used in actual work in great detail, and there are problems to solve at the end of each chapter, and they explain all of those too, which was so good..!! They could have just skipped over it since everything was already explained in the previous material, but the detail of solving each problem one by one - you can definitely tell that the author who wrote the textbook directly is giving the lectures, so I could clearly receive the content and core intentions emphasized in the book through the lectures, and I understood why the lecture time was long. And when you listen, it doesn't actually take that much longer than other lectures..! The time spent pausing lectures and getting distracted while following along with practice was reduced!! 😆😆 I tend to only write reviews for lectures that really moved me... and among those, this is probably the first time I've written such a long review for a lecture 😆😆 If you're like me with poor concentration and can't finish reading a book completely, you'll be able to finish it completely if you study while taking this course. I have the last 5 lectures left now, and I'll finish listening to them all today and prepare for the new semester. Fighting to all university students across the country 💪 😆😆

    • groovysunday
      Instructor

      Hello, Mingmi. Thank you so much for taking your precious time to leave such a detailed and thoughtful review. I'm truly delighted and feel a great sense of fulfillment knowing that you accurately understood the three core intentions I considered most important while creating this course: 'compressed theory in the beginning,' 'providing practice time that feels real-time,' and 'the experience of completely finishing an entire book.' I'm particularly impressed that you maintained focus and felt a sense of achievement through the practice timer. Thank you so much for consistently following along for the full 29 hours. I'm rooting for you to finish the remaining lectures well and have a successful start to the new semester! 💪

  • chinchilla3650님의 프로필 이미지
    chinchilla3650

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    I've tried learning databases and SQL multiple times but always gave up halfway through, but thanks to this course, I was able to complete it. Since the instructor is the book's author who taught directly, it connected well with the book content, and having a separate textbook made it much easier to review and keep up with the progress. It was great that all content from the beginning to the end of the book was covered, allowing me to get an overview of SQL as a whole. In particular, I think it was good that the instructor showed coding in real-time and gave separate practice time in between, making it feel like taking a real-time class even though it was online. For the most important parts in practice like SELECT statements, over 15 hours were allocated for in-depth explanations, and the instructor directly solved the 'review problems' at the end of each chapter, which was fun and helpful. Although it was a long course of over 29 hours and wasn't easy to watch completely, I don't think there's any content to skip. I recommend this to those who find it difficult to study alone and prefer having a book alongside.

    • groovysunday
      Instructor

      Jeich, thank you sincerely for completing the entire long course and leaving such a heartfelt review. Hearing that you've attempted SQL learning several times before but were able to complete this course gives me great satisfaction and joy. I'm incredibly proud as both an author and instructor that the book and lectures were connected, making it easy for you to follow the learning flow. I'm particularly glad that the practice-centered approach and review problem-solving were helpful - it seems my intended approach was well conveyed. As you mentioned, while the course is lengthy, I made every effort to include all the essential content from basics to practical application without omission. I give you a big round of applause, Jeich, for consistently following through to the end. If you have any additional questions during your learning journey, please feel free to reach out anytime. I'll always be here to support you as you continue with deeper learning and practical application. Thank you!

  • renee13wi1907님의 프로필 이미지
    renee13wi1907

    Reviews 4

    Average Rating 5.0

    5

    100% enrolled

    I first learned about the book, then discovered the course and decided to take it! After completing the course, it's great that I also thoroughly reviewed the book! This is my first time with SQL, and I found it easy to understand; I think it's a great course for SQL beginners!!

    • groovysunday
      Instructor

      Renee, thank you so much for your heartfelt and valuable review. I was truly deeply moved to hear that you first learned about the book and then also took the lecture. I hope the book and lecture create synergy together and are even a little helpful for your learning. As both an author and an instructor, I feel a great sense of reward. I put a lot of effort into explaining from basic concepts step by step so that those new to SQL could understand more easily and utilize it in practice. As it was the first lecture launched on Inflearn, I wondered if there might be any shortcomings, but your words that you understood it well are a great encouragement to me, who prepared the lecture. Thank you for consistently following along throughout the course and for leaving such a warm first review. If you have any questions or feel anything is lacking in your future learning process, please feel free to let me know at any time. To provide better content, I will continuously improve and supplement it. Lastly, I hope you have successfully taken the first step in SQL learning through this lecture, and I sincerely support your future growth and great performance in practice. Thank you!

  • hyojay218154님의 프로필 이미지
    hyojay218154

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    As a non-major preparing for a career change to the IT industry, I really felt the need to study SQL, and I learned about this course through a friend's recommendation. After taking the course, I understood why they recommended this book and course. It was great to be able to learn focusing on the core grammar essential for practical work, and the process of naturally learning through repeating examples and solutions was a huge help. The instructor's explanations were also Kind and easy to understand, so it wasn't difficult to follow along, and it was really meaningful to be able to feel the actual work experience. When I studied only with books, it wasn't easy to keep going consistently on my own, but like other reviews mentioned, having you display the stopwatch and give us time to solve problems made it feel like taking a real-time class even though it was an online course, which was really great👍 Thanks to this, I wasn't bored throughout my studies, and even as a non-major, I was able to gradually gain confidence. I think choosing to take the course instead of just reading the book was a really good decision! Thank you for being such a great help in my job change preparation, and now I'm going to go through it thoroughly one more time :D

    • kos님의 프로필 이미지
      kos

      Reviews 11

      Average Rating 4.0

      Edited

      1

      27% enrolled

      The audio recording has very harsh coughing sounds that are recorded too repetitively.... It's quite disappointing to release it like this.

      • groovysunday
        Instructor

        Thank you for the feedback. 🙏 I will check the coughing sounds you mentioned more carefully during the editing process going forward. I apologize for any inconvenience during your studies, and I will work hard to create a better learning environment.

    $149.60

    Similar courses

    Explore other courses in the same field!