강의

N
챌린지

멘토링

N
클립

커뮤니티

Programming

/

Database

Oracle SQL Database

Learn Oracle Database SQL syntax.

(4.9) 12 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,116

Learners

79

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

12 reviews

4.9

12 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

            Limited time deal ends in 8 days

            $27,720.00

            30%

            $30.80

            javaspecialist's other courses

            Check out other courses by the instructor!

            Python Programming from the Ground UpCourse Thumbnail

            Python Programming from the Ground Up

            javaspecialist

            A star instructor in IT development, artificial intelligence, and IT strategic planning provides an easy, detailed, and accurate explanation of the Python programming language.

            Basic

            Basic

            Python, Coding Test, programming-languages

            Python Programming from the Ground UpCourse Thumbnail

            Python Programming from the Ground Up

            javaspecialist

            Python library for data analysis and EDACourse Thumbnail

            Python library for data analysis and EDA

            javaspecialist

            We will cover the major Python libraries that you must learn to become a data analysis expert.

            Basic

            Basic

            Numpy, Pandas

            Python library for data analysis and EDACourse Thumbnail

            Python library for data analysis and EDA

            javaspecialist

            Web Data Collection Techniques (Web Crawling) Used in PracticeCourse Thumbnail

            Web Data Collection Techniques (Web Crawling) Used in Practice

            javaspecialist

            Explanation of web data collection techniques using Python. Explanation of web data scraping using the latest technologies.

            Basic

            Basic

            Web Crawling, Web Scraping, browser-automation

            Web Data Collection Techniques (Web Crawling) Used in PracticeCourse Thumbnail

            Web Data Collection Techniques (Web Crawling) Used in Practice

            javaspecialist

            Development of AI web service using ChatGPT APICourse Thumbnail

            Development of AI web service using ChatGPT API

            javaspecialist

            This article explains how to develop an AI web service using the API from OpenAI.

            Basic

            Basic

            ChatGPT, AI, openAI API

            Development of AI web service using ChatGPT APICourse Thumbnail

            Development of AI web service using ChatGPT API

            javaspecialist

            Connecting a Java Spring Boot project with a Python AI projectCourse Thumbnail

            Connecting a Java Spring Boot project with a Python AI project

            javaspecialist

            Explaining how to connect to a Python-based AI web server using FastAPI from a Spring Boot project.

            Intermediate

            Intermediate

            Spring Boot, FastAPI, yolo

            Connecting a Java Spring Boot project with a Python AI projectCourse Thumbnail

            Connecting a Java Spring Boot project with a Python AI project

            javaspecialist

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN ArchitecturesCourse Thumbnail

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN Architectures

            javaspecialist

            We will introduce how to create deep learning models and CNN models using artificial neural network algorithms.

            Basic

            Basic

            Tensorflow, Artificial Neural Network, CNN

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN ArchitecturesCourse Thumbnail

            Understanding and Implementing Artificial Neural Network Theory and DNN, CNN Architectures

            javaspecialist

            Java Programming from the BasicsCourse Thumbnail

            Java Programming from the Basics

            javaspecialist

            A star trainer in IT development, artificial intelligence, and IT strategic planning provides an easy, detailed, and accurate explanation of the fundamentals of the Java programming language.

            Beginner

            Beginner

            Java, oop

            Java Programming from the BasicsCourse Thumbnail

            Java Programming from the Basics

            javaspecialist

            Similar courses

            Explore other courses in the same field!

            PYTHON written like SQLCourse Thumbnail

            PYTHON written like SQL

            pbj0812

            You can learn how to handle data frames (tables) using Python, similar to the SELECT statement in SQL.

            Basic

            Basic

            Python, SQL, Pandas

            PYTHON written like SQLCourse Thumbnail

            PYTHON written like SQL

            pbj0812

            Jaeseong Yoon's Oracle SQL Database 11g PL/SQL DeveloperCourse Thumbnail

            Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

            softcampus

            Easy explanations and examples are provided so that you can apply them directly to your work.

            Basic

            Basic

            SQL, Oracle, PL/SQL

            Jaeseong Yoon's Oracle SQL Database 11g PL/SQL DeveloperCourse Thumbnail

            Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

            softcampus

            [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

            [Practice Makes Perfect] Intermediate SQL for Data Analysis

            datarian

            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

            Easy to understand, SQL secret recipe for everyoneCourse Thumbnail

            Easy to understand, SQL secret recipe for everyone

            mktcrmer8678

            A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

            Basic

            Basic

            SQL, Big Data, Data Engineering

            Easy to understand, SQL secret recipe for everyoneCourse Thumbnail

            Easy to understand, SQL secret recipe for everyone

            mktcrmer8678

            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

            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

            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

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

            youngcodikimssam

            From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

            Beginner

            Beginner

            Java, JSP, Spring

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

            Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

            youngcodikimssam

            [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 course teaches MS-SQL through baseball/company 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

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

            Masocampus

            From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

            Beginner

            Beginner

            SQL, SQLD

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

            SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

            Masocampus

            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