강의

멘토링

커뮤니티

Programming

/

Database

やろう!Oracleで学ぶSQL入門 - 著者直講

Oracle 21Cバージョンベース、概念から実践まで、SQLを初めて学ぶ最も簡単な方法! イージスパブリッシングの《Do it! 오라클로 배우는 SQL 입문》著者直講! 非専攻者、入門者を対象に一つ一つお教えします。

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

学習した受講者のレビュー

受講後に得られること

  • データベース概念

  • SQL 基本と活用

  • オラクル データベース

🎓 講義概要

実務型データベース & SQL講義、この講義一つで終わらせます

  • Oracleテクノロジーコミュニティへの貢献によりOracle ACEに選定された講師が直接進行します。

  • 『Do it! Oracleで学ぶSQL入門』の著者が直接進行する講義です。
    SQLとデータベース(Database)を初めて学ぶ方から、実務でDBMS/RDBMSを扱わなければならない会社員まで、概念 → 実習例題 → 練習問題解答まで完結した流れで学習できます。

  • Oracle基盤の実習環境をベースに、SQL文法、データ操作/定義、権限管理、そしてすべての復習問題解説まで含まれているため、別途追加講義なしにこの講義一つで十分です。

※ 企業・機関向けの出張講義および団体教育に関するお問い合わせは、🔗[紹介] ページ内の [企業出張講義お問い合わせはこちら] をご参照ください。


👨‍🏫 著者・講師紹介

実務と教育の両方を経験した15年目の開発者&データサイエンティスト


👥 このような方におすすめします

  • SQLを全く知らない非専攻の初心者

  • 実務でOracle、DBMS、RDBMS、SQLを扱わなければならない会社員

  • SQLを整理したい方や、流れが掴めない方

  • 国費支援、ブートキャンプ、大学の授業などでSQLを学ぶ学習者

  • 短い講義をいくつも受けるより、たった一つでしっかりと学びたい方


📈 受講後の期待効果

  • データベース(Database)の構造とSQL基本文法を明確に理解することができます。

  • SELECT、GROUP関数、JOIN、サブクエリ、DML/DDL、ユーザー/権限管理まで実務の核心をすべて学習します。

  • 教材内の320余りの例題とすべての復習問題(チャプター別練習問題)を一緒に実習し、解説します。

  • 単純な文法の羅列ではなく、「なぜこのように書くのか」を中心に概念を体得することができます。

  • この講義一つだけでSQLの基礎から実務活用まで完成できます。


📚 講義構成まとめ

  • 第一部: データベース基礎、環境設定
    → 5講 / 2時間49分

  • 第二部: SELECT文ベースのデータ照会
    → 25講 / 15時間14分

  • 第三部: DML/DDL/制約条件/オブジェクト
    → 17講 / 9時間35分

  • 付録 A: ユーザー、権限、ロール管理
    → 3講 / 1時間 00分

  • まとめ: 全体の要約と整理
    → 1講 / 23分

51講、約29時間3分の分量で、
『Do it! オラクルで学ぶSQL入門』教材の320余りの例題
すべての復習問題(チャプター別練習問題)を一緒に実習し、解説します。


🧠 復習問題とは?

教材の各章末に収録された練習問題で、
実際の実務や評価でよく出題されるSQL問題のタイプで構成されています。
この講義では、すべての復習問題を直接実習して解説し、文法理解を超えてSQL問題解決能力まで一緒に訓練します。


🛠 実習環境とツール

  • Oracle Database 21c Express Edition

  • SQL Developer(Oracle公式無料GUIツール)

推奨オペレーティングシステム

  • Windows Pro / Enterprise / Education エディションでインストール可能

  • Windows Home エディションユーザーは Oracle 11g Express Edition のインストールが必要(21c インストール不可)

  • ※ macOSはOracleの公式サポート対象OSではありませんが、別途設定により インストールが可能で、インストール後の授業進行には支障ありません。(ただし、macOSのインストール方法は講義では扱いません)

講義内のインストールガイドおよび実習用データファイルについて必要な内容を提供します。


📘 前提知識および参考事項

  • プログラミング経験や専攻知識がなくても受講できます。

  • 非専攻者でもついてこられるよう、基礎概念から一歩ずつ丁寧に説明します。

  • 本講義は『Do it! Oracleで学ぶSQL入門』教材が必須です。
    講義は教材の流れをそのまま辿りながら、すべての例題および復習問題を一緒に実習します。


🌟 講義だけの差別化ポイント

  • Oracle本社から技術貢献を認められたOracle ACE選定講師の直接講義

  • 《Do it! オラクルで学ぶSQL入門》公式著者による唯一の直接講義


  • [[SPAN_1]]✔[[/SPAN_2]]29時間分の膨大な実習中心の講義

  • 320個以上の教材例題、全問題解説提供

  • 初心者&実務者どちらも満足できる完結型講義


  • 概念理解 → 実習適用 → 問題解決まで繋がる完結型学習設計

  • 一つの講義でSQLの基礎から実務活用まで習得できるよう構成


🎁講義を100%受講すると、ボーナス資料をプレゼントします!

講義を100%受講し、すべて完了していただいた方には(自動メッセージでご案内いたします):

[1] Inflearn受講レビュー作成
[2] Googleフォームアンケート作成


📘教材と本講義には含まれていない、実際の在職者課程で活用中の以下の資料をメールでお送りします:

  • グループ関数 / ウィンドウ関数 / 分析関数 PDF

  • SQL実習コード付録

皆様のフィードバックは講義の品質向上に大きな助けとなります。
多くのご参加をお願いいたします。😊

こんな方に
おすすめです

学習対象は
誰でしょう?

  • SQL初心者の方なら誰でも

  • 新人ソフトウェアエンジニアおよび開発者

  • データベースを業務に活用すべき実務エンジニア、データアナリスト、データサイエンティストを含む様々な実務者

前提知識、
必要でしょうか?

  • いいえ! 基本的な事前知識なしで教材が用意されていれば、すぐに学習を開始できます。ただし、情熱と時間は十分に準備してください!

こんにちは
です。

27

受講生

5

受講レビュー

3

回答

4.2

講座評価

1

講座

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)

 

 

 

カリキュラム

全体

51件 ∙ (29時間 4分)

講座資料(こうぎしりょう):

授業資料
講座掲載日: 
最終更新日: 

受講レビュー

全体

5件

4.2

5件の受講レビュー

  • chinchilla3650님의 프로필 이미지
    chinchilla3650

    受講レビュー 2

    平均評価 5.0

    5

    100% 受講後に作成

    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
      知識共有者

      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!

  • hyojay218154님의 프로필 이미지
    hyojay218154

    受講レビュー 1

    平均評価 5.0

    5

    100% 受講後に作成

    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

    • at0108428님의 프로필 이미지
      at0108428

      受講レビュー 5

      平均評価 5.0

      修正済み

      5

      92% 受講後に作成

      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
        知識共有者

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

    • renee13wi1907님의 프로필 이미지
      renee13wi1907

      受講レビュー 4

      平均評価 5.0

      5

      100% 受講後に作成

      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
        知識共有者

        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!

    • kos님의 프로필 이미지
      kos

      受講レビュー 13

      平均評価 4.2

      修正済み

      1

      27% 受講後に作成

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

      • groovysunday
        知識共有者

        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.

    ¥23,976

    似ている講座

    同じ分野の他の講座を見てみましょう!