강의

N
챌린지

멘토링

N
클립

로드맵

Programming

/

Database

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.8) 17 reviews

167 learners

Level Basic

Course period Unlimited

SQL
SQL
Oracle
Oracle
SQL
SQL
Oracle
Oracle

Reviews from Early Learners

4.8

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,328

Learners

110

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

17 reviews

4.8

17 reviews

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

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

    • javaspecialist님의 프로필 이미지
      javaspecialist

      Reviews 8

      ∙

      Average Rating 5.0

      5

      98% enrolled

      Best Oracle SQL Course!!~~~

      • jangcw12048179님의 프로필 이미지
        jangcw12048179

        Reviews 5

        ∙

        Average Rating 5.0

        5

        31% enrolled

        I am enjoying your content. Thank you.

        • illay님의 프로필 이미지
          illay

          Reviews 2

          ∙

          Average Rating 5.0

          5

          61% enrolled

          Okay.

          Similar courses

          Explore other courses in the same field!

          SQL tuning for immediate use in businessCourse Thumbnail

          SQL tuning for immediate use in business

          7e7ey

          In this lecture, you will learn the basic terms and principles of query tuning for MySQL/MariaDB, and then improve your tuning skills by analyzing dozens of malicious queries.

          Basic

          Basic

          MySQL, SQL, MariaDB

          SQL tuning for immediate use in businessCourse Thumbnail

          SQL tuning for immediate use in business

          7e7ey

          Oracle PL/SQL Just This Much.. [Concept + Practice]Course Thumbnail

          Oracle PL/SQL Just This Much.. [Concept + Practice]

          itpaul

          This course provides developers/operators using Oracle with PL/SQL concepts and practical skills that can be immediately applied in the field.

          Basic

          Basic

          PL/SQL, SQL, Oracle

          Oracle PL/SQL Just This Much.. [Concept + Practice]Course Thumbnail

          Oracle PL/SQL Just This Much.. [Concept + Practice]

          itpaul

          Do it! Introduction to SQL with Oracle - Taught by the AuthorCourse Thumbnail

          Do it! Introduction to SQL with Oracle - Taught by the Author

          groovysunday

          Based on Oracle 21C, from concepts to practice, the easiest way to learn SQL for beginners! Taught directly by the author of Easyspub's "Do it! Introduction to SQL with Oracle"! Designed for non-majors and beginners, explained step by step.

          Beginner

          Beginner

          SQL, Oracle, DBMS/RDBMS

          Do it! Introduction to SQL with Oracle - Taught by the AuthorCourse Thumbnail

          Do it! Introduction to SQL with Oracle - Taught by the Author

          groovysunday

          Smart SQL Learning Methods in the AI Era [Introductory]Course Thumbnail

          Smart SQL Learning Methods in the AI Era [Introductory]

          tani

          I learned it the hard way, but I want you to learn it easily. I've discarded unnecessary theories and included only the core essentials of SQL. Build your SQL confidence quickly.

          Beginner

          Beginner

          SQL, MySQL, DBMS/RDBMS

          Smart SQL Learning Methods in the AI Era [Introductory]Course Thumbnail

          Smart SQL Learning Methods in the AI Era [Introductory]

          tani

          High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

          High-Performance SQL for JPA (ORM) Developers

          Vlad Mihalcea

          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

          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

          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

          Do it! SQL IntroductionCourse Thumbnail

          Do it! SQL Introduction

          easyspub

          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

          DBT with a Silicon Valley EngineerCourse Thumbnail

          DBT with a Silicon Valley Engineer

          altoformula

          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

          Introduction to BigQuery (SQL) for BeginnersCourse Thumbnail

          Introduction to BigQuery (SQL) for Beginners

          kyleschool

          This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

          Basic

          Basic

          SQL, Google Cloud Platform, bigquery

          Introduction to BigQuery (SQL) for BeginnersCourse Thumbnail

          Introduction to BigQuery (SQL) for Beginners

          kyleschool

          PostgreSQL for Silicon Valley AI Developers Handling 200 Billion+ Data RecordsCourse Thumbnail

          PostgreSQL for Silicon Valley AI Developers Handling 200 Billion+ Data Records

          Hong

          This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

          Beginner

          Beginner

          MySQL, PostgreSQL, Oracle

          PostgreSQL for Silicon Valley AI Developers Handling 200 Billion+ Data RecordsCourse Thumbnail

          PostgreSQL for Silicon Valley AI Developers Handling 200 Billion+ Data Records

          Hong

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

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

          Rookiss

          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

          SQL data analysis learned through various casesCourse Thumbnail

          SQL data analysis learned through various cases

          dooleyz3525

          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

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

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

          vmproductor0202

          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

          FastAPI Complete GuideCourse Thumbnail

          FastAPI Complete Guide

          dooleyz3525

          This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

          Intermediate

          Intermediate

          Python, FastAPI, SQL

          FastAPI Complete GuideCourse Thumbnail

          FastAPI Complete Guide

          dooleyz3525

          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

          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