inflearn logo
inflearn logo

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 수강평 13개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

SQL
SQL
Oracle
Oracle
SQL
SQL
Oracle
Oracle

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.9

5.0

자바전문가그룹

98% 수강 후 작성

Best Oracle SQL Course!!~~~

5.0

Illay

61% 수강 후 작성

Okay.

5.0

kwonsoonkyeong

98% 수강 후 작성

Thank you for explaining it in detail and in an easy-to-understand manner. I think it would be good if you also opened a DBA course. Thank you for teaching with sincerity.

강의상세_배울수있는것_타이틀

  • Oracle Database SQL

  • Installing Oracle Database using Docker and Setting up a Practice Environment

  • Data retrieval using SELECT

  • Oracle Functions (String, Numeric, Date, Regular Expression Functions, Conversion Functions, Set Operators)

  • Data Aggregation Using GROUP BY and Aggregate Functions

  • Analytic functions, window clause, linear regression functions, pivot table

  • Oracle Join, ANSI Join

  • Subquery

  • DML(INSERT, UPDATE, DELETE, MERGE, CTAS)

  • Transaction COMMIT, ROLLBACK

  • Table Creation and Management (CREATE TABLE, ALTER TABLE, DROP TABLE)

  • Constraints

  • View Creation and Management

  • Sequence, Index, Synonym

Do you want to become a developer?

Learning SQL syntax to manage database data is the start of becoming a developer. Learn SQL syntax using Oracle Database.

Features of this course

📌 You can learn more accurate and practical basic skills of Oracle SQL database.

📌 This course is taught by a star instructor expert with over 20 years of teaching experience and project experience.

📌 You can improve your skills through hands-on practice at each lesson and stage.

📌 We teach the essential skills that backend developers must learn.

We recommend this for

I want to learn databases.

Oracle SQL database is the most widely used in enterprises.

I want to get a job as a developer.
Backend development is a fundamental skill for developers. You can't develop without knowing SQL.

Do you want to obtain an SQLD certificate?
After completing your studies, challenge yourself to get the SQLD certification.

The person who created this course

  • Java Specialist Group Operator(javaspecialist.co.kr)

  • Star Training Instructor recognized by the Ministry of Employment and Labor (2021 Information and Communications Field)


  • Information Technology Development, Information Technology Strategic Planning, Artificial Intelligence Training Instructor

💡 This course...

  • Taught by a Star Training Instructor in the 2021 Information and Communications field recognized by the Ministry of Employment and Labor.

  • The course is taught by a professional instructor with perfect foundational knowledge and extensive real-world project experience.


Notes Before Taking the Course

Practice Environment

  • Install the database using Docker on Windows.

  • You will learn SQL syntax using Oracle's SQL Developer.

  • Even Mac users can use the database by installing Docker.

Learning Materials

Prerequisites and Important Notes

  • If you have an interest in programming languages and the confidence to complete the course, that's all you need.

💡If there are any reference notes needed for learning the course, please write them carefully.
This helps students fully understand the content covered in the course and can increase learning satisfaction.

  1. Practice Environment

    • Operating System and Version (OS): Windows

    • Tools used: Docker Desktop, Oracle Database, SQL Developer

    • PC specifications: Any standard PC will do.

  2. Learning Materials

  3. Prerequisites and Notes

    • The learning difficulty is at a basic level, but no prior knowledge is required.

    • All you need is passion for taking the course.

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • Backend Developer

  • Database Programming Developer

  • Web Application Developer

강의소개.지공자소개

1,133

수강생

85

수강평

9

답변

4.8

강의 평점

8

강의_other

Java Specialist Group (JavaSpecialist.co.kr) supports the growth of artificial intelligence.

커리큘럼

전체

58개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

13개

4.9

13개의 수강평

  • javaspecialist님의 프로필 이미지
    javaspecialist

    수강평 8

    평균 평점 5.0

    5

    98% 수강 후 작성

    Best Oracle SQL Course!!~~~

    • smlee7574님의 프로필 이미지
      smlee7574

      수강평 1

      평균 평점 5.0

      5

      100% 수강 후 작성

      • sblee6967님의 프로필 이미지
        sblee6967

        수강평 2

        평균 평점 5.0

        5

        32% 수강 후 작성

        • illay님의 프로필 이미지
          illay

          수강평 2

          평균 평점 5.0

          5

          61% 수강 후 작성

          Okay.

          • hyunseoung8142님의 프로필 이미지
            hyunseoung8142

            수강평 2

            평균 평점 5.0

            5

            32% 수강 후 작성

            javaspecialist님의 다른 강의

            지식공유자님의 다른 강의를 만나보세요!

            비슷한 강의

            같은 분야의 다른 강의를 만나보세요!

            강의상세.할인문구

            $22.00

            28%

            $30.80