강의

멘토링

커뮤니티

Programming

/

Database

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 11 reviews

133 learners

  • javaspecialist
이론 실습 모두
도커
SQL
Oracle

Reviews from Early Learners

What you will gain after the course

  • Oracle Database SQL

  • Installing Oracle Database and Configuring a Practice Environment Using Docker

  • Data retrieval using SELECT

  • Oracle functions (characters, numbers, dates, regular expression functions, conversion functions, set operators)

  • Data aggregation using GROUP BY and group functions

  • Analytical function, window clause, linear regression function, 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

  • Creating and Managing Views

  • Sequence, Index, Synonym

Do you want to become a developer?

Learning SQL statements to manage database data is the beginning of being a developer. Learn SQL statements 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 training 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 step.

📌Teaches the essential technologies that backend developers must learn.

I recommend this for people like this

I want to learn about databases.

Oracle SQL database is the most widely used in enterprises.

I'm getting 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?
Challenge yourself to get the SQLD certification after completing your studies.

The person who created this course

  • Java Expert Group Administrator (javaspecialist.co.kr)

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


  • Information Technology Development, Information Technology Strategic Planning, AI Training Instructor

💡 This lecture is...

  • Taught by a 2021 Information and Communication Technology Star Training Instructor recognized by the Ministry of Employment and Labor.

  • Taught by professional instructors who have perfect foundational knowledge and extensive real-world project experience.


Pre-enrollment Reference Information

Practice Environment

  • We will install a database on Windows using Docker.

  • Learn SQL syntax using Oracle's SQL Developer.

  • Even Mac users can use databases by installing Docker.

Learning Materials

Prerequisites and Important Notes

  • You just need to have an interest in programming languages and the confidence to complete the course to the end.

💡Please write detailed reference information needed for learning the course.
This helps students fully understand the content covered in the course and increases 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 Important 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,114

Learners

78

Reviews

9

Answers

4.8

Rating

8

Courses

자바전문가그룹(JavaSpecialist.co.kr)이 인공지능의 성장을 지원합니다.

Curriculum

All

57 lectures ∙ (14hr 57min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

11 reviews

4.9

11 reviews

  • 자바전문가그룹님의 프로필 이미지
    자바전문가그룹

    Reviews 8

    Average Rating 5.0

    5

    98% enrolled

    최고의 오라클 SQL 강의!!~~~

    • 이수민님의 프로필 이미지
      이수민

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • hyun.seoung님의 프로필 이미지
        hyun.seoung

        Reviews 2

        Average Rating 5.0

        5

        32% enrolled

        • Illay님의 프로필 이미지
          Illay

          Reviews 2

          Average Rating 5.0

          5

          61% enrolled

          Good

          • sb_lee님의 프로필 이미지
            sb_lee

            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!