inflearn logo
강의

Course

Instructor
inflearn logo
Programming

/

Database

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 13 reviews

146 learners

Level Basic

Course period Unlimited

SQL
SQL
Oracle
Oracle
SQL
SQL
Oracle
Oracle

Reviews from Early Learners

4.9

5.0

자바전문가그룹

98% enrolled

Best Oracle SQL Course!!~~~

5.0

Illay

61% enrolled

Okay.

5.0

kwonsoonkyeong

98% enrolled

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.

What you will gain after the course

  • 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.

Recommended for
these people

Who is this course right for?

  • Backend Developer

  • Database Programming Developer

  • Web Application Developer

Hello
This is javaspecialist

1,213

Learners

91

Reviews

10

Answers

4.8

Rating

8

Courses

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

Curriculum

All

58 lectures ∙ (14hr 57min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

13 reviews

4.9

13 reviews

  • javaspecialist님의 프로필 이미지
    javaspecialist

    Reviews 8

    ∙

    Average Rating 5.0

    5

    98% enrolled

    Best Oracle SQL Course!!~~~

    • navercom님의 프로필 이미지
      navercom

      Reviews 10

      ∙

      Average Rating 5.0

      5

      100% enrolled

      It helped me a lot with my final project. Thank you so much.

      • javaspecialist
        Instructor

        Thank you. I hope you study hard and gain a lot of knowledge.

    • illay님의 프로필 이미지
      illay

      Reviews 2

      ∙

      Average Rating 5.0

      5

      61% enrolled

      Okay.

      • kwonsoonkyeong8977님의 프로필 이미지
        kwonsoonkyeong8977

        Reviews 1

        ∙

        Average Rating 5.0

        5

        98% enrolled

        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.

        • smlee7574님의 프로필 이미지
          smlee7574

          Reviews 1

          ∙

          Average Rating 5.0

          5

          100% enrolled

          Similar courses

          Explore other courses in the same field!

          Database - SQLCourse Thumbnail

          Database - SQL

          kjlee

          $42.90

          Basic / SQL, Data Engineering

          4.8

          (61)

          700+

          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.

          Basic

          Basic

          SQL, Data Engineering

          Database - SQLCourse Thumbnail

          Database - SQL

          kjlee

          $42.90

          Basic / SQL, Data Engineering

          4.8

          (61)

          700+
          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)Course Thumbnail

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

          WHIZ

          $26.40

          Basic / SQL, sql-query, bigquery, Data literacy

          5.0

          (4)

          This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

          Basic

          Basic

          SQL, sql-query, bigquery

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)Course Thumbnail

          [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

          WHIZ

          $26.40

          Basic / SQL, sql-query, bigquery, Data literacy

          5.0

          (4)

          [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

          [Practice Makes Perfect] Intermediate SQL for Data Analysis

          datarian

          $29.70

          Basic / SQL

          4.9

          (976)

          5,500+

          Inflearn's SQL intermediate course by Datarian, with over 30,000 cumulative students and extensive online/offline teaching experience. Learn intermediate SQL theory and solve 20 practice problems together.

          Basic

          Basic

          SQL

          [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

          [Practice Makes Perfect] Intermediate SQL for Data Analysis

          datarian

          $29.70

          Basic / SQL

          4.9

          (976)

          5,500+
          SQL data analysis learned through various casesCourse Thumbnail

          SQL data analysis learned through various cases

          dooleyz3525

          $68.20

          Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

          4.9

          (54)

          1,600+

          By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

          Intermediate

          Intermediate

          SQL, PostgreSQL, DBMS/RDBMS

          SQL data analysis learned through various casesCourse Thumbnail

          SQL data analysis learned through various cases

          dooleyz3525

          $68.20

          Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

          4.9

          (54)

          1,600+
          [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

          [MMORPG Game Development Series with C# and Unity] Part 5: Database

          Rookiss

          $34.10

          Basic / SQL, DBMS/RDBMS

          4.9

          (137)

          3,900+
          Active Replies
          Active Replies

          This is a course for learning MS-SQL through baseball and corporate databases.

          Basic

          Basic

          SQL, DBMS/RDBMS

          [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

          [MMORPG Game Development Series with C# and Unity] Part 5: Database

          Rookiss

          $34.10

          Basic / SQL, DBMS/RDBMS

          4.9

          (137)

          3,900+
          Active Replies
          Active Replies
          Database SQL CourseCourse Thumbnail

          Database SQL Course

          vmproductor0202

          Free

          Beginner / SQL, Oracle, Java

          4.5

          (169)

          5,200+

          Learn how to save, modify, delete, and query data in a database. Anyone, regardless of major, can easily follow along in just 30 minutes.

          Beginner

          Beginner

          SQL, Oracle, Java

          Database SQL CourseCourse Thumbnail

          Database SQL Course

          vmproductor0202

          Free

          Beginner / SQL, Oracle, Java

          4.5

          (169)

          5,200+
          High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

          High-Performance SQL for JPA (ORM) Developers

          Vlad Mihalcea

          $176.00

          Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

          4.9

          (32)

          600+

          Make the most of relational database systems!

          Intermediate

          Intermediate

          SQL, performance-tuning, sql-query

          High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

          High-Performance SQL for JPA (ORM) Developers

          Vlad Mihalcea

          $176.00

          Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

          4.9

          (32)

          600+
          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]Course Thumbnail

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

          Hong

          $50.60

          Beginner / Java, SQL, MySQL, MongoDB, database

          4.1

          (13)

          100+

          This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

          Beginner

          Beginner

          Java, SQL, MySQL

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]Course Thumbnail

          The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

          Hong

          $50.60

          Beginner / Java, SQL, MySQL, MongoDB, database

          4.1

          (13)

          100+
          Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]Course Thumbnail

          Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]

          youngcodikimssam

          $133.10

          Beginner / Java, JSP, Spring, SQL, oop

          From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

          Beginner

          Beginner

          Java, JSP, Spring

          Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]Course Thumbnail

          Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]

          youngcodikimssam

          $133.10

          Beginner / Java, JSP, Spring, SQL, oop

          Do it! SQL IntroductionCourse Thumbnail

          Do it! SQL Introduction

          easyspub

          Free

          Beginner / SQL

          4.6

          (68)

          3,100+

          A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

          Beginner

          Beginner

          SQL

          Do it! SQL IntroductionCourse Thumbnail

          Do it! SQL Introduction

          easyspub

          Free

          Beginner / SQL

          4.6

          (68)

          3,100+
          3. Web Development Course [Spring Framework + e-Government Standard Framework]Course Thumbnail

          3. Web Development Course [Spring Framework + e-Government Standard Framework]

          vmproductor0202

          $59.40

          Beginner / Spring, eGovFrame, spring-framework, Oracle, Java

          4.2

          (54)

          600+

          This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

          Beginner

          Beginner

          Spring, eGovFrame, spring-framework

          3. Web Development Course [Spring Framework + e-Government Standard Framework]Course Thumbnail

          3. Web Development Course [Spring Framework + e-Government Standard Framework]

          vmproductor0202

          $59.40

          Beginner / Spring, eGovFrame, spring-framework, Oracle, Java

          4.2

          (54)

          600+
          DBT with a Silicon Valley EngineerCourse Thumbnail

          DBT with a Silicon Valley Engineer

          altoformula

          $34.10

          Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

          4.8

          (17)

          300+
          Active Replies
          Active Replies

          Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

          Basic

          Basic

          SQL, Data Engineering, data-analysis

          DBT with a Silicon Valley EngineerCourse Thumbnail

          DBT with a Silicon Valley Engineer

          altoformula

          $34.10

          Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

          4.8

          (17)

          300+
          Active Replies
          Active Replies
          Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

          Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

          Masocampus

          $69.30

          23%

          $52.80

          Beginner / SQL, SQLD

          4.4

          (18)

          200+
          Active Replies
          Active Replies

          Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

          Beginner

          Beginner

          SQL, SQLD

          Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

          Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

          Masocampus

          $69.30

          23%

          $52.80

          Beginner / SQL, SQLD

          4.4

          (18)

          200+
          Active Replies
          Active Replies

          25% off for new members

          $20.80

          25%

          $30.80