inflearn logo

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 15 reviews

155 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

장창욱

31% enrolled

I am enjoying your content. Thank you.

5.0

Illay

61% enrolled

Okay.

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

Career Verified

1,274

Learners

103

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

15 reviews

4.9

15 reviews

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

    • jangcw12048179님의 프로필 이미지
      jangcw12048179

      Reviews 5

      Average Rating 5.0

      5

      31% enrolled

      I am enjoying your content. Thank you.

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

        • javaspecialist님의 프로필 이미지
          javaspecialist

          Reviews 8

          Average Rating 5.0

          5

          98% enrolled

          Best Oracle SQL Course!!~~~

          Similar courses

          Explore other courses in the same field!

          Limited time deal ends in 5 days

          $22.00

          28%

          $30.80