강의

멘토링

커뮤니티

Programming

/

Database

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 13 reviews

139 learners

Level Basic

Course period Unlimited

  • javaspecialist
SQL
SQL
Oracle
Oracle
SQL
SQL
Oracle
Oracle

Reviews from Early Learners

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

1,131

Learners

85

Reviews

9

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

    • smlee7574님의 프로필 이미지
      smlee7574

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • hyunseoung8142님의 프로필 이미지
        hyunseoung8142

        Reviews 2

        Average Rating 5.0

        5

        32% enrolled

        • illay님의 프로필 이미지
          illay

          Reviews 2

          Average Rating 5.0

          5

          61% enrolled

          Okay.

          • sblee6967님의 프로필 이미지
            sblee6967

            Reviews 2

            Average Rating 5.0

            5

            32% enrolled

            $30.80

            javaspecialist's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!